Hi all, in our company we upgraded from SonarQube 9.8 to SQ 9.9 LTS. But all went bad. We use a postgres DB that was completely destroyed by the new instance. Moreover the ID changed (without any explainable reason) and now we are unable to use the postgres DB.
DB Postgres 14.5 (via Docker image)
The command lines we use are:
to launch the postgres docker: docker run --restart unless-stopped --name sonar-postgres -e POSTGRES_USER=user -e POSTGRES_PASSWORD=pwd -p 5432:5432 --network sonarqube_network -d postgres
What did you give SonarQube permissions to? In your DB upgrade, I’d have expected you to retain the same SQ schema, data, user and permissions. I’m not aware of any circumstance in which SonarQube would wipe out its own schema, much less the entire DB. I suspect some other process went awry here.
And since you’ve said that SonarQube didn’t connect to the DB and your log shows that H2 is in use… I don’t think there are any reasons to blame SonarQube here.