Make sure to tell us:
- What version are you upgrading from?
- sonarqube-8.9.10.61524 to 9.9.6LTA
- System information (Operating system, Java version, Database provider/version)
-RHEL 8.8 / openjdk 17.0.11 2024-04-16 LTS - What’s the issue you’re facing?
/setup is complete for 9.9.6LTA, logs show that DB migration is complete,
2024.07.19 02:03:19 DEBUG web[c.z.h.p.ProxyConnection] HikariPool-1 - Executed rollback on connection org.postgresql.jdbc.PgConnection@366b3078 due to dirty commit state on close().
2024.07.19 02:03:19 DEBUG web[c.z.h.pool.PoolBase] HikariPool-1 - Reset (autoCommit, isolation) on connection org.postgresql.jdbc.PgConnection@366b3078
2024.07.19 02:03:19 INFO web[DbMigrations] #6804 ‘Populate ncloc in ‘Projects’ table’: success | time=149583ms
2024.07.19 02:03:19 INFO web[DbMigrations] Executed DB migrations: success | time=25339887ms
but in the url, sonarqube was not accessible , so after restarting sonar, it went to “Maintenance” "Sonarqube is Starting " for more than 2 hours
in the sonar.log
024.07.19 05:22:02 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2024.07.19 05:22:02 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[ElasticSearch] tryToMoveTo ElasticSearch from STARTED to STARTING => false
2024.07.19 05:22:02 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[ElasticSearch] tryToMoveTo Web Server from INIT to STARTING => true
2024.07.19 05:22:02 INFO app[o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [/opt/local/software/sonar/sonarqube-9.9.6.92038]: /usr/lib/jvm/java-17-openjdk-17.0.11.0.9-2.el8.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/local/software/sonar/sonar-temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -Dcom.redhat.fips=false -Xmx2g -Xms2g -XX:+HeapDumpOnOutOfMemoryError -Djava.net.preferIPv4Stack=true -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-9.9.6.92038.jar:/opt/local/software/sonar/sonarqube-9.9.6.92038/lib/jdbc/postgresql/postgresql-42.5.1.jar org.sonar.server.app.WebServer /opt/local/software/sonar/sonar-temp/sq-process9840829880175107271properties
2024.07.19 05:22:02 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[ElasticSearch] tryToMoveTo Web Server from STARTING to STARTED => true
no errors seen in the web.log,
ping to database is like 5 to 9 milliseconds
Please help to check this further.
Thanks,
Sathish