Sonar Version : 7.9.1
Can anyone help me in sorting the situation out?
Below are the various outputs from my VM
===========
JAVA
java -version
openjdk version “11.0.4” 2019-07-16 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.4+11-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.4+11-LTS, mixed mode, sharing)
==================
Microsoft SQL DATABASE
systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2019-10-28 20:18:18 UTC; 18h ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 101588 (sqlservr)
CGroup: /system.slice/mssql-server.service
├─101588 /opt/mssql/bin/sqlservr
└─101622 /opt/mssql/bin/sqlservr
=================
Output of Sonar.log
--> Wrapper Started as Daemon
Launching a JVM...
Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
2019.10.29 14:52:42 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube7.9.1/temp
2019.10.29 14:52:42 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2019.10.29 14:52:43 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube7.9.1/elasticsearch]: /opt/sonarqube7.9.1/elasticsearch/bin/elasticsearch
2019.10.29 14:52:43 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2019.10.29 14:52:44 INFO app[][o.e.p.PluginsService] no modules loaded
2019.10.29 14:52:44 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.10.29 14:53:04 INFO app[][o.s.a.SchedulerImpl] Process[es] is up
2019.10.29 14:53:04 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube7.9.1]: /usr/lib/jvm/java-11-openjdk-11.0.4.11-0.el7_6.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube7.9.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 -Xmx1G -Xms512m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/opt/sonarqube7.9.1/lib/jdbc/mssql/mssql-jdbc-7.2.2.jre11.jar org.sonar.server.app.WebServer /opt/sonarqube7.9.1/temp/sq-process3943412879208783542properties
2019.10.29 14:53:30 INFO app[][o.s.a.SchedulerImpl] Process[web] is stopped
2019.10.29 14:53:30 WARN app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2019.10.29 14:53:30 INFO app[][o.s.a.SchedulerImpl] Process[es] is stopped
2019.10.29 14:53:30 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped
====================
Output of web.log
2019.10.29 14:53:05 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2019.10.29 14:53:06 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.10.29 14:53:07 INFO web[][o.e.p.PluginsService] no modules loaded
2019.10.29 14:53:07 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.10.29 14:53:07 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.10.29 14:53:07 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.10.29 14:53:09 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.10.29 14:53:09 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.1.27448 / e0c45c97bb2e45d52629f3422ac91718020f6db9
2019.10.29 14:53:09 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost:3306;databaseName=sonar
2019.10.29 14:53:24 ERROR web[][o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:90)
at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
at org.picocontainer.behaviors.Stored.start(Stored.java:110)
at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)
at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)
at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)
at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:135)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:160)
at org.sonar.server.platform.Platform.start(Platform.java:211)
at org.sonar.server.platform.Platform.startLevel1Container(Platform.java:170)
at org.sonar.server.platform.Platform.init(Platform.java:86)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
2019.10.29 14:53:24 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonar] appears to have started a thread named [elasticsearch[_client_][generic][T#4]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.4/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.4/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194)
java.base@11.0.4/java.util.concurrent.LinkedTransferQueue.awaitMatch(LinkedTransferQueue.java:743)
java.base@11.0.4/java.util.concurrent.LinkedTransferQueue.xfer(LinkedTransferQueue.java:684)
java.base@11.0.4/java.util.concurrent.LinkedTransferQueue.take(LinkedTransferQueue.java:1366)
java.base@11.0.4/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
java.base@11.0.4/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
java.base@11.0.4/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
java.base@11.0.4/java.lang.Thread.run(Thread.java:834)
2019.10.29 14:53:24 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2019.10.29 14:53:24 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process
==================
Output of es.log
2019.10.29 14:52:51 INFO es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/ (rootfs)]], net usable_space [25.6gb], net total_space [31.4gb], types [rootfs]
2019.10.29 14:52:51 INFO es[][o.e.e.NodeEnvironment] heap size [1.9gb], compressed ordinary object pointers [true]
2019.10.29 14:52:51 INFO es[][o.e.n.Node] node name [sonarqube], node ID [QVWJg2HySxaATMPYx3EOog]
2019.10.29 14:52:51 INFO es[][o.e.n.Node] version[6.8.0], pid[88324], build[default/tar/65b6179/2019-05-15T20:06:13.172855Z], OS[Linux/3.10.0-957.21.3.el7.x86_64/amd64], JVM[Oracle Corporation/OpenJDK 64-Bit Server VM/11.0.4/11.0.4+11-LTS]
2019.10.29 14:52:51 INFO es[][o.e.n.Node] JVM arguments [-XX:+UseConcMarkSweepGC, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSInitiatingOccupancyOnly, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.io.tmpdir=/opt/sonarqube7.9.1/temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xms2g, -Xmx2g, -XX:+HeapDumpOnOutOfMemoryError, -Dbootstrap.system_call_filter=false, -Des.path.home=/opt/sonarqube7.9.1/elasticsearch, -Des.path.conf=/opt/sonarqube7.9.1/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [analysis-common]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [lang-painless]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [mapper-extras]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [parent-join]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [percolator]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [reindex]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [repository-url]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] loaded module [transport-netty4]
2019.10.29 14:52:52 INFO es[][o.e.p.PluginsService] no plugins loaded
2019.10.29 14:52:56 WARN es[][o.e.d.c.s.Settings] [http.enabled] setting was deprecated in Elasticsearch and will be removed in a future release! See the breaking changes documentation for the next major version.
2019.10.29 14:52:58 INFO es[][o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2019.10.29 14:52:59 INFO es[][o.e.n.Node] initialized
2019.10.29 14:52:59 INFO es[][o.e.n.Node] starting ...
2019.10.29 14:52:59 INFO es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2019.10.29 14:52:59 INFO es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2019.10.29 14:53:02 INFO es[][o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{QVWJg2HySxaATMPYx3EOog}{N_GmjktmTh6flmO5KUoOdg}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2019.10.29 14:53:02 INFO es[][o.e.c.s.ClusterApplierService] new_master {sonarqube}{QVWJg2HySxaATMPYx3EOog}{N_GmjktmTh6flmO5KUoOdg}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{QVWJg2HySxaATMPYx3EOog}{N_GmjktmTh6flmO5KUoOdg}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube} committed version [1] source [zen-disco-elected-as-master ([0] nodes joined)]])
2019.10.29 14:53:02 INFO es[][o.e.n.Node] started
2019.10.29 14:53:02 INFO es[][o.e.g.GatewayService] recovered [0] indices into cluster_state
2019.10.29 14:53:30 INFO es[][o.e.n.Node] stopping ...
2019.10.29 14:53:30 INFO es[][o.e.n.Node] stopped
2019.10.29 14:53:30 INFO es[][o.e.n.Node] closing ...
2019.10.29 14:53:30 INFO es[][o.e.n.Node] closed