Hi, I’m trying to update from SonarQube 6.7.3 to 7.9. I’m on Windows and I use an Oracle database. Sadly, the database migration fails. 2019.07.10 11:34:38 INFO web[][DbMigrations] #1941 'Populate table live_measures': success | time=792729ms 2019.07.10 11:34:38 INFO web[][DbMigrations] #1942 '…

Hi all, Sorry for the delay in responding. This seems to be caused by projects which have gone unanalyzed since 5.6.*. We’re not planning to put out a fix for this, but this ticket tells you how to work around the issue: SONAR-12282 . HTH, Ann

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…

Hello Ann, thank you for this information. I can confirm that it works. We had a really old Delphi project which we could not scan for years (no working Delphi plugin), but we kept the project because of, well, it was nice to sometimes have a look at the issues that were found. :slight_smile: Afte…

Thank you. All our records returned by the below query belonged to two old projects. Once I deleted those projects, the upgrade was able to progress. 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.u…

Hi Ann, I am facing the exact same issue mentioned above. But when I ran the query given in the workaround (after restoring to 6.7.7) it gives me 0 rows. Can you help me troubleshoot? Thanks Siddhant Gogri

Upgrade from 6.7.3 to 7.9 (LTS) -> Fail to execute CREATE UNIQUE INDEX live_measures_component

SonarQube Server / Community Build

ganncamp (G Ann Campbell) November 14, 2019, 6:54pm 8

@siddhant.gogri your question was answered in the new topic you created. Let’s consider this thread re-closed.

Topic		Replies	Views
Upgrade SonarQube version 6.7.2 (build 37468) to version 7.9.1 failed in migration step SonarQube Server / Community Build sonarqube	2	1241	July 23, 2019
Upgrade sonarqube from 6.7.7 to 7.9.1 Failed SonarQube Server / Community Build sonarqube , database , upgrade , postgres , migration	4	1691	November 14, 2019
SonarQube upgrade to 7.3 version from 6.7.5v SonarQube Server / Community Build sonarqube , database	9	2736	November 26, 2018
Upgrade from 7.9.1 LTS to 8.9.3 LTS -> Fail to execute CREATE UNIQUE INDEX live_measures_component SonarQube Server / Community Build sonarqube	0	671	December 7, 2021
SonarQube 6.7 LTS to 7.6 migration: Execution of migration step #1907 'Populate table live_measures' failed SonarQube Server / Community Build database , migration	5	2472	July 10, 2019

Upgrade from 6.7.3 to 7.9 (LTS) -> Fail to execute CREATE UNIQUE INDEX live_measures_component

Related topics