Sonarqube upgrade issues from 9.7.1 to 9.9.1 LTS

Hi,

While we are upgrading the sonarqube application from 9.7.1 to 9.9.1 in prod , we faced DB errors and couldn’t proceed ,UI was not loading and we couldn’t see any setup page to upgrade DB

Details :

  • What version are you upgrading from: 9.7.1 to 9.9.1 LTS
  • System information (Operating system, Java version - 11, Database: PostgreSQL - 13.8 )
  • What’s the issue you’re facing? - while upgrading getting issues with DB

error :

tps.proxyPort=3128 -cp ./lib/sonar-application-9.9.1.69595.jar:/apps/sonarqube-9.9.1.69595/lib/jdbc/postgresql/postgresql-42.5.1.jar org.sonar.server.app.WebServer /apps/sonarqube_latest/temp/sq-process6873702825567780405properties
2023.10.12 05:17:22 WARN  app[][startup] ################################################################################
2023.10.12 05:17:22 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.10.12 05:17:22 WARN  app[][startup] ################################################################################

i don’t see any setup page in UI for upgrading Database , how should I proceed next

Hi,

it is not an error, but normal when database changes with an update.
Just browse https://<yoursonarhost/setup and confirm the update.

Gilbert

I tried to set up via that page but my UI didn’t load.
is there anything that we need to manually

Didn’t see that before, Sonarqube 9.9 needs to run with Java 17.
I’m surprised you got this far with Java 11 at all !?

Did you already check the other logs in $SONARQUBE_HOME/logs ?