Error querying database

Using versions:

  • SonarQube: 10.4.0.87286
  • SonarScanner: 6.1.0.4477-linux-x64

How is SonarQube deployed

  • Docker via build step in Jenkins pipeline

What am I trying to achieve

  • Enable iterative builds for C++ project (not sure if that is relevant for this problem)

What have I tried so far to achieve this

  • Attempted to solve the following bug.

When attempting to build and analyse my project I get the following error, this information is gathered via Project SettingsBackground Task in SonarQube:

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.property.InternalPropertiesMapper
### The error may involve org.sonar.db.property.InternalPropertiesMapper.selectAsText
### The error occurred while executing a query
### Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	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.$Proxy53.selectAsText(Unknown Source)
	at org.sonar.db.property.InternalPropertiesDao.selectByKey(InternalPropertiesDao.java:179)
	at org.sonar.server.property.InternalPropertiesImpl.read(InternalPropertiesImpl.java:44)
	at com.sonarsource.u.n.Ȅ(Unknown Source)
	at com.sonarsource.u.x.V.Ȅ(Unknown Source)
	at com.sonarsource.u.x.V.onCheck(Unknown Source)
	at org.sonar.ce.task.projectanalysis.measure.PostMeasuresComputationChecksStep.execute(PostMeasuresComputationChecksStep.java:70)
	at org.sonar.ce.task.step.ComputationStepExecutor.executeStep(ComputationStepExecutor.java:79)
	at org.sonar.ce.task.step.ComputationStepExecutor.executeSteps(ComputationStepExecutor.java:70)
	at org.sonar.ce.task.step.ComputationStepExecutor.execute(ComputationStepExecutor.java:57)
	at org.sonar.ce.task.projectanalysis.taskprocessor.ReportTaskProcessor.process(ReportTaskProcessor.java:75)
	at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.executeTask(CeWorkerImpl.java:212)
	at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.run(CeWorkerImpl.java:194)
	at org.sonar.ce.taskprocessor.CeWorkerImpl.findAndProcessTask(CeWorkerImpl.java:160)
	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:131)
	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:76)
	at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 8000ms.
	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
	at org.sonar.db.profiling.NullConnectionInterceptor.getConnection(NullConnectionInterceptor.java:31)
	at org.sonar.db.profiling.ProfiledDataSource.getConnection(ProfiledDataSource.java:112)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:145)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:67)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
	at org.apache.ibatis.executor.ReuseExecutor.prepareStatement(ReuseExecutor.java:91)
	at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:61)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)

Whereas the SonarScanner (kicked off via Jenkins) gives me the following output:

...
22:16:59.058 INFO  SCM Publisher 5560/5560 source files have been analyzed (done) | time=29671ms
22:16:59.696 INFO  CPD Executor 70 files had no CPD blocks
22:16:59.696 INFO  CPD Executor Calculating CPD for 5482 files
22:17:00.608 INFO  CPD Executor CPD calculation finished (done) | time=912ms
22:17:01.509 INFO  Load New Code definition
22:17:01.534 INFO  Load New Code definition (done) | time=25ms
22:17:01.885 INFO  Analysis report generated in 926ms, dir size=40.0 MB
22:17:12.115 INFO  Analysis report compressed in 10228ms, zip size=18.7 MB
22:17:12.560 INFO  Analysis report uploaded in 443ms
22:17:12.561 INFO  ANALYSIS SUCCESSFUL, you can find the results at: https://sonar.robinradar.systems/dashboard?id=develop&branch=feature%2FRST-5350-enable-iterative-builds-in-sona
22:17:12.562 INFO  Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report
22:17:12.562 INFO  More about the report processing at https://sonar.robinradar.systems/api/ce/task?id=c36c11ba-5919-41a5-83c8-547d65b9040d
22:17:14.075 INFO  Analysis total time: 2:49.587 s
22:17:14.077 INFO  EXECUTION SUCCESS
22:17:14.077 INFO  Total time: 2:58.729s

I got no clue where to start looking on how to solve this anymore. I need help.
I use the following scanner settings.

Plugins:
Bundled analyzers:
  - Clean as You Code 2.3.0.1782 (cayc)
  - IaC Code Quality and Security 1.26.0.8471 (iac)
  - PL/SQL Code Quality and Security 3.12.0.6513 (plsql)
  - Scala Code Quality and Security 1.15.0.4655 (sonarscala)
  - C# Code Quality and Security 9.19.0.84025 (csharp)
  - Vulnerability Analysis 10.4.0.30099 (security)
  - Java Code Quality and Security 7.30.0.34429 (java)
  - HTML Code Quality and Security 3.13.0.4821 (web)
  - Flex Code Quality and Security 2.12.0.4568 (flex)
  - XML Code Quality and Security 2.10.0.4108 (xml)
  - Text Code Quality and Security 2.8.0.1635 (text)
  - VB.NET Code Quality and Security 9.19.0.84025 (vbnet)
  - Swift Code Quality and Security 4.12.0.7262 (swift)
  - CFamily Code Quality and Security 6.52.1.66618 (cpp)
  - Python Code Quality and Security 4.14.0.14263 (python)
  - Dataflow Bug Detection Rules for Python 1.22.0.7341 (dbdpythonfrontend)
  - Dataflow Bug Detection 1.22.0.7341 (dbd)
  - Go Code Quality and Security 1.15.0.4655 (go)
  - JaCoCo 1.3.0.1538 (jacoco)
  - Kotlin Code Quality and Security 2.20.0.4382 (kotlin)
  - Dataflow Bug Detection Rules for Java 1.22.0.7341 (dbdjavafrontend)
  - T-SQL Code Quality and Security 1.12.0.7020 (tsql)
  - JavaScript/TypeScript/CSS Code Quality and Security 10.11.1.25225 (javascript)
  - Ruby Code Quality and Security 1.15.0.4655 (ruby)
  - Vulnerability Rules for C# 10.4.0.30099 (securitycsharpfrontend)
  - Vulnerability Rules for Java 10.4.0.30099 (securityjavafrontend)
  - Vulnerability Rules for JS 10.4.0.30099 (securityjsfrontend)
  - Vulnerability Rules for Python 10.4.0.30099 (securitypythonfrontend)
  - PHP Code Quality and Security 3.33.0.11274 (php)
  - ABAP Code Quality and Security 3.14.0.5470 (abap)
  - Vulnerability Rules for PHP 10.4.0.30099 (securityphpfrontend)
Global server settings:
  - sonar.abap.file.suffixes=.abap,.ab4,.flow,.asprog
  - sonar.azureresourcemanager.file.suffixes=.bicep
  - sonar.c.file.suffixes=.c,.h
  - sonar.cfamily.gcov.reportsPath=.sonar/gcovrtest/
  - sonar.core.id=147B411E-AY35-1KwcBoCTR858oYf
  - sonar.core.startTime=2024-05-04T11:52:34+0000
  - sonar.cpp.file.suffixes=.cc,.cpp,.cxx,.c++,.hh,.hpp,.hxx,.h++,.ipp
  - sonar.cs.file.suffixes=.cs,.razor
  - sonar.css.file.suffixes=.css,.less,.scss,.sass
  - sonar.dbcleaner.branchesToKeepWhenInactive=develop,release/*,feature/*
  - sonar.docker.file.patterns=Dockerfile,*.dockerfile
  - sonar.exclusions=**/TestbenchShared/**
  - sonar.flex.file.suffixes=as
  - sonar.forceAuthentication=true
  - sonar.global.exclusions=**/samples/**
  - sonar.go.file.suffixes=.go
  - sonar.html.file.suffixes=.html,.xhtml,.cshtml,.vbhtml,.aspx,.ascx,.rhtml,.erb,.shtm,.shtml,.cmp,.twig
  - sonar.java.file.suffixes=.java,.jav
  - sonar.javascript.file.suffixes=.js,.jsx,.cjs,.mjs,.vue
  - sonar.json.file.suffixes=.json
  - sonar.jsp.file.suffixes=.jsp,.jspf,.jspx
  - sonar.kotlin.file.suffixes=.kt,.kts
  - sonar.objc.file.suffixes=.m
  - sonar.php.file.suffixes=php,php3,php4,php5,phtml,inc
  - sonar.plsql.file.suffixes=sql,pks,pkb
  - sonar.python.file.suffixes=py
  - sonar.qualityProfiles.allowDisableInheritedRules=true
  - sonar.ruby.file.suffixes=.rb
  - sonar.scala.file.suffixes=.scala
  - sonar.swift.file.suffixes=.swift
  - sonar.terraform.file.suffixes=.tf
  - sonar.tsql.file.suffixes=.tsql
  - sonar.typescript.file.suffixes=.ts,.tsx,.cts,.mts
  - sonar.vbnet.file.suffixes=.vb
  - sonar.xml.file.suffixes=.xml,.xsd,.xsl,.config
  - sonar.yaml.file.suffixes=.yaml,.yml
Project server settings:
  - sonar.abap.file.suffixes=.abap,.ab4,.flow,.asprog
  - sonar.azureresourcemanager.file.suffixes=.bicep
  - sonar.c.file.suffixes=.c,.h
  - sonar.cpp.file.suffixes=.cc,.cpp,.cxx,.c++,.hh,.hpp,.hxx,.h++,.ipp
  - sonar.cs.file.suffixes=.cs,.razor
  - sonar.css.file.suffixes=.css,.less,.scss,.sass
  - sonar.docker.file.patterns=Dockerfile,*.dockerfile
  - sonar.exclusions=**/TestbenchShared/**,**/samples/**,**/tests/**,**/utils/**
  - sonar.flex.file.suffixes=as
  - sonar.go.file.suffixes=.go
  - sonar.html.file.suffixes=.html,.xhtml,.cshtml,.vbhtml,.aspx,.ascx,.rhtml,.erb,.shtm,.shtml,.cmp,.twig
  - sonar.java.file.suffixes=.java,.jav
  - sonar.javascript.file.suffixes=.js,.jsx,.cjs,.mjs,.vue
  - sonar.json.file.suffixes=.json
  - sonar.jsp.file.suffixes=.jsp,.jspf,.jspx
  - sonar.kotlin.file.suffixes=.kt,.kts
  - sonar.objc.file.suffixes=.m
  - sonar.php.file.suffixes=php,php3,php4,php5,phtml,inc
  - sonar.plsql.file.suffixes=sql,pks,pkb
  - sonar.python.file.suffixes=py
  - sonar.ruby.file.suffixes=.rb
  - sonar.scala.file.suffixes=.scala
  - sonar.swift.file.suffixes=.swift
  - sonar.terraform.file.suffixes=.tf
  - sonar.tsql.file.suffixes=.tsql
  - sonar.typescript.file.suffixes=.ts,.tsx,.cts,.mts
  - sonar.vbnet.file.suffixes=.vb
  - sonar.xml.file.suffixes=.xml,.xsd,.xsl,.config
  - sonar.yaml.file.suffixes=.yaml,.yml
Project scanner properties:
  - sonar.cfamily.build-wrapper-output=.sonar/bw-output
  - sonar.cfamily.file.suffixes=cpp,h
  - sonar.coverageReportPaths=.sonar/gcovrtest/coverage.xml
  - sonar.exclusions=**/libtorch/**/*,**/bin/**/*,**/*.dbf,**/*.engine,**/*.java,**/*.py,**/*.sql,**/*.onnx,**/*.so*,**/*.tgz,**/*.tar.gz,**/*.dat,**/*.deb,**/*.cs,**/*.caffemodel,**/*.o,**/*.config,**/*.php,**/*.cs,**/*.html,**/*.css,**/*.ts,**/*.js,**/*.txt
  - sonar.host.url=https://sonar.robinradar.systems
  - sonar.language=c++
  - sonar.projectBaseDir=/home/jenkins/project
  - sonar.projectKey=develop
  - sonar.qualitygate.ignoreSmallChanges=False
  - sonar.scanner.apiBaseUrl=https://sonar.robinradar.systems/api/v2
  - sonar.scanner.app=ScannerCLI
  - sonar.scanner.appVersion=6.1.0.4477
  - sonar.scanner.arch=x86_64
  - sonar.scanner.bootstrapStartTime=1725408601716
  - sonar.scanner.os=linux
  - sonar.scanner.wasEngineCacheHit=false
  - sonar.sourceEncoding=UTF-8
  - sonar.token=******
  - sonar.working.directory=/home/jenkins/project/.scannerwork

Hi,

SONAR-21655 was fixed in SonarQube v10.4.1.

Your version is past EOL. You should upgrade to either the latest version or the current LTA (long-term active version) at your earliest convenience. Your upgrade path is:

10.4 → 10.6

Hi Colin,

Thank you for your response. I will let you know when I’ve been able to perform the upgrade and test this fix.

1 Like