Cause: java.sql.SQLException: Data source is closed

Must-share information (formatted with Markdown):

  • which versions are you using: 8.9.10
  • how is SonarQube deployed: Helm
  • what are you trying to achieve: Migration of of data from Sandbox zone to another CI zone.
  • what have you tried so far to achieve this: Data Migration, Helm Configuration etc and Deployment of helm charts changes.
  • postgres version: 15

org.apache.ibatis.exceptions.PersistenceException:

### Error querying database. Cause: java.sql.SQLException: Data source is closed

### The error may exist in org.sonar.db.ce.CeQueueMapper

### The error may involve org.sonar.db.ce.CeQueueMapper.selectByUuid

### The error occurred while executing a query

### Cause: java.sql.SQLException: Data source is closed

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)

at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)

at com.sun.proxy.$Proxy24.selectByUuid(Unknown Source)

at org.sonar.db.ce.CeQueueDao.selectByUuid(CeQueueDao.java:85)

at org.sonar.ce.queue.InternalCeQueueImpl.remove(InternalCeQueueImpl.java:122)

at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.finalizeTask(CeWorkerImpl.java:245)

at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.afterExecute(CeWorkerImpl.java:239)

at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.close(CeWorkerImpl.java:199)

at org.sonar.ce.taskprocessor.CeWorkerImpl.findAndProcessTask(CeWorkerImpl.java:161)

at org.sonar.ce.taskprocessor.CeWorkerImpl$TrackRunningState.get(CeWorkerImpl.java:135)

at org.sonar.ce.taskprocessor.CeWorkerImpl.call(CeWorkerImpl.java:87)

at org.sonar.ce.taskprocessor.CeWorkerImpl.call(CeWorkerImpl.java:53)

at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)

at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)

at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Data source is closed

at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:521)

at org.apache.commons.dbcp2.BasicDataSource$PaGetConnection.run(BasicDataSource.java:73)

at org.apache.commons.dbcp2.BasicDataSource$PaGetConnection.run(BasicDataSource.java:69)

at java.base/java.security.AccessController.doPrivileged(Native Method)

at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:744)

at org.sonar.db.profiling.NullConnectionInterceptor.getConnection(NullConnectionInterceptor.java:31)

at org.sonar.db.profiling.ProfiledDataSource.getConnection(ProfiledDataSource.java:317)

at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:139)

at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)

at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)

at org.apache.ibatis.executor.ReuseExecutor.prepareStatement(ReuseExecutor.java:88)

at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:59)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)

... 24 common frames omitted

Hi,

Your version is past EOL. You should upgrade to either the latest version or the current LTS at your earliest convenience. Your upgrade path is:

8.9.10 → 9.9.1 → 10.1 (last step optional)

You may find these resources helpful:

If you have questions about upgrading, feel free to open a new thread for that here.

If your error persists after upgrade, please come back to us.

 
Ann