Is there a recommended solution for this or way forward?
I have come across the same error. Attempting to migrate from SonarQube Version 6.7 (build 33306) to Community Edition Version 7.7 (build 23042) and have come across the same error
2019.07.10 06:11:27 ERROR web[DbMigrations] #1907 ‘Populate table live_measures’: failure | time=100347ms
2019.07.10 06:11:27 ERROR web[DbMigrations] Executed DB migrations: failure | time=100349ms
2019.07.10 06:11:27 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=100519ms
2019.07.10 06:11:27 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration ended with an exception
org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #1907 ‘Populate table live_measures’ failed
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:79)
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:67)
at java.lang.Iterable.forEach(Iterable.java:75)
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:52)
at org.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(MigrationEngineImpl.java:68)
at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doUpgradeDb(DatabaseMigrationImpl.java:105)
at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doDatabaseMigration(DatabaseMigrationImpl.java:80)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: Error during processing of row: [uuid=AWTE3M0S7PL3f_vbbpLK,project_uuid=AWTE3M0S7PL3f_vbbpLK,metric_id=1,value=510732,text_value=null,variation_value_1=-22,measure_data=null]
at org.sonar.server.platform.db.migration.step.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:89)
at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:81)
at org.sonar.server.platform.db.migration.step.MassUpdate.execute(MassUpdate.java:92)
at org.sonar.server.platform.db.migration.version.v70.PopulateLiveMeasures.execute(PopulateLiveMeasures.java:57)
at org.sonar.server.platform.db.migration.step.DataChange.execute(DataChange.java:45)
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75)
… 9 common frames omitted
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CICD_SONARQ.LIVE_MEASURES_COMPONENT) violated
Running the SQL. We have an Oracle database so I have changed “s.islast = TRUE” to “s.islast = 1”
SELECT p.uuid, p.name, p.kee, p.created_at, p.long_name, p.language, pm.metric_id, COUNT(1)
FROM project_measures pm
INNER JOIN projects p on p.uuid = pm.component_uuid
INNER JOIN snapshots s on s.uuid = pm.analysis_uuid
WHERE s.islast = 1 and pm.person_id is null
GROUP BY p.uuid, p.name, p.kee, p.created_at, p.long_name, p.language, pm.metric_id HAVING
COUNT(1) > 1;
Returned over 200,000 records