We successfully upgraded from 7.9.2 to 7.9.6LTS and then from 7.9.6LTS to 8.9.6LTS in our Dev env for SonarQube. With an identical DB in prod env along with the same linux install version on different VM, we attempted the same upgrade process. We were successful in 7.9.2 to 7.9.6LTS, but got the following error when we upgraded to 8.9.6LTS.
-bash-4.2$ tail -f sonar.log
…
2022.08.25 18:15:42 WARN app[startup] ################################################################################
2022.08.25 18:15:42 WARN app[startup] The database must be manually upgraded. Please backup the database and browse /setup. For more information: Upgrade Guide | SonarQube Docs
2022.08.25 18:15:42 WARN app[startup] ################################################################################
…
-bash-4.2$ tail -f web.log
…
2022.08.25 18:15:44 INFO web[o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2022.08.25 18:15:44 INFO web[o.s.s.p.Platform] Database needs to be migrated. Please refer to Upgrade Guide | SonarQube Docs
2022.08.25 18:15:44 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@1486837d [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, …], exclusions=[/api/components/update_key, …]}]
2022.08.25 18:15:44 DEBUG web[o.s.s.a.TomcatAccessLog] Tomcat is started
…
Additional information:
- We have no custom plugins
- We have no extra configurations, just OTB setup
- The SonarQube config settings indicate that the SQL DB JDBC version driver is different, but our companies SQL DB admins indicate that this is most likely a non-factor in the error.
There is a community posting that similar to this issue, but it was not clear and how to resolve:
"Database must be manually upgraded" message
- The linux admin did append /setup to the web URL, but no option was presented to manually update the DB.
Can someone please assist in resolving this error?
Thanks for any response. Much appreciated…