Upgrade sonarqube developer DockerCompose from 8.9 to 9.9 LTS using Postgres DB

SonarQube Server / Community Build
1

My concern is that if I upgrade to a higher version, SQ wont be able to talk to the Postgres DB anymore. I want to know what is the best approach to perform this upgrade. Here’s what the relevant Dockercompose code looks like.

version: "3.7"

services:
  sonarqube:
    image: sonarqube:lts-developer
    restart: unless-stopped
    depends_on:
      - db

    environment:
      - sonar.jdbc.username=XXXXXX
      - sonar.jdbc.password=XXXXXXXXXXXXX
      - sonar.jdbc.url=jdbc:postgresql://db:5432/sqdevschema
    volumes:
      - ./sonarqube/sq/sonarqube_data:/home/sonarqube/data
      - ./sonarqube/sq/sonarqube_extensions:/home/sonarqube/extensions
      - ./sonarqube/sq/sonarqube_logs:/home/sonarqube/logs
      - ./sonarqube/sq/sonarqube_bundled-plugins:/opt/sonarqube/lib/bundled-plugins
      - ./sonarqube/sq/temp:/var/sonarqube/temp
      - ./sonarqube/sq/data:/var/sonarqube/data
    ports:
      - "9000:9000"

  db:
    image: postgres:latest
    restart: unless-stopped
    environment:
      - sonar.jdbc.username=XXXXXX
      - sonar.jdbc.password=XXXXXXXXXX
      - sonar.jdbc.url=jdbc:postgresql://db:5432/sqdevschema
    volumes:
      - ./db/postgresql:/var/lib/postgresql
      - ./db/postgresql_data:/var/lib/postgresql/data
    ports:
      - "5432:5432"
2

Hey there.

Make sure you’re using the supported environment variables for configuring the database connection.

3

Thanks Colin for your advice, what about for specifying the release version on the dockercompose.yml file? Will that work ?

4

I don’t quite understand what you mean. Can you share an example?

5

So my currently dockercompose version is as followed:

services:
sonarqube:
image: sonarqube:lts-developer

When I changed it to explicitly add a version like so, it doesn’t work

services:
sonarqube:
image: sonarqube:9.9.1-developer

When I login to SQ I see the version under Administration > System - still shows Version 8.9.7.52159

How do I force docker compose to download the specified version ?

Thanks for your help

6

That should be correct. Have you performed a docker compose down and. docker compose up?

7

Yes Colin I have, I already tried docker compose down and. docker compose up it just wont upgrade :confused:

8

So @Colin I found something odd. When I apply the new release version, I can see in the logs the new sonar-application-9.9.1.69595.jar file is running, however when I login to the web console and check the version, it still shows the old version, any ideas why ?

image

image
image1814×74 25 KB

9

My instinct would be that the logs you’re seeing don’t actually correspond to the SonarQube service that’s running (that you’re accessing via the web browser), or that you have both services running simultaneously.

Instead of sharing screenshots of logs, can you share the full logs from when you run docker compose up?