Unable to start sonarqube java 17 postgreql

grass · September 21, 2023, 11:48pm

Unable to start sonarqube, can you please help?

2023.09.21 18:28:00 INFO web[][o.s.p.ProcessEntryPoint] Starting Web Server

2023.09.21 18:28:01 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 10.2.0.77647 / 41720a6b875d18d6be85639764aab23cf35c3c03

2023.09.21 18:28:01 INFO web[][o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://localhost/sonarqube?currentSchema=my_schema

2023.09.21 18:28:01 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Starting...

2023.09.21 18:28:01 INFO web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@48ea2003

2023.09.21 18:28:01 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.

2023.09.21 18:28:01 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /Users/user1/Documents/sonarqube-10.2.0.77647

2023.09.21 18:28:01 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled

2023.09.21 18:28:01 INFO web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license, monitoring, gitlab-vulnerability-report

2023.09.21 18:28:01 INFO web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations

2023.09.21 18:28:01 WARN web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Failed to create table schema_migrations

2023.09.21 18:28:01 ERROR web[][o.s.s.p.w.PlatformServletContextListener] Web server startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Failed to create table schema_migrations

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)

at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:920)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)

at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:187)

at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)

at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:101)

at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:214)

at org.sonar.server.platform.PlatformImpl.startLevel2Container(PlatformImpl.java:186)

at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:80)

at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4494)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4946)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)

at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)

at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:871)

at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:795)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)

at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)

at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:871)

at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:249)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

at org.apache.catalina.core.StandardService.startInternal(StandardService.java:428)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:917)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

at org.apache.catalina.startup.Tomcat.start(Tomcat.java:486)

at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:71)

at org.sonar.server.app.WebServer.start(WebServer.java:55)

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:104)

Caused by: java.lang.IllegalStateException: Failed to create table schema_migrations

at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:48)

at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)

... 44 common frames omitted

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:2713)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292)

at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)

at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)

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)

... 48 common frames omitted

2023.09.21 18:28:01 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown initiated...

2023.09.21 18:28:01 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown completed.

2023.09.21 18:28:01 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000

2023.09.21 18:28:01 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process

grass · September 22, 2023, 10:32am

2023.09.22 05:19:34 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /Users/user1/Documents/sonarqube-10.2.0.77647/temp
2023.09.22 05:19:34 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:53366]
2023.09.22 05:19:34 INFO app[o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/Users/user1/Documents/sonarqube-10.2.0.77647/elasticsearch]: /Library/Java/JavaVirtualMachines/jdk-17.jdk/Contents/Home/bin/java -Xms4m -Xmx64m -XX:+UseSerialGC -Dcli.name=server -Dcli.script=./bin/elasticsearch -Dcli.libs=lib/tools/server-cli -Des.path.home=/Users/user1/Documents/sonarqube-10.2.0.77647/elasticsearch -Des.path.conf=/Users/user1/Documents/sonarqube-10.2.0.77647/temp/conf/es -Des.distribution.type=tar -cp /Users/user1/Documents/sonarqube-10.2.0.77647/elasticsearch/lib/:/Users/user1/Documents/sonarqube-10.2.0.77647/elasticsearch/lib/cli-launcher/ org.elasticsearch.launcher.CliToolLauncher
2023.09.22 05:19:34 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2023.09.22 05:19:41 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2023.09.22 05:19:41 INFO app[o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [/Users/user1/Documents/sonarqube-10.2.0.77647]: /Library/Java/JavaVirtualMachines/jdk-17.jdk/Contents/Home/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/Users/user1/Documents/sonarqube-10.2.0.77647/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 --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -Dcom.redhat.fips=false -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.2.0.77647.jar:/Users/user1/Documents/sonarqube-10.2.0.77647/lib/jdbc/postgresql/postgresql-42.6.0.jar org.sonar.server.app.WebServer /Users/user1/Documents/sonarqube-10.2.0.77647/temp/sq-process14887607041562916256properties
2023.09.22 05:19:46 INFO app[o.s.a.SchedulerImpl] Process[Web Server] is stopped
2023.09.22 05:19:46 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 143
2023.09.22 05:19:46 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2023.09.22 05:19:46 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

Colin · September 27, 2023, 3:16pm

Does my_schema really exist on your database under the sonarqube? Try removing it from your JDBC URL.