SonarQube won't start - MSSQL Issue

Which versions are you using?
SonarQube 8.1 Community

What are you trying to achieve?
Replicate the existing version of SonarQube to practice the upgrade path.

What have you tried so far to achieve this?
I have SonarQube set up on a Linux VM (Red Hat 7.7). I’ve set up the demo instance which works fine.

What I would like to do is set up a production instance. MSSQL 2016 is set up on a Windows host. When I add the required SQL information into sonar.properties on the VM, the console will not start. Output is as follows:

Running SonarQube…
wrapper | → Wrapper Started as Console
wrapper | Launching a JVM…
jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
jvm 1 |
jvm 1 | 2022.09.26 14:25:26 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /home/sonarqube/sonarqube8.1/temp
jvm 1 | 2022.09.26 14:25:26 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
jvm 1 | 2022.09.26 14:25:26 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/home/sonarqube/sonarqube8.1/elasticsearch]: /home/sonarqube/sonarqube8.1/elasticsearch/bin/elasticsearch
jvm 1 | 2022.09.26 14:25:27 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
jvm 1 | OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
jvm 1 | 2022.09.26 14:25:27 INFO app[o.e.p.PluginsService] no modules loaded
jvm 1 | 2022.09.26 14:25:27 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
jvm 1 | ERROR: [1] bootstrap checks failed
jvm 1 | [1]: max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]
jvm 1 | 2022.09.26 14:25:32 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 78
jvm 1 | 2022.09.26 14:25:32 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
jvm 1 | 2022.09.26 14:25:32 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
wrapper | ← Wrapper Stopped

What would be the cause of this issue? Is it something to do with the network/firewall? Does mssql-tools have to be installed on the VM?

Any help would be appreciated.

Hey there.

The error comes from here.

Read more here.

So I reset those values but now get the following:

Running SonarQube…
wrapper | → Wrapper Started as Console
wrapper | Launching a JVM…
jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
jvm 1 |
jvm 1 | 2022.09.27 07:29:28 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /home/sonarqube/sonarqube8.1/temp
jvm 1 | 2022.09.27 07:29:28 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
jvm 1 | 2022.09.27 07:29:28 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/home/sonarqube/sonarqube8.1/elasticsearch]: /home/sonarqube/sonarqube8.1/elasticsearch/bin/elasticsearch
jvm 1 | 2022.09.27 07:29:28 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
jvm 1 | OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
jvm 1 | 2022.09.27 07:29:29 INFO app[o.e.p.PluginsService] no modules loaded
jvm 1 | 2022.09.27 07:29:29 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
jvm 1 | 2022.09.27 07:29:37 INFO app[o.s.a.SchedulerImpl] Process[es] is up
jvm 1 | 2022.09.27 07:29:37 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [/home/sonarqube/sonarqube8.1]: /usr/lib/jvm/java-11-openjdk-11.0.16.1.1-1.el7_9.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/sonarqube/sonarqube8.1/temp --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 -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/home/sonarqube/sonarqube8.1/lib/jdbc/mssql/mssql-jdbc-7.2.2.jre11.jar org.sonar.server.app.WebServer /home/sonarqube/sonarqube8.1/temp/sq-process15868354789131921812properties
jvm 1 | 2022.09.27 07:29:54 INFO app[o.s.a.SchedulerImpl] Process[web] is stopped
jvm 1 | 2022.09.27 07:29:54 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
jvm 1 | 2022.09.27 07:29:54 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
jvm 1 | 2022.09.27 07:29:54 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
wrapper | ← Wrapper Stopped

What do all the logs say?

https://docs.sonarqube.org/latest/setup/troubleshooting/

I managed to fix my issue, was to do with system networking. Thanks

1 Like