Ericsson / codechecker

CodeChecker is an analyzer tooling, defect database and viewer extension for the Clang Static Analyzer and Clang Tidy
https://codechecker.readthedocs.io
Apache License 2.0
2.15k stars 357 forks source link

[Fix] Drop foreign key constraints for faster analysis info deleting #4259

Closed cservakt closed 3 weeks ago

cservakt commented 3 weeks ago

Dropping foreign key constraints of run_history_analysis_info and report_analysis_info tables before removing dangling analysis info and re-adding them after the deletion.

It is a temporary fixing to avoid several hours of garbage collection run time during the upgrade. A corrected new DB schema would be a permanent solution.