Sonarqube upgrade to 9.9-enterprise edition. issue

SonarQube Server / Community Build
1

Make sure to tell us:

  • What version are you upgrading from? 9.6
  • System information (Operating system, Java version, Database provider/version): Linux/UNIX, we are using docker image
  • What’s the issue you’re facing?

Hi @ nathan.eldridge@sonarsource.com

I am trying to upgrade the SonarQube server from the 9.6.0-enterprise version to 9.9-enterprise but seems the upgrade is failing for me.

We used to upgrade the version just by changing the image tag into docker-compose.yaml file. This time post upgrade we are losing our existing database connectivity/data with the SQ.

Post upgrade getting the SQ server up and running but with a fresh database. Obviously this we don’t want. can you please help us.

2

Hey there.

How is your docker-compose.yaml file configured? Feel free to post it here.

3

Hi @Colin @nathan.eldridge ,

here is the docker-compose file


version: "2"

services:
  sonarqube:
    image: sonarqube:9.9.0-enterprise
    ports:
      - "9000:9000"
    networks:
      - sonarnet
    environment:
      - sonar.jdbc.url=jdbc:postgresql:******/sonar
      - SONARQUBE_JDBC_USERNAME=hiden
      - SONARQUBE_JDBC_PASSWORD=hiden
    volumes:
      - sonarqube_conf_new:/opt/sonarqube/conf
      - sonarqube_data_new:/opt/sonarqube/data
      - sonarqube_extensions_new:/opt/sonarqube/extensions
    ulimits:
      nofile:
        soft: 65536
        hard: 65536
      memlock:
        soft: -1
        hard: -1

  db-staging:
    image: postgres
    networks:
      - sonarnet
    environment:
      - POSTGRES_USER=hiden
      - POSTGRES_PASSWORD=hiden
    volumes:
      - postgresql:/var/lib/postgresql
      # This needs explicit mapping due to https://github.com/docker-library/postgres/blob/4e48e3228a30763913ece952c611e5e9b95c8759/Dockerfile.template#L52
      - postgresql_data:/var/lib/postgresql/data
      - postgresql_backup:/var/lib/postgresql/backup

networks:
  sonarnet:
    driver: bridge

volumes:
  sonarqube_conf_new:
  sonarqube_data_new:
  sonarqube_extensions_new:
  postgresql:
  postgresql_data:
  postgresql_backup:
4

As noted in the upgrade notes

  • The deprecated SONARQUBE_JDBC_USERNAME, SONARQUBE_JDBC_PASSWORD, and SONARQUBE_JDBC_URL variables have been removed. See Environment variables for up-to-date configuration variables.

I would revisit this configuration:

5

As mentionned you should rename those configuration with the following one:

SONAR_JDBC_USERNAME=
SONAR_JDBC_PASSWORD=