SonarQube migration script #1908 runs forever (DeletePersonAndFileMeasures)

0
votes

I'm trying to upgrade SonarQube from latest 6.7.1 version to 7.0. We are using Oracle. The database script "#1908 'Delete person and file measures'..." runs forever.

https://github.com/SonarSource/sonarqube/blob/c0d2705e610d771b8c66ef22e64530c7bca4f538/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v70/DeletePersonAndFileMeasures.java#L49-L56

We have 4874 rows in the snapshots table and 12.8 million rows in the project_measures table. In the projects table we have 350.000 rows.

Anybody experienced this ??

1
sonarqubesonarqube-ops

1 Answers

0
votes

Slowness of this DB migration has been fixed in 7.1: https://jira.sonarsource.com/browse/SONAR-10504. Note that this version has not been released at the time of writing. It's planned for middle of April.