Db cleaner not working

SonarQube
1

  • The size of the live_measures.ibd file in our mysql database has grown too large. We are looking for a solution but cannot find it. We shortened the duration of db cleaning operations on sonar, but the database size did not decrease.

  • Community Edition

  • Version 7.4 (build 18908)

2

Hello
SonarQube 7.4 is an old, unsupported version and mysql is no longer a supported database engine for SonarQube.

Your priority should be to upgrade to the currently supported version e.g. 8.9 LTS. I would suggest you:

  • do the manual housekeeping by identifying inactive projects e.g. with api/projects/search?analyzedBefore=YYYY-MM-DD and delete them to liberate space
  • perform a migration to one of the currently supported DB engines (SQL Server, Postgres or Oracle) using mysql-migrator
  • upgrade to 8.9 LTS

Best,
Michal

1 Like