Database migration fails - postgresql from 9.2 to 9.6

Hello all,

I am attempting to upgrade my sonarqube from 7.1 to 7.9.1 LTS.

I’m not sure if I’m in the right direction but I’ve started this upgrade with the databse upgrade from postgresql 9.2 to 9.6 , but I’ve one issue after that. When I’m trying to start the sonarqube I’ve the following error:

sonar.log:

2019.11.12 18:07:35 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2019.11.12 18:07:36 INFO  app[][o.e.p.PluginsService] no modules loaded
2019.11.12 18:07:36 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
OpenJDK 64-Bit Server VM warning: If the number of processors is expected to increase from one, then you should configure the number of parallel GC threads appropriately using -XX:ParallelGCThreads=N
2019.11.12 18:07:52 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2019.11.12 18:07:52 INFO  app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonar]: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.111-2.b15.el7_3.x86_64/jre/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonar/temp -server -Djava.net.preferIPv4Stack=true -Djava.security.egd=file:/dev/./urandom -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -cp ./lib/common/*:/opt/sonar/lib/jdbc/postgresql/postgresql-42.2.1.jar org.sonar.server.app.WebServer /opt/sonar/temp/sq-process8995907569451285863properties
2019.11.12 18:07:57 INFO  app[][o.s.a.SchedulerImpl] Process [web] is stopped
2019.11.12 18:07:57 INFO  app[][o.s.a.SchedulerImpl] Process [es] is stopped
2019.11.12 18:07:57 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
2019.11.12 18:07:57 WARN  app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 143

I’m in the right direction or should I start with sonar upgrade?

Any feedback is welcomed!

Thank you.

Welcome to the community !

I don’t see any error in this snippet. Could you have a look at the web.log ?

Thank you @pierreguillot.

I found the problem, after the database upgrade I haven’t changed the /var/lib/pgsql/9.6/data/pg_hba.conf :cold_sweat:

I found that because you said to look at the web.log

Sorry and thank you :grinning:

Happy to see that you resolved the issue :slight_smile:

To know better what to expect from each log file, you can have a look at the logs description in the troubleshooting page.

Thank you once again @pierreguillot

Now I will try to upgrade my version of sonar from 7.1 -> 7.9.1 -> 8 :grinning: