Rollback merge request (208741) (Fix Tool Coverage data update when all projects are archived)
Problem
MR !208741 (merged) introduced a UNION ALL
clause to fix Tool Coverage statistics when all projects are archived. However, this change caused:
- Query timeouts in production
- Significant performance degradation
Action Required
- Immediate: Revert MR !208741 (merged) via MR !209643 (merged) to restore performance
- Follow-up: Develop alternative solution to fix the original archived projects bug without performance impact - Tool Coverage data not updated when archiving l... (#572794) • Nicolae Rotaru • 18.6 has been re-opened for the follow-up
Impact
- Priority: Production stability over edge case bug fix
- Trade-off: Reintroduces original issue where Tool Coverage stats aren't reset when all projects archived
- Timeline: Rollback needed urgently to prevent continued timeouts
Edited by rossfuhrman