Recursive Hierarchical Data Reconstruction Algorithm

Develop a recursive Common Table Expression (CTE) in MySQL that can reconstruct complex hierarchical organizational data with infinite depth levels. The solution must handle scenarios where employee reporting structures have multiple potential paths, circular references, and historical organizational changes. Implement a robust error detection mechanism that identifies and reports potential data integrity issues during the recursive traversal.