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 Settings → Background 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