Postgress - 9.6 Hello All , While I am doing a upgrade , I am getting below error , Can some one please help me. It looks like something is missing , when I am setting up in browser , Database Upgrade failed and logs are below 2020.11.09 10:26:20 ERROR web[][DbMigrations] #1942 'Add live_measures.…

Hi, This should help: [image] Upgrade SonarQube version 6.7.2 (build 37468) to version 7.9.1 failed in migration step SonarQube Hi, Welcome to the community. As discussed here: This error is caused by the presence in your database of projects that have not been analy…

Thank you … Can you please provide step by steps , How to analyze the projects and delete the projects after upgrade , This is a show stopper for us , Can you please help

Did you follow the breadcrumb trail? It leads to SONAR-12282 , which gives you SQL to identify the problem projects. Ann

I tried it , It didnt work … also my JDBC postgress looks like this , is it right ? sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube?currentSchema=my_schema

Hi, Your JDBC URL shouldn’t have an impact. Ann

Yep , I tried that query. It still didn’t work for me. is there any thing else i need to look at ? Please help. TIA

Upgrade from 6.7.4 to 7.9.4 LTS

SonarQube Server / Community Build

ganncamp (G Ann Campbell) November 9, 2020, 7:49pm 2

Hi,

This should help:

Ann

Topic		Replies	Views
Upgrade sonarqube from 6.7.7 to 7.9.1 Failed SonarQube Server / Community Build sonarqube , database , upgrade , postgres , migration	4	1692	November 14, 2019
Error upgrading 7.9.4 to 8.7.0.41497 (Developer Edition) SonarQube Server / Community Build sonarqube , upgrade , postgres , sales_team_notified	2	983	March 19, 2021
Upgrade SonarQube version 6.7.2 (build 37468) to version 7.9.1 failed in migration step SonarQube Server / Community Build sonarqube	2	1243	July 23, 2019
Upgrade from 6.7.3 to 7.9 (LTS) -> Fail to execute CREATE UNIQUE INDEX live_measures_component SonarQube Server / Community Build sonarqube , database , oracle , migration	6	3415	November 14, 2019
Postgres Database upgrading Fails when Upgrading Sonarqube SonarQube Server / Community Build postgres , bug-no-category	3	1894	May 8, 2020

Upgrade from 6.7.4 to 7.9.4 LTS

Related topics