Sonarqube install script errors creating table schema_migrations (postgres RDS)

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
  • what are you trying to achieve
  • what have you tried so far to achieve this

Hi,

Welcome to the community!

You haven’t given us much to go on here. Before anyone can help you you’re going to need to provide more details.

 
Ann

Hello. I have somnarcube connected to a AWS Postgres Aurora Cluster. The user I created for the database has superuser permissions. I am able to connect to the RDS from my server. I set up the config file as such.
sonar.jdbc.url=jdbc:postgresql://xxxxxxxx-xxxxxxx-xxxxxx-xxxxxxx:5432/sonarqube?

I get this error below in the web.log

2019.09.09 09:28:33 INFO web[o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2019.09.09 09:28:33 ERROR web[o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Failed to create table schema_migrations

Hi,

Take a look at this post & see if it helps:

 
Ann

Talked to my DBA. HE said he created the table. Still getting the same error. Here are the log files sonar.log

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

2019.09.12 15:22:58 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonar/temp
2019.09.12 15:22:58 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2019.09.12 15:22:58 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonar/elasticsearch]: /opt/sonar/elasticsearch/bin/elasticsearch
2019.09.12 15:22:58 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.09.12 15:22:59 INFO  app[][o.e.p.PluginsService] no modules loaded
2019.09.12 15:22:59 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.09.12 15:23:11 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2019.09.12 15:23:11 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonar]: /usr/lib/jvm/java-11-openjdk-11.0.4.11-0.el7_6.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonar/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/*:/opt/sonar/lib/jdbc/postgresql/postgresql-42.2.5.jar org.sonar.server.app.WebServer /opt/sonar/temp/sq-process3413622168226531192properties
2019.09.12 15:23:18 INFO  app[][o.s.a.SchedulerImpl] Process[web] is stopped
2019.09.12 15:23:18 WARN  app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2019.09.12 15:23:18 INFO  app[][o.s.a.SchedulerImpl] Process[es] is stopped
2019.09.12 15:23:18 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped

Here are the web.log logs.

2019.09.12 15:22:02 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.09.12 15:22:02 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.09.12 15:22:03 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.09.12 15:22:03 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.09.12 15:22:03 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.09.12 15:22:03 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.09.12 15:22:03 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.09.12 15:22:05 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.09.12 15:22:05 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.1.27448 / e0c45c97bb2e45d52629f3422ac91718020f6db9
2019.09.12 15:22:05 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sharedpostgresdb-cluster-test.cluster-ro-cjopepouww6r.us-east-1.rds.amazonaws.com:5432/sonarqube?
2019.09.12 15:22:07 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonar
2019.09.12 15:22:07 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2019.09.12 15:22:07 INFO  web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2019.09.12 15:22:07 ERROR web[][o.s.s.p.Platform] 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: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: cannot execute CREATE TABLE in a read-only transaction
        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)
        ... 15 common frames omitted
2019.09.12 15:22:08 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9003
2019.09.12 15:22:08 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process
2019.09.12 15:23:12 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2019.09.12 15:23:13 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.09.12 15:23:13 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport
2019.09.12 15:23:14 INFO  web[][o.e.p.PluginsService] no modules loaded
2019.09.12 15:23:14 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.09.12 15:23:14 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.09.12 15:23:14 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.09.12 15:23:15 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.09.12 15:23:15 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.1.27448 / e0c45c97bb2e45d52629f3422ac91718020f6db9
2019.09.12 15:23:15 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sharedpostgresdb-cluster-test.cluster-ro-cjopepouww6r.us-east-1.rds.amazonaws.com:5432/sonarqube?
2019.09.12 15:23:17 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonar
2019.09.12 15:23:17 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2019.09.12 15:23:17 INFO  web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2019.09.12 15:23:17 ERROR web[][o.s.s.p.Platform] 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: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: cannot execute CREATE TABLE in a read-only transaction
        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)
        ... 15 common frames omitted
2019.09.12 15:23:18 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9003
2019.09.12 15:23:18 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process

Hi,

This seems to be your problem:

I’m not sure how you got into a ‘read-only transaction’ state. SonarQube doesn’t put itself there. You probably need to investigate this permissioning with your DBA.

 
Good luck!
Ann

Thanks. I am working with the DBA. He said he turned the read-only transaction to off. Where do you set the PostgreSQL search_path .

"ALTER USER mySonarUser SET search_path to mySonarQubeSchema"

This may be causing the issue.

Hi,

All I know is that the SonarQube user needs all rights on its schema.

 
Ann

Sonarqube user has all rights on its schema. Here are my sonar.properties configurations.

The schema must be created first.

sonar.jdbc.username= sonaruser
sonar.jdbc.password= xxxxxxxxx

#----- PostgreSQL 9.3 or greater

By default the schema named “public” is used. It can be overridden with the parameter “currentSchema”.

sonar.jdbc.url=jdbc:postgresql://sharedxxxxxxx-cluster-test.cluster-roxxxxxxxxxx.us-east-1.rds.amazonaws.com:5432/sonarqube

user “sonaruser” has all rights on its schema.

Same result. Is this the correct way to configure this line if I am using the current schema?

sonar.jdbc.url=jdbc:postgresql://sharedxxxxxxx-cluster-test.cluster-roxxxxxxxxxx.us-east-1.rds.amazonaws.com:5432/sonarqube