Working Sonarqube 9.2 (dev environment) after restart won't connect to the postgres database

SonarQube Server / Community Build
1

I have a dev environment of Sonarqube 9.2.4. I restarted the services as it was getting slow yesterday but once it was up it can’t connect to the postgres database. I’ve restarted already the VM of the application as well as the postgres database (PaaS) but still to no avail. Got this from web.log:

got this from /opt/sonarqube/logs/web.log

## Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
### Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
### Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
### Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
### Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
### Error querying database.  Cause: org.postgresql.util.PSQLException: The connection attempt failed.
2022.06.01 02:58:31 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
2022.06.01 03:02:15 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
2022.06.01 03:13:54 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
2022.06.01 03:24:14 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
2022.06.01 03:30:36 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
2022.06.01 06:56:09 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://jsso-sonar-dev-db-postgres-01.postgres.database.azure.com:5432/sonardev8_9?user=postgres@jsso-sonar-dev-db-postgres-01&password=xxx&sslmode=require&gssEncMode=disable
java.lang.IllegalStateException: Fail to connect to database
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').

Any lead on how to solve this issue is very much appreciated.

2

Hey there.

You probably want to first take SonarQube out of the equation entirely. How does psql do at connecting to this database from the machine where you’re running SonarQube (using the same URL, username, password).

3

Hi Colin,

Executing the psql command from the host to the postgresql server results to this output:

psql: connection to server at , port 5432 failed: Connection timed out
Is the server running on that host and accepting TCP/IP connections?

Looks like a port / firewall issue?

4

Something definitely seems to be happening at the network layer. I would focus on having a successful psql connection before returning to trying to connect SonarQube with your database.

5

Hi Colin/Team,

So today, the network layer has been solved. My application server can successfully connect to the postgresql server with the psql command. However, when I try to start the sonarqube service I still can’t make it work. Is there any string that I need to check in the web, es, access, or sonar? When I stopped the sonarqube service and performed a systemctl status, it gave me this status:

Jun 07 07:28:04 dgm010af7 systemd[1]: Stopping SonarQube service…
Jun 07 07:28:04 dgm010af7 nohup[791789]: 2022.06.07 07:28:04 INFO app[o.s.a.SchedulerImpl] Stopping SonarQube
Jun 07 07:28:04 dgm010af7 nohup[791789]: 2022.06.07 07:28:04 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
Jun 07 07:28:04 dgm010af7 nohup[791789]: 2022.06.07 07:28:04 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
Jun 07 07:29:34 dgm010af7 systemd[1]: sonarqube.service: State ‘stop-sigterm’ timed out. Killing.
Jun 07 07:29:34 dgm010af7 systemd[1]: sonarqube.service: Killing process 791789 (java) with signal SIGKILL.
Jun 07 07:29:34 dgm010af7 systemd[1]: sonarqube.service: Killing process 791953 (java) with signal SIGKILL.
Jun 07 07:29:34 dgm010af7 systemd[1]: sonarqube.service: Main process exited, code=killed, status=9/KILL
Jun 07 07:29:34 dgm010af7 systemd[1]: sonarqube.service: Failed with result ‘timeout’.
Jun 07 07:29:34 dgm010af7 systemd[1]: Stopped SonarQube service.

And then I start the sonarqube service and make a status this is what I get:

sonarqube.service - SonarQube service
Loaded: loaded (/etc/systemd/system/sonarqube.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2022-06-07 07:33:16 UTC; 15s ago
Main PID: 793547 (java)
Tasks: 142 (limit: 179749)
Memory: 2.5G
CGroup: /system.slice/sonarqube.service
├─793547 /usr/bin/java -Xms32m -Xmx32m -Djava.net.preferIPv4Stack=true -jar /opt/sonarqube/lib/sonar-application-9.2.4.50792.jar
├─793568 /usr/lib/jvm/java-11-openjdk-11.0.15.0.9-2.el8_5.x86_64/bin/java -XX:+UseG1GC -Djava.io.tmpdir=/opt/sonarqube/temp -XX:ErrorFile=…/l>
└─793712 /usr/lib/jvm/java-11-openjdk-11.0.15.0.9-2.el8_5.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt>

Jun 07 07:33:16 dgm010af7 systemd[1]: Started SonarQube service.
Jun 07 07:33:17 dgm010af7 nohup[793547]: 2022.06.07 07:33:17 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
Jun 07 07:33:17 dgm010af7 nohup[793547]: 2022.06.07 07:33:17 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.>
Jun 07 07:33:17 dgm010af7 nohup[793547]: 2022.06.07 07:33:17 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePref>
Jun 07 07:33:17 dgm010af7 nohup[793547]: 2022.06.07 07:33:17 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
Jun 07 07:33:24 dgm010af7 nohup[793547]: 2022.06.07 07:33:24 INFO app[o.s.a.SchedulerImpl] Process[es] is up
Jun 07 07:33:24 dgm010af7 nohup[793547]: 2022.06.07 07:33:24 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePre>

Is this normal? Especially on the part that says “Waiting for Elastisearch to be up and running”?

6

I was able to make it work. I restarted the services again of Sonarqube and noticed that the status of the systemctl output looks like this now:

root@dgm010af7 logs]# systemctl status sonarqube.service
● sonarqube.service - SonarQube service
Loaded: loaded (/etc/systemd/system/sonarqube.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2022-06-07 07:48:28 UTC; 5min ago
Main PID: 795313 (java)
Tasks: 233 (limit: 179749)
Memory: 4.2G
CGroup: /system.slice/sonarqube.service
├─795313 /usr/bin/java -Xms32m -Xmx32m -Djava.net.preferIPv4Stack=true -jar /opt/sonarqube/lib/sonar-application-9.2.4.50792.jar
├─795334 /usr/lib/jvm/java-11-openjdk-11.0.15.0.9-2.el8_5.x86_64/bin/java -XX:+UseG1GC -Djava.io.tmpdir=/opt/sonarqube/temp -XX:ErrorFile=…/l>
├─795485 /usr/lib/jvm/java-11-openjdk-11.0.15.0.9-2.el8_5.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt>
└─795611 /usr/lib/jvm/java-11-openjdk-11.0.15.0.9-2.el8_5.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt>

Jun 07 07:48:28 dgm010af7 nohup[795313]: 2022.06.07 07:48:28 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
Jun 07 07:48:28 dgm010af7 nohup[795313]: 2022.06.07 07:48:28 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.>
Jun 07 07:48:28 dgm010af7 nohup[795313]: 2022.06.07 07:48:28 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePref>
Jun 07 07:48:28 dgm010af7 nohup[795313]: 2022.06.07 07:48:28 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
Jun 07 07:48:36 dgm010af7 nohup[795313]: 2022.06.07 07:48:36 INFO app[o.s.a.SchedulerImpl] Process[es] is up
Jun 07 07:48:36 dgm010af7 nohup[795313]: 2022.06.07 07:48:36 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePre>
Jun 07 07:49:05 dgm010af7 nohup[795313]: 2022.06.07 07:49:05 INFO app[o.s.a.SchedulerImpl] Process[web] is up
Jun 07 07:49:05 dgm010af7 nohup[795313]: 2022.06.07 07:49:05 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘ce’, ipcIndex=3, logFilenamePref>
Jun 07 07:49:13 dgm010af7 nohup[795313]: 2022.06.07 07:49:13 INFO app[o.s.a.SchedulerImpl] Process[ce] is up
Jun 07 07:49:13 dgm010af7 nohup[795313]: 2022.06.07 07:49:13 INFO app[o.s.a.SchedulerImpl] SonarQube is up

Based on the status output, need help on the difference between the first one (Jun 07 07:33) and the second one (Jun 07 07:49).

7

From my own limited understanding, on the second restart, these logs got added that made sonarqube alive:

Jun 07 07:49:05 dgm010af7 nohup[795313]: 2022.06.07 07:49:05 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘ce’, ipcIndex=3, logFilenamePref>
Jun 07 07:49:13 dgm010af7 nohup[795313]: 2022.06.07 07:49:13 INFO app[o.s.a.SchedulerImpl] Process[ce] is up
Jun 07 07:49:13 dgm010af7 nohup[795313]: 2022.06.07 07:49:13 INFO app[o.s.a.SchedulerImpl] SonarQube is up

Wondering what was the reason why these three lines of output not present in the first restart? Granted that my observation was correct. Thanks guys.

8

I would venture to say that your SonarQube server got part way through starting up the Web process (web.log), but for some reason didn’t finish and therefore the Compute Engine hadn’t launched. You may be able to check the web.log file to see what it was doing between 07:33:24 and when you restarted the service.

9

Hi Colin,

Here is my web.log for today. Would appreciate your help in deciphering what happened when I was restarting the sonarqube service after the network connection between my appserver and db got restored:

2022.06.07 07:15:16 INFO web[o.s.p.ProcessEntryPoint] Starting web
2022.06.07 07:15:16 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2022.06.07 07:15:17 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server,
governance, license, securityreport
2022.06.07 07:15:17 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
2022.06.07 07:15:17 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 9.2.4.50792 / 78f7113cee15b2bd37a958455271e68f1244cb7b
2022.06.07 07:15:17 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://mypostgresql
om:5432/sonardev8_9?user=postgres@mypostgresql&password=???&sslmode=require&gssEncMode=disable
2022.06.07 07:28:04 INFO web[o.s.p.ProcessEntryPoint] Gracefully stopping process
2022.06.07 07:33:25 INFO web[o.s.p.ProcessEntryPoint] Starting web
2022.06.07 07:33:25 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2022.06.07 07:33:26 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server,
governance, license, securityreport
2022.06.07 07:33:26 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
2022.06.07 07:33:26 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 9.2.4.50792 / 78f7113cee15b2bd37a958455271e68f1244cb7b
2022.06.07 07:33:26 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://mypostgresql
om:5432/sonardev8_9?user=postgres@mypostgresql&password=???&sslmode=require&gssEncMode=disable
2022.06.07 07:45:50 INFO web[o.s.p.ProcessEntryPoint] Gracefully stopping process
2022.06.07 07:48:36 INFO web[o.s.p.ProcessEntryPoint] Starting web
2022.06.07 07:48:36 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2022.06.07 07:48:37 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server,
governance, license, securityreport
2022.06.07 07:48:37 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
2022.06.07 07:48:37 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 9.2.4.50792 / 78f7113cee15b2bd37a958455271e68f1244cb7b
2022.06.07 07:48:37 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://mypostgresql
om:5432/sonardev8_9?user=postgres@mypostgresql&password=???&sslmode=require&gssEncMode=disable
2022.06.07 07:48:40 INFO web[o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2022.06.07 07:48:40 INFO web[o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin ABAP Code Quality and Security / 3.9.1.3127 / a62ddf6ddd7379d398a58d32c9931a2fe
ef61e24
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Apex Code Quality and Security / 1.8.3.2219 / d6ad7a5a47fc4785d2e80918fb7424be4
6e38a7f
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin C# Code Quality and Security / 8.32.0.39516 / 339a4abca54577c2331eb89f3ccecd432
79fbd11
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin CFamily Code Quality and Security / 6.28.0.39490 / aaa75e4f42e7cb2d9796769e1ff8
b9865ed33776
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin COBOL Code Quality / 4.6.2.4876 / 314414101278f77b354b02acd8808fdbff700d3f
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Configuration detection fot Code Quality and Security / 1.1.0.185 / f880796141c
97fa59ac04f8ac0db56c62d862005
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Flex Code Quality and Security / 2.6.2.2641 / 11f07506915923b3a0e39e4e34280644c
035b925
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Go Code Quality and Security / 1.8.3.2219 / d6ad7a5a47fc4785d2e80918fb7424be46e
38a7f
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin HTML Code Quality and Security / 3.4.0.2754 / 38f7ff864ae15152c9f1efc3014594f7e
7ca7b6e
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin IaC Code Quality and Security / 1.4.0.1294 / d5088c9df33e24593acd39bac930613617
6da598
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin JaCoCo / 1.1.1.1157 / 83478572b9f23efac29de15e30c7758bbb0c0e47
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Java Code Quality and Security / 7.5.0.28054 / 54b377cfbc4b5d4f2780855818c6850c
298ea395
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin JavaScript/TypeScript Code Quality and Security / 8.6.0.16913 / 701a9ce4770cfe8
9eb0ac54c75eeafb2c8c514ac
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Kotlin Code Quality and Security / 2.7.0.948 / 9ab38bae2f6f59bd5ba6d3bed5a159d8
58b87daf
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin PHP Code Quality and Security / 3.21.2.8292 / 86bd9dd559ac9a3a8dbabdf44d171395e
7334590
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin PL/I Code Quality and Security / 1.11.1.2727 / 6976734b43f9247c20529879eca3495c
fa89f47a
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin PL/SQL Code Quality and Security / 3.6.1.3873 / 342f7fcf17ecb7fbf827a2aacf630be
1f4157625
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Python Code Quality and Security / 3.8.0.8883 / 30629fbf3e871f83899ec32d3e4a059
88b3d4727
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin RPG Code Quality / 3.1.0.2955 / 8abef161313f499de12690d168961aae49b78f4d
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Ruby Code Quality and Security / 1.8.3.2219 / d6ad7a5a47fc4785d2e80918fb7424be4
6e38a7f
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Scala Code Quality and Security / 1.8.3.2219 / d6ad7a5a47fc4785d2e80918fb7424be
46e38a7f
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Swift Code Quality and Security / 4.3.2.5043 / d871fa3fcb7eeaf0e95b9946135e53ec
09320241
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin T-SQL Code Quality and Security / 1.5.1.4340 / 11f3de5739b539749d6c2848bda8fc90
135d91b6
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin VB.NET Code Quality and Security / 8.32.0.39516 / 339a4abca54577c2331eb89f3ccec
d43279fbd11
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin VB6 Code Quality and Security / 2.7.1.2721 / b1d1c140bb9ec432799c480e2245a63d94
7fbef9
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Analysis / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e8590478170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Rules for C# / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e859047
8170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Rules for JS / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e859047
8170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Rules for Java / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e8590
478170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Rules for PHP / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e85904
78170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin Vulnerability Rules for Python / 9.2.0.14426 / f2c6ddef53d8ba3cb53c0d3cd6168e85
90478170
2022.06.07 07:48:42 INFO web[o.s.s.p.ServerPluginManager] Deploy plugin XML Code Quality and Security / 2.4.0.3273 / 3e6d286309dbc9af364fc3c843ee8e71ed
1801f7
2022.06.07 07:48:44 INFO web[o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2022.06.07 07:48:45 WARN web[o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2022.06.07 07:48:45 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@3ede47f8 [patter
n=UrlPattern{inclusions=[/api/system/migrate_db., …], exclusions=[/api/components/update_key, …]}]
2022.06.07 07:48:45 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2022.06.07 07:48:46 INFO web[][o.s.s.p.DetectPluginChange] Detect plugin changes
2022.06.07 07:48:47 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2022.06.07 07:48:49 INFO web[][o.s.s.s.LogServerId] Server ID: 07FAFF7D-AWyXT7V8YFa96uIuZmWN
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/list_bitbucketserver_projects
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/search_bitbucketcloud_repos
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/list_azure_projects
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/search_bitbucketserver_repos
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/search_azure_repos
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_settings/validate_binding
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/project_dump/status
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/download
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/show
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/views/definition
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/governance_reports/download
2022.06.07 07:48:49 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2022.06.07 07:48:49 INFO web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2022.06.07 07:48:49 INFO web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2022.06.07 07:48:50 INFO web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired session tokens has removed 5 elements
2022.06.07 07:48:50 INFO web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired SAML message ids has removed 2 elements
2022.06.07 07:48:50 INFO web[][com.sonarsource.D.G] Loaded virtual plugin License for SonarLint
2022.06.07 07:48:50 INFO web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2022.06.07 07:48:50 INFO web[][o.s.s.s.RegisterMetrics] Register metrics
2022.06.07 07:48:51 INFO web[][o.s.s.r.RegisterRules] Register rules
2022.06.07 07:49:00 INFO web[][o.s.s.q.BuiltInQProfileRepositoryImpl] Load quality profiles
2022.06.07 07:49:00 INFO web[][o.s.s.q.RegisterQualityProfiles] Register quality profiles
2022.06.07 07:49:00 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile css/Sonar way
2022.06.07 07:49:01 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile scala/Sonar way
2022.06.07 07:49:01 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile jsp/Sonar way
2022.06.07 07:49:01 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile js/Sonar way
2022.06.07 07:49:01 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile py/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile apex/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile plsql/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile java/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile web/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile xml/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile flex/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile json/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile vbnet/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile cloudformation/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile yaml/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile swift/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile cpp/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile c/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile rpg/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile kotlin/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile go/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile tsql/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile vb/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile pli/Sonar way
2022.06.07 07:49:02 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile ruby/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile cs/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile cobol/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile php/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile php/PSR-2
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile php/Drupal
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile terraform/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile abap/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile ts/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.q.RegisterQualityProfiles] Update profile objc/Sonar way
2022.06.07 07:49:03 INFO web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2022.06.07 07:49:03 INFO web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2022.06.07 07:49:04 INFO web[][o.s.s.s.UpgradeSuggestionsCleaner] Dismissed messages cleanup
2022.06.07 07:49:04 INFO web[][o.s.s.s.RegisterPlugins] Register plugins
2022.06.07 07:49:04 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.SonarLintConnectionFilter@bbf5cfc
[pattern=UrlPattern{inclusions=[/api/], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@55c40c2a [patter
n=UrlPattern{inclusions=[/api/issues/delete_comment., …], exclusions=[/api/authentication/login., …]}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceReroutingFilter@1eb10a7
9 [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, …], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.plugins.PluginsRiskConsentFilter@8a69b3e [patt
ern=UrlPattern{inclusions=[/], exclusions=[.css, …]}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.DefaultAdminCredentialsVerifier
Filter@743b2aea [pattern=UrlPattern{inclusions=[/], exclusions=[.css, …]}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@4e27e5a7 [pattern=Ur
lPattern{inclusions=[/sessions/init/], exclusions=[]}]
2022.06.07 07:49:04 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@66531a37 [
pattern=UrlPattern{inclusions=[/oauth2/callback/], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ResetPasswordFilter@1d4d7fc1 [p
attern=UrlPattern{inclusions=[/], exclusions=[.css, …]}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@5c7e4a1c [patter
n=UrlPattern{inclusions=[/api/authentication/login], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@6bdd6879 [patte
rn=UrlPattern{inclusions=[/api/authentication/logout], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@5caed5d0 [pat
tern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=}]
2022.06.07 07:49:04 INFO web[o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning is not started as there are no projects in this si
tuation.
2022.06.07 07:49:04 INFO web[o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance
2022.06.07 07:49:04 INFO web[o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance (done) | time=3ms
2022.06.07 07:49:04 INFO web[o.s.s.p.p.PlatformLevelStartup] Running Enterprise Edition
2022.06.07 07:49:05 INFO web[o.s.s.p.Platform] WebServer is operational

10

It looks like something got stuck here.

It’s hard to say if there was an issue on the SonarQube side or on your database-side. In any case – the issue appears to have resolved itself now.

1 Like
11

Thanks for sharing your expertise Colin. I appreciate it!