Upgrading from 9.6 to 9.9 with error "The database must be manually upgraded"

Hello all,

I found many suggestions for the probl. and tried all these, but the probl remains …

Actually I have the 9.6 → it works well

I’d like to upgrade to the 9.9.2 on the same server, with the same Database, thus :
I download the .Zip file,
unzip in another fresh directory (D:\sonarqube\sonarqube-9.9.2.77730)
update the contents of NEW sonar.properties file with the settings of the old,
stop the old
start the new in Dos : D:\sonarqube\sonarqube-9.9.2.77730\bin\windows-x86-64\StartSonar.bat to test the upgrade
and got the following error messages in the log :

2023.11.08 15:06:22 INFO web[o.s.s.p.Platform] Database needs to be migrated. Please refer to https://docs.sonarqube.org/latest/setup/upgrading
2023.11.08 15:06:22 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@615439f7 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, …], exclusions=[/api/components/update_key, …]}]
2023.11.08 15:06:22 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2023.11.08 15:07:09 INFO web[o.s.p.ProcessEntryPoint] Gracefully stopping process
2023.11.08 15:07:09 INFO web[c.z.h.HikariDataSource] HikariPool-1 - Shutdown initiated…
2023.11.08 15:07:09 INFO web[c.z.h.HikariDataSource] HikariPool-1 - Shutdown completed.
2023.11.08 15:07:09 INFO web[o.s.s.app.WebServer] Web Server stopped

On the Dos windows, it stucks with :
2023.11.08 15:06:18 WARN app[startup] ################################################################################
2023.11.08 15:06:18 WARN app[startup] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading
2023.11.08 15:06:18 WARN app[startup] ################################################################################

  • What version are you upgrading from? from 9.6 to 9.9.2
  • System information (Operating system, Java version, Database provider/version) :
    Windows 2019,
    Java java version “17.0.4.1” 2022-08-18 LTS
    Java™ SE Runtime Environment (build 17.0.4.1+1-LTS-2)
    Java HotSpot™ 64-Bit Server VM (build 17.0.4.1+1-LTS-2, mixed mode, sharing)
    PostgresSQL 14

Changing sonar.web.context to /sonarqube did not resolve the issue.
As SonarQuBe not started, the URL http://:9000/sonarqube/setup gives nothing

Our DBA already done these cmd on the DB, but nothing changes…
VACUUM FULL
REINDEX DATABASE
ANALYZE

Thank you for your help,
L.H

Hi,

Welcome to the community!

What do you make of that:

 
Ann