Upgraded from 9.1.0.47736 -> 9.6.1.59531. Service will not stay running

SonarQube
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    — Upgraded from 9.1.0.47736 → 9.6.1.59531
  • how is SonarQube deployed: zip, Docker, Helm
    —ZIP
  • what are you trying to achieve
    —UPGRADE
  • what have you tried so far to achieve this
    — Went through the upgrade-guide. Tried to start the service, it starts and then stops seconds later. The web.log indicates “Fail to connect to database”

Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

[web.log]

2023.04.03 15:23:06 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2023.04.03 15:23:06 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process
2023.04.03 15:25:07 INFO  web[][o.s.p.ProcessEntryPoint] Starting Web Server
2023.04.03 15:25:08 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.6.1.59531 / 7398ee51f5da9a64ea123c98c5225aa5c41f700c
2023.04.03 15:25:08 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://10.142.120.110;databaseName=SonarQube
2023.04.03 15:25:08 WARN  web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@277050dc-org.sonar.db.DefaultDatabase': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
2023.04.03 15:25:08 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
2

I’m a little farther along…
I added trustServerCertificate=true to the JDBC URL connection string and the service came up and stayed up. I was able to go through the setup and update the database.
However, I lost my azure settings for SSO.

3

I had forgotten that there was a plugin for the Azure config. I copied that to the new folder and was able to finish my upgrade.

4

Hi,

I’m glad you worked through this. Just don’t forget to keep going to at least SonarQube 9.9 LTS.

:warning: Make sure you upgrade to SonarQube v9.9 LTS soon, not only to benefit from our Best LTS Ever™, but because soon we will systematically ask users to upgrade when they ask questions about earlier versions of SonarQube, which are now considered unsupported. :smiley:

 
Ann

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.