We are exepriencing a timeout issue while analyzing large repositories using Sonarqube in our azure pipelines. The default connection timeout of 8000ms was increased to maximum allowed value to accomodate these repositories. However overtime, cache fills up, causing SonarQube to revert to the default timeout, resulting in analysis failures.
Version : 10.4 Community Edition
Deployment: Through Docker
Trying to achieve
We are trying to see to it that the limits don’t stop working after some time and change back to the default always.
Things we did
we have observed that the if we restart the SonarQube instance it works fine but everytime there’s a large repository, it fails and then we are restarting the instance to make it run. we want to make it work without restarting it.
Is it possible to to make it work without a restart or whether any workaround is possible for this?
[warning]Error while executing SonarQube:Publish task: [SQ] Task failed with status FAILED, Error message:
Error querying database. Cause: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
The error may exist in org.sonar.db.source.FileSourceMapper
The error may involve org.sonar.db.source.FileSourceMapper.selectLineHashesVersion
The error occurred while executing a query
Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
Cause: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
The error may exist in org.sonar.db.source.FileSourceMapper
The error may involve org.sonar.db.source.FileSourceMapper.selectLineHashesVersion
The error occurred while executing a query
Cause: j
[error][SQ] Task failed with status FAILED, Error message:
Error querying database. Cause: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
The error may exist in org.sonar.db.source.FileSourceMapper
The error may involve org.sonar.db.source.FileSourceMapper.selectLineHashesVersion
The error occurred while executing a query
Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
Cause: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
The error may exist in org.sonar.db.source.FileSourceMapper
The error may involve org.sonar.db.source.FileSourceMapper.selectLineHashesVersion
The error occurred while executing a query
Cause: j
Finishing: SonarQubePublish