Problems with new installation

Jerry1 · June 25, 2019, 6:45pm

I am trying to install and run a server on sonarqube-7.8 and based on these [instructions], with no plugins. The server seems to crash when I try to start it. I’m sure how to fix this problem.

Here are the relevant lines from sonar.properties:

sonar.jdbc.username=sonarqube
sonar.jdbc.password=sonarqube
sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube
sonar.web.host=127.0.0.1
sonar.web.context=/sonarqube
sonar.web.port=9000
sonar.path.data=~/Desktop/sonarqube-7.8/data
sonar.path.temp=~/Desktop/sonarqube-7.8/temp

Here are some lines from sonar.log:

    --> Wrapper Started as Daemon
    Launching a JVM...
    Unable to start JVM: No such file or directory (2)
    JVM exited while loading the application.
    JVM Restarts disabled.  Shutting down.
    <-- Wrapper Stopped
    --> 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.
    WrapperSimpleApp: Encountered an error running main: java.io.IOException: Unable to create directory /var/sonarqube/data
    java.io.IOException: Unable to create directory /var/sonarqube/data
    	at org.apache.commons.io.FileUtils.forceMkdir(FileUtils.java:2491)
    	at org.sonar.application.AppFileSystem.createDirectory(AppFileSystem.java:80)
    	at org.sonar.application.AppFileSystem.reset(AppFileSystem.java:59)
    	at org.sonar.application.App.start(App.java:63)
    	at org.sonar.application.App.main(App.java:99)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
    	at java.base/java.lang.Thread.run(Thread.java:834)
    <-- Wrapper Stopped

Here are some lines from web.log

    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:88)
    	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:157)
    	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)
    	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
    	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
    	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:119)
    	at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:85)
    	... 24 common frames omitted
    Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "sonaruser")
    	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)
    	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110)
    	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563)
    	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:116)
    	... 25 common frames omitted
    Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "sonaruser"
    	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
    	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
    	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
    	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
    	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
    	at org.postgresql.Driver.makeConnection(Driver.java:454)
    	at org.postgresql.Driver.connect(Driver.java:256)
    	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)
    	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291)
    	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395)
    	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381)
    	... 30 common frames omitted
    2019.06.25 08:05:01 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
     java.base@11.0.1/java.lang.Thread.sleep(Native Method)
     app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
    2019.06.25 08:05:01 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
     java.base@11.0.1/jdk.internal.misc.Unsafe.park(Native Method)
     java.base@11.0.1/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)
     java.base@11.0.1/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)
     java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)
     java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)
     java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
     java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
     java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
     java.base@11.0.1/java.lang.Thread.run(Thread.java:834)

The main thing that I’m getting is that I’m not inputting a password for the user (which I do not know how, as I never got the opportunity to) and that I can’t create the directory (I changed it to the direct path to data and temp in the sonarqube folder instead. Is this not allowed?). Any help would be appreciated.

ganncamp · June 27, 2019, 11:42am

Hi,

First, you need to make sure the user running SonarQube has permissions to the SonarQube directory. That should solve the directory issue. For the database connection, in the same file where you configured the JDBC URL you should find sonar.jdbc.username and sonar.jdbc.password. Uncomment these settings and use them to configure your DB credentials.

Ann

Jerry1 · July 3, 2019, 11:37pm

Hi,

Are those

different than the settings that I put above?

Jerry1 · July 3, 2019, 11:56pm

I also tried to start the installation again from scratch, and the sonar.log error went away, but a new error occurred in the web.log.

2019.07.03 14:52:25 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.07.03 14:52:26 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.07.03 14:52:27 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.07.03 14:52:27 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.07.03 14:52:27 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.07.03 14:52:27 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.07.03 14:52:27 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.03 14:52:29 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.07.03 14:52:29 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.0.26994 / 687d8007c0f62bfaaa44a890d93397de0a588119
2019.07.03 14:52:29 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost/sonarqube?currentSchema=sonarschema
2019.07.03 14:52:29 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)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
	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:134)
	at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:87)
	... 24 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: database "sonarqube" does not exist)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563)
	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:131)
	... 25 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: database "sonarqube" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
	at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2559)
	at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:133)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:250)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
	at org.postgresql.Driver.makeConnection(Driver.java:454)
	at org.postgresql.Driver.connect(Driver.java:256)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381)
	... 30 common frames omitted
2019.07.03 14:52:29 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/java.lang.Thread.sleep(Native Method)
 app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
2019.07.03 14:52:29 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/jdk.internal.misc.Unsafe.park(Native Method)
 java.base@11.0.1/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)
 java.base@11.0.1/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)
 java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)
 java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)
2019.07.03 14:52:29 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/sun.nio.ch.EPoll.wait(Native Method)
 java.base@11.0.1/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)
 app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)
 app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)
 app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)
 app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)
2019.07.03 14:52:29 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/jdk.internal.misc.Unsafe.park(Native Method)
 java.base@11.0.1/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.awaitMatch(LinkedTransferQueue.java:743)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.xfer(LinkedTransferQueue.java:684)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.take(LinkedTransferQueue.java:1366)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)

Here is another error that repeats after the previous block:

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:107)
	at org.sonar.server.platform.Platform.start(Platform.java:211)
	at org.sonar.server.platform.Platform.startLevel2Container(Platform.java:177)
	at org.sonar.server.platform.Platform.init(Platform.java:87)
	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)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
	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:2440)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
	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)

Here are the uncommented in my sonar.properties:

sonar.jdbc.username= sonaruser
sonar.jdbc.password= test1
sonar.jdbc.url=jdbc:postgresql://localhost:9000/sonarqube
sonar.web.host=0.0.0.0
sonar.web.context=/sonarqube
sonar.web.port=9000
sonar.path.data=data
sonar.path.temp=temp

My main questions are:

Why does it say my database does not exist?
Why am I potentially getting a memory leak?

The main error:

The webpage does not load, but SonarQube is running and it doesn’t explicitly say I can’t connect to the server.

ganncamp · July 8, 2019, 6:22pm

Hi,

Are you sure the schema you created in your localhost Postgres instance is named “sonarqube”? Not maybe “sonar”?

Let’s get your DB connectivity sorted out and then come back to this if it still exists at that point.

Ann

Jerry1 · July 8, 2019, 10:01pm

I actually went back to using the default “public” schema after the reinstall using:

sonar.jdbc.url=jdbc:postgresql://localhost:9000/sonarqube?currentSchema=public

Do they need to have the same name? When I tried before with the same name, there was no difference in behavior, so I just used the public schema instead. (UPDATE: I made a new schema again with name “sonarqube” and still have the same results)

My logs also have no errors now/ are much shortened. However, I still have the problem where the site doesn’t load. Here are my logs:

web.log:

2019.07.08 07:52:55 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.07.08 07:52:56 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.07.08 07:52:57 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.07.08 07:52:57 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.07.08 07:52:57 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.07.08 07:52:57 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.07.08 07:52:57 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.08 07:52:59 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.07.08 07:52:59 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.0.26994 / 687d8007c0f62bfaaa44a890d93397de0a588119
2019.07.08 07:52:59 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost:9000/sonarqube?currentSchema=public

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.07.08 07:52:37 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp
2019.07.08 07:52:37 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2019.07.08 07:52:37 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch]: /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch/bin/elasticsearch
2019.07.08 07:52:37 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.07.08 07:52:38 INFO  app[][o.e.p.PluginsService] no modules loaded
2019.07.08 07:52:38 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.08 07:52:55 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2019.07.08 07:52:55 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9]: /usr/lib/jvm/jdk-11.0.1/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/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 -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/lib/jdbc/postgresql/postgresql-42.2.5.jar org.sonar.server.app.WebServer /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp/sq-process14196584768595748218properties

es.log

2019.07.08 07:52:47 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/home/dev (/dev/sdd)]], net usable_space [96.2gb], net total_space [251.8gb], types [ext4]
2019.07.08 07:52:47 INFO  es[][o.e.e.NodeEnvironment] heap size [1.9gb], compressed ordinary object pointers [true]
2019.07.08 07:52:47 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [g-5jEI02R5Sh-GCcSjmQvA]
2019.07.08 07:52:47 INFO  es[][o.e.n.Node] version[6.8.0], pid[9058], build[default/tar/65b6179/2019-05-15T20:06:13.172855Z], OS[Linux/4.15.0-54-generic/amd64], JVM[Oracle Corporation/OpenJDK 64-Bit Server VM/11.0.1/11.0.1+13]
2019.07.08 07:52:47 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/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xms2G, -Xmx2G, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch, -Des.path.conf=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [mapper-extras]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [percolator]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [repository-url]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2019.07.08 07:52:47 INFO  es[][o.e.p.PluginsService] no plugins loaded
2019.07.08 07:52:49 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.07.08 07:52:50 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2019.07.08 07:52:50 INFO  es[][o.e.n.Node] initialized
2019.07.08 07:52:50 INFO  es[][o.e.n.Node] starting ...
2019.07.08 07:52:51 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2019.07.08 07:52:51 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2019.07.08 07:52:54 INFO  es[][o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{3STuOFBCSiK37LKXJbsd9g}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2019.07.08 07:52:54 INFO  es[][o.e.c.s.ClusterApplierService] new_master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{3STuOFBCSiK37LKXJbsd9g}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{3STuOFBCSiK37LKXJbsd9g}{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.07.08 07:52:54 INFO  es[][o.e.n.Node] started
2019.07.08 07:52:54 INFO  es[][o.e.g.GatewayService] recovered [0] indices into cluster_state

ganncamp · July 9, 2019, 12:35pm

Hi,

Since your server logs look fine at this point, everything should be working. Could you be explicit about “the site doesn’t load”, please?

Ann

Colin · July 9, 2019, 12:49pm

This is a little suspect since SonarQube runs on port 9000 by default (postgres on 5432). Are you sure yoru JDBC url is right?

Jerry1 · July 9, 2019, 3:01pm

@ganncamp This is what I mean. The connection never completes, and the page remains blank and waiting for the server.

@Colin I have since changed it back to

sonar.jdbc.url=jdbc:postgresql://localhost:9000/sonarqube

I’m not sure that it is right since I haven’t been able to get this to work, although I thought that it should be working right now. What do you suggest I do?

Colin · July 9, 2019, 3:07pm

localhost:9000 is where SonarQube is running (or, at the moment, wants to be running). Nothing else can run on that port.

I assume you have also set up a PostgreSQL server that runs on a different port. You should point your jdbc url to that port (localhost:5432 isntead of localhost:9000 for example)

Jerry1 · July 9, 2019, 3:34pm

Here is the new web.log with the url as

sonar.jdbc.url=jdbc:postgresql://localhost:5432/sonarqube?currentSchema=sonarqube

2019.07.09 08:27:55 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.07.09 08:27:56 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.07.09 08:27:56 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.07.09 08:27:56 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.07.09 08:27:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.07.09 08:27:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.07.09 08:27:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.09 08:27:58 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.07.09 08:27:58 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.0.26994 / 687d8007c0f62bfaaa44a890d93397de0a588119
2019.07.09 08:27:58 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost:5432/sonarqube?currentSchema=sonarqube
2019.07.09 08:27:58 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)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
	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:134)
	at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:87)
	... 24 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: database "sonarqube" does not exist)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563)
	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:131)
	... 25 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: database "sonarqube" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
	at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2559)
	at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:133)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:250)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
	at org.postgresql.Driver.makeConnection(Driver.java:454)
	at org.postgresql.Driver.connect(Driver.java:256)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381)
	... 30 common frames omitted
2019.07.09 08:27:58 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/java.lang.Thread.sleep(Native Method)
 app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
2019.07.09 08:27:58 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/jdk.internal.misc.Unsafe.park(Native Method)
 java.base@11.0.1/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)
 java.base@11.0.1/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)
 java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)
 java.base@11.0.1/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)
2019.07.09 08:27:58 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/sun.nio.ch.EPoll.wait(Native Method)
 java.base@11.0.1/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)
 app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)
 app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)
 app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)
 app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)
2019.07.09 08:27:58 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/jdk.internal.misc.Unsafe.park(Native Method)
 java.base@11.0.1/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.awaitMatch(LinkedTransferQueue.java:743)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.xfer(LinkedTransferQueue.java:684)
 java.base@11.0.1/java.util.concurrent.LinkedTransferQueue.take(LinkedTransferQueue.java:1366)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)
 java.base@11.0.1/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)
2019.07.09 08:27:58 WARN  web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] 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:
 java.base@11.0.1/sun.nio.ch.EPoll.wait(Native Method)
 java.base@11.0.1/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)
 java.base@11.0.1/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)
 app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)
 app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)
 app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)
 app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)
 java.base@11.0.1/java.lang.Thread.run(Thread.java:834)

Is this change what you meant? It’s now saying that the database doesn’t exist and shuts down after launch; does that mean it can’t find the schema “sonarqube” or something else?

Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
Caused by: org.postgresql.util.PSQLException: FATAL: database "sonarqube" does not exist

ganncamp · July 9, 2019, 5:22pm

Hi,

You need to get an independent client and try to use the same URL and credentials to connect to your database that you’re feeding in to SonarQube. That should help you determine what’s wrong.

Ann

Jerry1 · July 9, 2019, 6:01pm

Hey Ann,

Can you elaborate a bit more on what you mean by independent client?

Jerry

ganncamp · July 9, 2019, 6:18pm

Hi Jerry,

Something like SquirrelSQL. Really anything you can use to connect independently of SonarQube.

Ann

Jerry1 · July 9, 2019, 6:55pm

Hey Ann,

I’m not sure how, but I managed to fix the previous errors. I recreated a new database called “sonarqube,” and also a new schema inside of it, also called “sonarqube.” I also added added the user “sonarqube” to the pg_hba.conf file.

Now, when I check the sonar.log, it says SonarQube is up, but the page is blank:

Firefox is the browser on the left, and chrome on the right.

In the web.log, I get these warnings:

2019.07.09 11:22:18 WARN  web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to a HTTPS URL.
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/show
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/views/definition
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/governance_reports/download
2019.07.09 11:22:18 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info

I also don’t have my license yet, so maybe that’s why?

ganncamp · July 9, 2019, 7:00pm

Hi,

What your browsers are telling you is that nothing is running on localhost on port 9000. So the question is, where is your SonarQube instance running? Are you using the browser on the same machine where sonarqube is running? And if so, what happens if you try the home IP (127.0.0.1:9000) instead of localhost?

Ann

Jerry1 · July 9, 2019, 7:10pm

The browser is being used on the same machine where SonarQube is running. The same thing happens with home IP.

ganncamp · July 9, 2019, 7:21pm

Then it seems your instance is not up after all. Have you checked the other logs in the logs directory?

Jerry1 · July 9, 2019, 8:17pm

Everywhere I check it looks to be up. Here are the logs:

web.log:

2019.07.09 13:07:54 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.07.09 13:07:55 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.07.09 13:07:55 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.07.09 13:07:56 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.07.09 13:07:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.07.09 13:07:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.07.09 13:07:56 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.09 13:07:57 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.07.09 13:07:57 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.0.26994 / 687d8007c0f62bfaaa44a890d93397de0a588119
2019.07.09 13:07:57 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost:5432/sonarqube?currentSchema=sonarqube
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9
2019.07.09 13:07:58 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.8.0.1574 / aec3dc8f5228aabd218e1cd31ac6e6515a43715d
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin GitHub Authentication for SonarQube / 1.5.0.870 / 153f7c7af7a264adb0fcbe5fee87bdd140a6a3a1
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.0.2.475 / b79a4724f3a9af1051266b4f8ca0460977295ead
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SAML 2.0 Authentication for SonarQube / 1.1.0.181 / 16fcb5be2d3bcfee8920b29cd758d8b957a18acb
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarABAP / 3.8.0.2034 / 2904652c6ef4863eaace62c40fec0512724430e4
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarApex / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarC# / 7.15.0.8572 / e0ad49e38a28a8fc333ba746fc998e48678f6a8b
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCFamily / 6.3.0.11371 / 87798a096368f2cee97709b9d41b9c135ac2600c
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCOBOL / 4.4.0.3403 / 87052f378052eedd582643a831d334123cf39965
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.1.1.1010 / 365e21fd0cb9035669fc59f6fec7c8fd28a7303b
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.5.1.1831 / a0c44437f6abb0feec76edd073f91fec64db2a6c
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.1.1.2000 / 40d55921c7a63b67386a053490d17b6723a46cd5
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.1.0.1615 / 4181edb5eff5605bec82dc0aa15ecd70eaa5857f
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 5.2.1.7778 / 49f34eaeaad59868d4353d89b1fc5c02bbe51976
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJava / 5.13.1.18282 / 568f8ed2349f48e250a9329895b9a870100dfbeb
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 3.2.0.4868 / ec66bd5f8490677eb0ebae82aa17c2a5d9c0e5e7
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLI / 1.10.0.1880 / 1f78eb283a8d0c3e7f911f3259094c5696adad64
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLSQL / 3.4.1.2576 / a27e6384088454d7160dd39ea5ba54a9929c15f4
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 1.14.0.3086 / a6ac95b01b57bfb5f4ca604b4234595bb9f04b7e
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarRPG / 2.3.0.1187 / e0c75c815c1ae3955d823f1abcc8c1718b2d69f7
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarSwift / 4.1.0.3087 / e71ead60ade025c4f22a8c29fc32ab7c90606ec9
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 1.9.0.3766 / 4a4080b78001a78d758d1d0fa0190fb9496b6f57
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTSQL / 1.4.0.3334 / 7b4dc9eeb6301765e09583a3d570b5941223e0b4
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB / 7.15.0.8572 / e0ad49e38a28a8fc333ba746fc998e48678f6a8b
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB6 / 2.6.0.1875 / cfa6ee80615b98744158f3981fb29497101a03f5
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Analysis / 7.9.0.5105 / 90f56794ddd2e4e4c4265743c44e508dfff03c32
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for C# / 7.9.0.5105 / 90f56794ddd2e4e4c4265743c44e508dfff03c32
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for Java / 7.9.0.5105 / 90f56794ddd2e4e4c4265743c44e508dfff03c32
2019.07.09 13:07:58 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for PHP / 7.9.0.5105 / 90f56794ddd2e4e4c4265743c44e508dfff03c32
2019.07.09 13:08:00 INFO  web[][o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2019.07.09 13:08:00 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@7423d075 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/properties*, ...]}]
2019.07.09 13:08:00 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2019.07.09 13:08:01 INFO  web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2019.07.09 13:08:02 INFO  web[][o.s.s.s.LogServerId] Server ID: 92D88F0A-AWvX-MK3pbPKzfWXlWYo
2019.07.09 13:08:02 WARN  web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to a HTTPS URL.
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/show
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/views/definition
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/governance_reports/download
2019.07.09 13:08:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2019.07.09 13:08:02 INFO  web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2019.07.09 13:08:02 INFO  web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2019.07.09 13:08:02 INFO  web[][com.sonarsource.E.G] Loaded virtual plugin License for SonarLint
2019.07.09 13:08:02 INFO  web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2019.07.09 13:08:02 INFO  web[][o.s.s.s.RegisterPlugins] Register plugins
2019.07.09 13:08:02 INFO  web[][o.s.s.s.RegisterMetrics] Register metrics
2019.07.09 13:08:03 INFO  web[][o.s.s.r.RegisterRules] Register rules
2019.07.09 13:08:13 INFO  web[][o.s.s.q.BuiltInQProfileRepositoryImpl] Load quality profiles
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register quality profiles
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile css/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile scala/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile jsp/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile js/Sonar way Recommended
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile js/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile py/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile apex/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile plsql/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile java/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile web/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile xml/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile flex/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile vbnet/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile swift/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile cpp/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile c/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile kotlin/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile go/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile rpg/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile vb/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile pli/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile tsql/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile ruby/Sonar way
2019.07.09 13:08:13 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile cs/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile cobol/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile php/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile php/PSR-2
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile php/Drupal
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile abap/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile objc/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile ts/Sonar way
2019.07.09 13:08:14 INFO  web[][o.s.s.q.RegisterQualityProfiles] Update profile ts/Sonar way recommended
2019.07.09 13:08:14 INFO  web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2019.07.09 13:08:14 INFO  web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@a24ab8f [pattern=UrlPattern{inclusions=[/api/issues/delete_comment.*, ...], exclusions=[/api/properties*, ...]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.DeprecatedPropertiesWsFilter@5fc6394f [pattern=UrlPattern{inclusions=[/api/properties/*], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceReroutingFilter@10a495ec [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, ...], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@7b69255a [pattern=UrlPattern{inclusions=[/sessions/init/*], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@583ad0a1 [pattern=UrlPattern{inclusions=[/oauth2/callback/*], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@22929489 [pattern=UrlPattern{inclusions=[/api/authentication/login], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@697a8410 [pattern=UrlPattern{inclusions=[/api/authentication/logout], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@5691fd22 [pattern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=[]}]
2019.07.09 13:08:14 INFO  web[][o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning is not started as there are no projects in this situation.
2019.07.09 13:08:14 INFO  web[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance
2019.07.09 13:08:14 INFO  web[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance (done) | time=6ms
2019.07.09 13:08:14 INFO  web[][o.s.s.p.p.PlatformLevelStartup] Running Enterprise Edition
2019.07.09 13:08:14 INFO  web[][o.s.s.p.Platform] WebServer is operational

sonar.log:

2019.07.09 13:07:28 INFO  app[][o.s.a.SchedulerImpl] Stopping SonarQube
2019.07.09 13:07:28 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is stopped
2019.07.09 13:07:29 INFO  app[][o.s.a.SchedulerImpl] Process[web] is stopped
2019.07.09 13:07:29 INFO  app[][o.s.a.SchedulerImpl] Process[es] is stopped
2019.07.09 13:07:29 WARN  app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2019.07.09 13:07:29 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped
--> 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.07.09 13:07:43 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp
2019.07.09 13:07:43 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2019.07.09 13:07:43 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch]: /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch/bin/elasticsearch
2019.07.09 13:07:43 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2019.07.09 13:07:43 INFO  app[][o.e.p.PluginsService] no modules loaded
2019.07.09 13:07:43 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2019.07.09 13:07:54 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2019.07.09 13:07:54 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9]: /usr/lib/jvm/jdk-11.0.1/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/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 -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/lib/jdbc/postgresql/postgresql-42.2.5.jar org.sonar.server.app.WebServer /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp/sq-process958527063551579742properties
2019.07.09 13:08:14 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
2019.07.09 13:08:14 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='ce', ipcIndex=3, logFilenamePrefix=ce]] from [/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9]: /usr/lib/jvm/jdk-11.0.1/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp --add-opens=java.base/java.util=ALL-UNNAMED -Xmx2G -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/lib/jdbc/postgresql/postgresql-42.2.5.jar org.sonar.ce.app.CeServer /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp/sq-process3157274158834936066properties
2019.07.09 13:08:19 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
2019.07.09 13:08:19 INFO  app[][o.s.a.SchedulerImpl] SonarQube is up

es.log:

2019.07.09 13:07:46 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/home/dev (/dev/sdd)]], net usable_space [96gb], net total_space [251.8gb], types [ext4]
2019.07.09 13:07:46 INFO  es[][o.e.e.NodeEnvironment] heap size [1.9gb], compressed ordinary object pointers [true]
2019.07.09 13:07:46 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [g-5jEI02R5Sh-GCcSjmQvA]
2019.07.09 13:07:46 INFO  es[][o.e.n.Node] version[6.8.0], pid[102510], build[default/tar/65b6179/2019-05-15T20:06:13.172855Z], OS[Linux/4.15.0-54-generic/amd64], JVM[Oracle Corporation/OpenJDK 64-Bit Server VM/11.0.1/11.0.1+13]
2019.07.09 13:07:46 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/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xms2G, -Xmx2G, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/elasticsearch, -Des.path.conf=/home/dev/sonarQubeEnterpriseTest/sonarqube-7.9/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [mapper-extras]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [percolator]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [repository-url]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2019.07.09 13:07:46 INFO  es[][o.e.p.PluginsService] no plugins loaded
2019.07.09 13:07:48 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.07.09 13:07:49 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2019.07.09 13:07:49 INFO  es[][o.e.n.Node] initialized
2019.07.09 13:07:49 INFO  es[][o.e.n.Node] starting ...
2019.07.09 13:07:49 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2019.07.09 13:07:49 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2019.07.09 13:07:52 INFO  es[][o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{dSv8xVm9SuiBWyGcebDEeA}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2019.07.09 13:07:52 INFO  es[][o.e.c.s.ClusterApplierService] new_master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{dSv8xVm9SuiBWyGcebDEeA}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{g-5jEI02R5Sh-GCcSjmQvA}{dSv8xVm9SuiBWyGcebDEeA}{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.07.09 13:07:52 INFO  es[][o.e.n.Node] started
2019.07.09 13:07:53 INFO  es[][o.e.g.GatewayService] recovered [7] indices into cluster_state
2019.07.09 13:07:54 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[components][2], [components][3], [metadatas][0]] ...]).

ce.log:

2019.07.09 13:08:14 INFO  ce[][o.s.p.ProcessEntryPoint] Starting ce
2019.07.09 13:08:14 INFO  ce[][o.s.ce.app.CeServer] Compute Engine starting up...
2019.07.09 13:08:15 INFO  ce[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.07.09 13:08:15 INFO  ce[][o.e.p.PluginsService] no modules loaded
2019.07.09 13:08:15 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.07.09 13:08:15 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.07.09 13:08:15 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.07.09 13:08:16 INFO  ce[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.07.09 13:08:16 INFO  ce[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost:5432/sonarqube?currentSchema=sonarqube
2019.07.09 13:08:18 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /home/dev/sonarQubeEnterpriseTest/sonarqube-7.9
2019.07.09 13:08:18 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
2019.07.09 13:08:19 INFO  ce[][o.s.c.c.ComputeEngineContainerImpl] Running Enterprise edition
2019.07.09 13:08:19 INFO  ce[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance
2019.07.09 13:08:19 INFO  ce[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance (done) | time=8ms
2019.07.09 13:08:19 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is operational

Is this normal behavior?

Colin · July 9, 2019, 8:52pm

try localhost:9000/sonarqube