A Comprehensive Survey on Root Cause Analysis in (Micro) Services: Methodologies, Challenges, and Trends