- SonarQube version: 9.6, 9.6.1
- Environment: Linux, OpenJDK 11, Oracle 19C database, ojdbc8 driver
- Plugins: Crowd 2.2 (but have tested without plugin and error still occurs)
Upgrading from 9.2.4 to 9.6/9.6.1, startup after upgrade throws the following error
2022.09.05 22:13:13 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [rules/rule/activeRule]...
2022.09.05 22:13:13 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [rules/rule/activeRule] done | time=621ms
2022.09.05 22:13:13 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [rules/rule]...
2022.09.05 22:13:19 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [rules/rule] done | time=5282ms
2022.09.05 22:13:19 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [users/user]...
2022.09.05 22:13:19 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [users/user] done | time=409ms
2022.09.05 22:13:19 INFO web[][o.s.s.e.IndexerStartupTask] Indexing of type [projectmeasures/auth/projectmeasure]...
2022.09.05 22:13:24 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
java.lang.IllegalStateException: Fail to execute request to select measures of project AYLatv66gsPavjZzbDot
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.selectMeasures(ProjectMeasuresIndexerIterator.java:219)
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.doNext(ProjectMeasuresIndexerIterator.java:189)
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.doNext(ProjectMeasuresIndexerIterator.java:52)
at org.sonar.core.util.CloseableIterator.bufferNext(CloseableIterator.java:96)
at org.sonar.core.util.CloseableIterator.hasNext(CloseableIterator.java:87)
at org.sonar.server.measure.index.ProjectMeasuresIndexer.doIndex(ProjectMeasuresIndexer.java:158)
at org.sonar.server.measure.index.ProjectMeasuresIndexer.indexOnStartup(ProjectMeasuresIndexer.java:73)
at org.sonar.server.es.IndexerStartupTask.synchronousIndexing(IndexerStartupTask.java:83)
at org.sonar.server.es.IndexerStartupTask.indexUninitializedTypes(IndexerStartupTask.java:68)
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
at org.sonar.server.es.IndexerStartupTask.execute(IndexerStartupTask.java:53)
at java.base/java.util.Optional.ifPresent(Optional.java:183)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:128)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:45)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:124)
at org.sonar.server.platform.PlatformImpl.executeStartupTasks(PlatformImpl.java:183)
at org.sonar.server.platform.PlatformImpl$1.lambda$doRun$1(PlatformImpl.java:107)
at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.runIfNotAborted(PlatformImpl.java:344)
at org.sonar.server.platform.PlatformImpl$1.doRun(PlatformImpl.java:107)
at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.run(PlatformImpl.java:328)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.IllegalStateException: Fail to execute request to select the project biggest branch
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.selectProjectBiggestBranch(ProjectMeasuresIndexerIterator.java:310)
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.selectMeasures(ProjectMeasuresIndexerIterator.java:208)
... 21 common frames omitted
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
at org.sonar.db.measure.ProjectMeasuresIndexerIterator.selectProjectBiggestBranch(ProjectMeasuresIndexerIterator.java:303)
... 22 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
We do have a large number of projects (2000+) but this was fine prior to upgrade.
Thanks