Setup
I’m having an issue with SonarQube CE 9.9.1 deployed through zip/.jar. SonarQube is connected to a Oracle 19C ADB database.
Goal
Recover database storage by deleting stale projects in SonarQube through UI/API Calls.
It seems that after deleting a (stale) project in the SonarQube webUI the data is not being removed fully from the database. DB table space storage used statistic is not reclaiming any space post deletion.
Verified some of the deleted projects entry in ‘FILE_SOUCES’ table and they are not present in table anymore, however the overall space utilised in the DB is still remain same as before deletion and growing with new scans. Looking for some input on how to improve DB storage utilisation so we don’t hit out of DB space.
Tried already
- Reading other questions regarding this issue on this forum and trying those suggestions.
- Deleting 400+ of the projects that were stale through the SonarQube WebUI
- Adjusting the Housekeeping settings