Sonarqube not picking DB configuration and starting with embedded H2 DB

SonarQube 9.9 LTS Upgrade
1
  • What version are you upgrading from?
    I am testing Installation of 9.9 LTS version right now.
  • System information (Operating system, Java version, Database provider/version)
    OS: redhat:enterprise_linux:7.7 (16 cores and 62GB RAM)
    Java Version: Java17
    Database Provider: Postgres (11.18)
  • What’s the issue you’re facing?

I am trying to install Sonar 9.9 on Kubernetes but while creating the pods I can see in logs that it is picking up embedded DB instead of the Postgres DB.

“”/

2023.03.29 07:57:45 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar;NON_KEYWORDS=VALUE
2023.03.29 07:57:52 INFO web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2023.03.29 07:57:52 INFO web[][DbMigrations] Executing DB migrations…
2023.03.29 07:57:54 INFO web[][DbMigrations] Executed DB migrations: success | time=2649ms
2023.03.29 07:59:26 INFO ce[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar;NON_KEYWORDS=VALUE

“”/

even though pod is running and its up, its still not taking it:

NAME READY STATUS RESTARTS AGE
nine-postgresql-0 1/1 Running 0 26m
nine-sonarqube-6b69877f65-26m2p 1/1 Running 0 26m

When I try to install 8.9 LTS the same way, its taking postgres DB without any issue >>

NAME READY STATUS RESTARTS AGE
eightlts-postgresql-0 1/1 Running 0 94m
eightlts-sonarqube-6878b57987-lc2pr 1/1 Running 0 94m

“”/
-bash-4.2$ kubectl logs -f eightlts-sonarqube-6878b57987-lc2pr -n eightlts| grep DB
2023.03.29 06:49:56 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://eightlts-postgresql:5432/sonardb
2023.03.29 06:50:01 INFO web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2023.03.29 06:50:01 INFO web[][DbMigrations] Executing DB migrations…
2023.03.29 06:50:09 INFO web[][DbMigrations] Executed DB migrations: success | time=8131ms
2023.03.29 06:51:02 INFO ce[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://eightlts-postgresql:5432/sonardb
/“”

What could be the issue here? As per official pre-requisites page psql 11 and java 17 is supported.
Any pre-requisites changed from 8.9 to 9.9 version?

2

Hey there.

Are you using this helm chart?

3

Hi Colin,

Thanks for replying.
Yes, We’re using this Yaml file or atleast older version of it as I am seeing many similarities (helm-chart-sonarqube/values.yaml at master · SonarSource/helm-chart-sonarqube · GitHub)

We have existing scripts which help upgrade/ install Sonarqube which basically has these commands (attaching for reference)

helm install -f sonar.yaml -n ${project} --set service.nodePort=${port} --set image.tag=${tag} ${project} sonarqube/.

helm upgrade --recreate-pods -f sonar.yaml -n ${project} --set service.nodePort=${port} --set image.tag=${tag} ${project} sonarqube/.

and its working up until 8.9.10 LTS version without any issue. Only when trying with 9.9 LTS its getting created with embedded DB, when trying to upgrade existing instance we’re losing data even

4

I would first reccomend that you make sure you’re using a compatible version of the helm chart, which right now should be 8.0.0