Unable to start sonarqube webserver install issues

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

Hi,

What do your other server logs say?

 
Ann