Process exited with exit value [es]: 143 while starting sonarqube

I am installing sonarqube and getting the below error:

sonar.log

Launching a JVM…
Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.

2020.09.09 02:55:32 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /home/nppdev/sonarqube/temp
2020.09.09 02:55:32 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2020.09.09 02:55:32 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/home/nppdev/sonarqube-8.4.2.36762/elasticsearch]: /home/nppdev/sonarqube-8.4.2.36762/elasticsearch/bin/elasticsearch
2020.09.09 02:55:32 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2020.09.09 02:55:32 INFO app[o.e.p.PluginsService] no modules loaded
2020.09.09 02:55:32 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
Java HotSpot™ 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2020.09.09 02:55:40 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.09.09 02:55:40 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [/home/nppdev/sonarqube-8.4.2.36762]: /usr/lib/jvm/java-11-oracle/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/nppdev/sonarqube/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 -Xmx1G -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/home/nppdev/sonarqube-8.4.2.36762/lib/jdbc/postgresql/postgresql-42.2.14.jar org.sonar.server.app.WebServer /home/nppdev/sonarqube/temp/sq-process17696105597421081546properties
2020.09.09 02:55:41 INFO app[o.s.a.SchedulerImpl] Process[web] is stopped
2020.09.09 02:55:41 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2020.09.09 02:55:41 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
2020.09.09 02:55:41 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped

web.log

2020.09.09 02:55:40 INFO web[o.s.p.ProcessEntryPoint] Starting web
2020.09.09 02:55:41 ERROR web[o.s.s.a.EmbeddedTomcat] Fail to start web server
org.apache.catalina.LifecycleException: Failed to initialize connector [Connector[HTTP/1.1-80]]
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:559)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:848)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:173)
at org.apache.catalina.startup.Tomcat.start(Tomcat.java:440)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:65)
at org.sonar.server.app.WebServer.start(WebServer.java:52)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:97)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:81)
at org.sonar.server.app.WebServer.main(WebServer.java:99)
2020.09.09 02:55:41 WARN web[o.s.p.ProcessEntryPoint] Fail to start web
java.lang.RuntimeException: org.apache.catalina.LifecycleException: Failed to initialize connector [Connector[HTTP/1.1-80]]
at com.google.common.base.Throwables.propagate(Throwables.java:241)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:69)
at org.sonar.server.app.WebServer.start(WebServer.java:52)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:97)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:81)
at org.sonar.server.app.WebServer.main(WebServer.java:99)
Caused by: org.apache.catalina.LifecycleException: Failed to initialize connector [Connector[HTTP/1.1-80]]
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:559)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:848)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:173)
at org.apache.catalina.startup.Tomcat.start(Tomcat.java:440)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:65)
… 4 common frames omitted
2020.09.09 02:55:41 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

Hi @sharadLko ,

welcome to the community :wave:

it looks like port 80 is already allocated on your system. you have to choose another one for the web port. if you want to use port 80 or 443 i suggest you think about implementing a reverse proxy in front of sonarqube as documented here.
the es exit code is just a information that the elasticsearch process was forcefully terminated.

hope that helps

Hi Tobias,

Thanks for your quick reponse. Can you help me how to change the port for sonarqube.

Thanks,
Sharad

Changed the port to default 9000 and getting below error:

2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#14]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.09.09 04:35:44 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

Hi @sharadLko ,

can you post the es.log file as well? i think now we have a elasticsearch error. for troubleshooting please see if your system fulfills the requirements

2020.09.09 04:35:35 INFO es[o.e.e.NodeEnvironment] using [1] data paths, mounts [[/ (/dev/sda1)]], net usable_space [248.7gb], net total_space [288.2gb], types [ext4]
2020.09.09 04:35:35 INFO es[o.e.e.NodeEnvironment] heap size [1.9gb], compressed ordinary object pointers [true]
2020.09.09 04:35:35 INFO es[o.e.n.Node] node name [sonarqube], node ID [RoG3HL7kSWm8HFaukHbeAQ]
2020.09.09 04:35:35 INFO es[o.e.n.Node] version[6.8.4], pid[28004], build[default/tar/bca0c8d/2019-10-16T06:19:49.319352Z], OS[Linux/4.15.0-117-generic/amd64], JVM[Oracle Corporation/Java HotSpot™ 64-Bit Server VM/11.0.8/11.0.8+10-LTS]
2020.09.09 04:35:35 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=/home/nppdev/sonarqube/temp, -XX:ErrorFile=…/logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xmx2G, -Xms2G, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/home/nppdev/sonarqube-8.4.2.36762/elasticsearch, -Des.path.conf=/home/nppdev/sonarqube/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [analysis-common]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [lang-painless]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [mapper-extras]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [parent-join]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [percolator]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [reindex]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [repository-url]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [transport-netty4]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] no plugins loaded
2020.09.09 04:35:37 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.
2020.09.09 04:35:37 INFO es[o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2020.09.09 04:35:38 INFO es[o.e.n.Node] initialized
2020.09.09 04:35:38 INFO es[o.e.n.Node] starting …
2020.09.09 04:35:38 INFO es[o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2020.09.09 04:35:38 INFO es[o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2020.09.09 04:35:41 INFO es[o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2020.09.09 04:35:41 INFO es[o.e.c.s.ClusterApplierService] new_master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube} committed version [1] source [zen-disco-elected-as-master ([0] nodes joined)]])
2020.09.09 04:35:41 INFO es[o.e.n.Node] started
2020.09.09 04:35:41 INFO es[o.e.g.GatewayService] recovered [0] indices into cluster_state
2020.09.09 04:35:44 INFO es[o.e.n.Node] stopping …
2020.09.09 04:35:44 INFO es[o.e.n.Node] stopped
2020.09.09 04:35:44 INFO es[o.e.n.Node] closing …
2020.09.09 04:35:44 INFO es[o.e.n.Node] closed

so far so good, i don’t see anything wrong here. can you upload all log files you have (would appreciate it formatted as markdown ``` or as file )

es.log:

2020.09.09 04:35:35 INFO es[o.e.e.NodeEnvironment] using [1] data paths, mounts [[/ (/dev/sda1)]], net usable_space [248.7gb], net total_space [288.2gb], types [ext4]
2020.09.09 04:35:35 INFO es[o.e.e.NodeEnvironment] heap size [1.9gb], compressed ordinary object pointers [true]
2020.09.09 04:35:35 INFO es[o.e.n.Node] node name [sonarqube], node ID [RoG3HL7kSWm8HFaukHbeAQ]
2020.09.09 04:35:35 INFO es[o.e.n.Node] version[6.8.4], pid[28004], build[default/tar/bca0c8d/2019-10-16T06:19:49.319352Z], OS[Linux/4.15.0-117-generic/amd64], JVM[Oracle Corporation/Java HotSpot™ 64-Bit Server VM/11.0.8/11.0.8+10-LTS]
2020.09.09 04:35:35 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=/home/nppdev/sonarqube/temp, -XX:ErrorFile=…/logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xmx2G, -Xms2G, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/home/nppdev/sonarqube-8.4.2.36762/elasticsearch, -Des.path.conf=/home/nppdev/sonarqube/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [analysis-common]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [lang-painless]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [mapper-extras]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [parent-join]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [percolator]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [reindex]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [repository-url]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] loaded module [transport-netty4]
2020.09.09 04:35:35 INFO es[o.e.p.PluginsService] no plugins loaded
2020.09.09 04:35:37 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.
2020.09.09 04:35:37 INFO es[o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2020.09.09 04:35:38 INFO es[o.e.n.Node] initialized
2020.09.09 04:35:38 INFO es[o.e.n.Node] starting …
2020.09.09 04:35:38 INFO es[o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2020.09.09 04:35:38 INFO es[o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2020.09.09 04:35:41 INFO es[o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2020.09.09 04:35:41 INFO es[o.e.c.s.ClusterApplierService] new_master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{RoG3HL7kSWm8HFaukHbeAQ}{Jmgh2ZWyR_y_kH_Q2uQEDw}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube} committed version [1] source [zen-disco-elected-as-master ([0] nodes joined)]])
2020.09.09 04:35:41 INFO es[o.e.n.Node] started
2020.09.09 04:35:41 INFO es[o.e.g.GatewayService] recovered [0] indices into cluster_state
2020.09.09 04:35:44 INFO es[o.e.n.Node] stopping …
2020.09.09 04:35:44 INFO es[o.e.n.Node] stopped
2020.09.09 04:35:44 INFO es[o.e.n.Node] closing …
2020.09.09 04:35:44 INFO es[o.e.n.Node] closed

sonar.log:

Launching a JVM…
Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.

2020.09.09 04:35:33 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /home/nppdev/sonarqube/temp
2020.09.09 04:35:33 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2020.09.09 04:35:33 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/home/nppdev/sonarqube-8.4.2.36762/elasticsearch]: /home/nppdev/sonarqube-8.4.2.36762/elasticsearch/bin/elasticsearch
2020.09.09 04:35:33 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2020.09.09 04:35:33 INFO app[o.e.p.PluginsService] no modules loaded
2020.09.09 04:35:33 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
Java HotSpot™ 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2020.09.09 04:35:41 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.09.09 04:35:41 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [/home/nppdev/sonarqube-8.4.2.36762]: /usr/lib/jvm/java-11-oracle/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/nppdev/sonarqube/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 -Xmx1G -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/home/nppdev/sonarqube-8.4.2.36762/lib/jdbc/postgresql/postgresql-42.2.14.jar org.sonar.server.app.WebServer /home/nppdev/sonarqube/temp/sq-process5276489328982256175properties
2020.09.09 04:35:44 INFO app[o.s.a.SchedulerImpl] Process[web] is stopped
2020.09.09 04:35:45 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2020.09.09 04:35:45 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
2020.09.09 04:35:45 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped

web.log:

2020.09.09 04:35:41 INFO web[o.s.p.ProcessEntryPoint] Starting web
2020.09.09 04:35:42 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.09.09 04:35:42 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2020.09.09 04:35:43 INFO web[o.e.p.PluginsService] no modules loaded
2020.09.09 04:35:43 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.09.09 04:35:43 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.09.09 04:35:43 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.09.09 04:35:44 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.09.09 04:35:44 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 8.4.2.36762 / d428d412047420f00c81110f95eaf1c709608af1
2020.09.09 04:35:44 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost/sonarq
2020.09.09 04:35:44 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:86)
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:136)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:166)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:213)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:172)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:86)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4689)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5155)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by ‘sonar.jdbc.’).
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:118)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:83)
… 24 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: database “sonarq” does not exist)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:669)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:544)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
at org.sonar.db.profiling.NullConnectionInterceptor.getConnection(NullConnectionInterceptor.java:31)
at org.sonar.db.profiling.ProfiledDataSource.getConnection(ProfiledDataSource.java:317)
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:115)
… 25 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: database “sonarq” does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2644)
at org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:137)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:255)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:217)
at org.postgresql.Driver.makeConnection(Driver.java:458)
at org.postgresql.Driver.connect(Driver.java:260)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:115)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665)
… 30 common frames omitted
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][[timer]]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/java.lang.Thread.sleep(Native Method)\n app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][scheduler][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/jdk.internal.misc.Unsafe.park(Native Method)\n java.base@11.0.8/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)\n java.base@11.0.8/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)\n java.base@11.0.8/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)\n java.base@11.0.8/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][generic][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/jdk.internal.misc.Unsafe.park(Native Method)\n java.base@11.0.8/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194)\n java.base@11.0.8/java.util.concurrent.LinkedTransferQueue.awaitMatch(LinkedTransferQueue.java:743)\n java.base@11.0.8/java.util.concurrent.LinkedTransferQueue.xfer(LinkedTransferQueue.java:684)\n java.base@11.0.8/java.util.concurrent.LinkedTransferQueue.take(LinkedTransferQueue.java:1366)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)\n java.base@11.0.8/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#2]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#3]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#4]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#5]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#6]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#7]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#8]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#9]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#10]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#11]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#12]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#13]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[client][transport_worker][T#14]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.8/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.8/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.8/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.8/java.lang.Thread.run(Thread.java:834)
2020.09.09 04:35:44 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.09.09 04:35:44 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

looks like the database you specified does not exists

2020.09.09 06:06:44 INFO web[o.s.p.ProcessEntryPoint] Starting web
2020.09.09 06:06:44 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.09.09 06:06:45 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] no modules loaded
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.09.09 06:06:46 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.09.09 06:06:46 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 8.4.2.36762 / d428d412047420f00c81110f95eaf1c709608af1
2020.09.09 06:06:46 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost/sonaq
2020.09.09 06:06:47 INFO web[o.s.s.p.ServerFileSystemImpl] SonarQube home: /home/nppdev/sonarqube-8.4.2.36762
2020.09.09 06:06:47 INFO web[o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.09.09 06:06:47 INFO web[o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2020.09.09 06:06:47 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Failed to create table schema_migrations
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:48)
at java.base/java.util.Optional.ifPresent(Optional.java:183)
at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:101)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:213)
at org.sonar.server.platform.PlatformImpl.startLevel2Container(PlatformImpl.java:179)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:87)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4689)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5155)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.execute(MigrationHistoryTableImpl.java:71)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.createTable(MigrationHistoryTableImpl.java:59)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:45)
… 15 common frames omitted
2020.09.09 06:06:47 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.09.09 06:06:47 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

I have changed the schema name but still getting the error:

2020.09.09 06:06:44 INFO web[o.s.p.ProcessEntryPoint] Starting web
2020.09.09 06:06:44 INFO web[o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.09.09 06:06:45 INFO web[o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] no modules loaded
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.09.09 06:06:45 INFO web[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.09.09 06:06:46 INFO web[o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.09.09 06:06:46 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 8.4.2.36762 / d428d412047420f00c81110f95eaf1c709608af1
2020.09.09 06:06:46 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost/sonaq
2020.09.09 06:06:47 INFO web[o.s.s.p.ServerFileSystemImpl] SonarQube home: /home/nppdev/sonarqube-8.4.2.36762
2020.09.09 06:06:47 INFO web[o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.09.09 06:06:47 INFO web[o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2020.09.09 06:06:47 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Failed to create table schema_migrations
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:48)
at java.base/java.util.Optional.ifPresent(Optional.java:183)
at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:101)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:213)
at org.sonar.server.platform.PlatformImpl.startLevel2Container(PlatformImpl.java:179)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:87)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4689)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5155)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.execute(MigrationHistoryTableImpl.java:71)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.createTable(MigrationHistoryTableImpl.java:59)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:45)
… 15 common frames omitted
2020.09.09 06:06:47 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.09.09 06:06:47 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

did you create a specific schema for this database in your postgres server?

Yes i have created schema named sonaq

could you try with the default one and remove the schema specification from the jdbc url? it looks like the search_path is wrong in your postgres database server

yes if i remove and go with default settings, i am able to start the web service. Thanks for your help…