Upgrade from Sonarqube Version 9.9.8.100196 to 10.8.1.101195

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube Server / Community Build, Scanner, Plugin, and any relevant extension) - 10.8.1.101195
  • how is SonarQube deployed: zip, Docker, Helm - ZIP
  • what are you trying to achieve – Upgrade from Sonarqube Version 9.9.8.100196 to 10.8.1.101195
  • what have you tried so far to achieve this – Database Migration successful, SQL errors while starting the sonarqube

Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

I am performing upgrade in windows 11 OS. I can able to migrate the dabase successfully however getting below SQL errors in web.log while starting the appliction. Issues started appearning at line web[]o.s.s.r.r.RulesRegistrant] Register rules after an hour printing this line. Let me know if any additional information needed to resolve the issue. Thank you in advance

2025.06.20 10:52:03 INFO  web[][o.s.s.r.r.RulesRegistrant] Register rules
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@43a51d00 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@1f83d8d6 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@205d6f76 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@5903ad4f (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@f3b7a3 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@1b79a03 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@4a5a639c (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@ef7c64d (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@1324269f (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.pool.PoolBase] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@2efed17a (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2025.06.20 12:23:16 WARN  web[][c.z.h.p.ProxyConnection] HikariPool-1 - Connection org.postgresql.jdbc.PgConnection@53c0818e marked as broken because of SQLSTATE(08006), ErrorCode(0)
java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:585)
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:888)
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:912)
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1739)
	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:126)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
	at org.apache.ibatis.executor.BaseExecutor.commit(BaseExecutor.java:248)
	at org.apache.ibatis.executor.CachingExecutor.commit(CachingExecutor.java:120)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:223)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:217)
	at org.sonar.db.DbSessionImpl.commit(DbSessionImpl.java:42)
	at org.sonar.db.BatchSession.commit(BatchSession.java:168)
	at org.sonar.db.BatchSession.increment(BatchSession.java:205)
	at org.sonar.db.BatchSession.insert(BatchSession.java:125)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	at jdk.proxy2/jdk.proxy2.$Proxy135.insertRuleDescriptionSection(Unknown Source)
	at org.sonar.db.rule.RuleDao.lambda$insertRuleDescriptionSectionDtos$4(RuleDao.java:141)
	at java.base/java.lang.Iterable.forEach(Iterable.java:75)
	at org.sonar.db.rule.RuleDao.insertRuleDescriptionSectionDtos(RuleDao.java:141)
	at org.sonar.db.rule.RuleDao.updateRuleDescriptionSectionDtos(RuleDao.java:136)
	at org.sonar.db.rule.RuleDao.update(RuleDao.java:124)
	at org.sonar.server.rule.registration.RulesRegistrant.update(RulesRegistrant.java:384)
	at org.sonar.server.rule.registration.RulesRegistrant.persistRules(RulesRegistrant.java:239)
	at org.sonar.server.rule.registration.RulesRegistrant.registerRules(RulesRegistrant.java:199)
	at org.sonar.server.rule.registration.RulesRegistrant.start(RulesRegistrant.java:119)
	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)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
	at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
	at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:58)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:134)
	at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:131)
	at org.sonar.server.platform.PlatformImpl.executeStartupTasks(PlatformImpl.java:204)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.runIfNotAborted(PlatformImpl.java:365)
	at org.sonar.server.platform.PlatformImpl$1.doRun(PlatformImpl.java:119)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.run(PlatformImpl.java:349)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:586)
	... 52 common frames omitted
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:328)
	at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355)
	at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808)
	at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966)
	at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484)
	at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478)
	at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70)
	at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1465)
	at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1069)
	at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:192)
	at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:159)
	at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:144)
	at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:76)
	at org.postgresql.core.PGStream.receiveChar(PGStream.java:476)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2174)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:580)
	... 52 common frames omitted
2025.06.20 12:23:18 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@4e0e2f2a-org.sonar.server.rule.registration.RulesRegistrant': Initialization of bean failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)\n    VALUES (\n    ('AYNj516ZIh2xqd2FUVBq'),\n    ('MAINTAINABILITY'),\n    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.\r\n### Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)\n    VALUES (\n    ('AYNj516ZIh2xqd2FUVBq'),\n    ('MAINTAINABILITY'),\n    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
2025.06.20 12:23:18 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@4e0e2f2a-org.sonar.server.rule.registration.RulesRegistrant': Initialization of bean failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	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:336)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
	at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
	at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:58)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:134)
	at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:131)
	at org.sonar.server.platform.PlatformImpl.executeStartupTasks(PlatformImpl.java:204)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.runIfNotAborted(PlatformImpl.java:365)
	at org.sonar.server.platform.PlatformImpl$1.doRun(PlatformImpl.java:119)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.run(PlatformImpl.java:349)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:226)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:217)
	at org.sonar.db.DbSessionImpl.commit(DbSessionImpl.java:42)
	at org.sonar.db.BatchSession.commit(BatchSession.java:168)
	at org.sonar.db.BatchSession.increment(BatchSession.java:205)
	at org.sonar.db.BatchSession.insert(BatchSession.java:125)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	at jdk.proxy2/jdk.proxy2.$Proxy135.insertRuleDescriptionSection(Unknown Source)
	at org.sonar.db.rule.RuleDao.lambda$insertRuleDescriptionSectionDtos$4(RuleDao.java:141)
	at java.base/java.lang.Iterable.forEach(Iterable.java:75)
	at org.sonar.db.rule.RuleDao.insertRuleDescriptionSectionDtos(RuleDao.java:141)
	at org.sonar.db.rule.RuleDao.updateRuleDescriptionSectionDtos(RuleDao.java:136)
	at org.sonar.db.rule.RuleDao.update(RuleDao.java:124)
	at org.sonar.server.rule.registration.RulesRegistrant.update(RulesRegistrant.java:384)
	at org.sonar.server.rule.registration.RulesRegistrant.persistRules(RulesRegistrant.java:239)
	at org.sonar.server.rule.registration.RulesRegistrant.registerRules(RulesRegistrant.java:199)
	at org.sonar.server.rule.registration.RulesRegistrant.start(RulesRegistrant.java:119)
	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)
	... 19 common frames omitted
Caused by: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.rule.RuleMapper.insertRuleDefaultImpact (batch index #67) failed. 66 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:148)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
	at org.apache.ibatis.executor.BaseExecutor.commit(BaseExecutor.java:248)
	at org.apache.ibatis.executor.CachingExecutor.commit(CachingExecutor.java:120)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:223)
	... 41 common frames omitted
Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO rules_default_impacts (rule_uuid, software_quality, severity)
    VALUES (
    ('AYNj516ZIh2xqd2FUVBq'),
    ('MAINTAINABILITY'),
    ('MEDIUM')) was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:585)
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:888)
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:912)
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1739)
	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:126)
	... 46 common frames omitted
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:586)
	... 52 common frames omitted
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:328)
	at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355)
	at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808)
	at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966)
	at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484)
	at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478)
	at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70)
	at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1465)
	at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1069)
	at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:192)
	at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:159)
	at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:144)
	at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:76)
	at org.postgresql.core.PGStream.receiveChar(PGStream.java:476)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2174)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:580)
	... 52 common frames omitted
2025.06.20 12:23:18 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process
2025.06.20 12:23:18 INFO  web[][o.s.s.n.NotificationDaemon] Notification service stopped

Hey there.

The first thing I suggest is restoring your database from a backup to get you back to a known good state.

The second thing I suggest is not targeting v10.8. If you’re using a commercial edition of SonarQube (Developer, Enterprise, Data Center) you should target v2025.1 LTA

If you use SonarQube’s Community Build (nee Community Edition), you should target v24.12 before moving onto the latest version, v25.6.

Here’s a handy calculator.

Come back if the problem persists!

Thank you, Colin for your response. The issue was resolved by increasing sonar.jdbc.maxLifetime to 2 hours, as establishing the connection was taking more than an hour.