Postgres Database upgrading Fails when Upgrading Sonarqube

[ganncamp (G Ann Campbell)]

Hi,

Where did you start your upgrade journey? Could it be that you have projects unanalyzed since 5.6? The specific error is different in this thread, but it strikes a chord:

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

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

 
Ann