Issue in SQL DB connection during upgrade from 8.4.1 to 8.9.6LTS

Must-share information (formatted with Markdown):

  • SonarQube-8.4.1 developer edition, SonarQube-8.9.6 developer edition

  • Upgrade sonar server from 8.4.1 developer to 8.9.6 LTS developer

  • Steps:

  • We followed the upgrade instructions from ‘Upgrade Guide | SonarQube Docs’ while upgrading to 8.9.6 lts developer edition.
  • existing sonar instance was configured to run as a service
  • we made the changes to the wrapper.conf and sonar.properties as needed
  • sonar was stopped
  • sc config query was run to point the service to the new sonar instance
  • on starting the service the sonar server does not come up
  • Troubleshooting:
  • On seeing sonar logs we see that the migration is stuck on the step shown in the screen shot attached

  • We monitored the DB and could not see any activity happening

  • We have ensured that the service is running as the user who had db_owner access

  • the current step was left for over an hour with no result

  • jdbc drivers are on system and paths set

  • on commenting the ‘sonar.jdbc.url’ and restarting the service {connecting to a default in memory sonar db} the application was running

  • we suspect that db connection is not happening but no logs are seen

Hi there.

A web.log file should be produced in the /logs directory of your SonarQube installation. Any interesting information in there?