SonarQube publishing task is timingout/taking too long to report findings back to Azure DevOps

SonarQube Server / Community Build
, , ,
4

Hey there.

Drat, I was hoping that you’d say Postgres! Because usually, the fix is pretty easy..

A few more questions:

  • Is this the only project affected? Or do background tasks take a long time in general? You can check the global Administration > Projects > Background Tasks
  • is is_read_committed_snapshot_on set to true?
  • How closely located is your SonarQube server to the SQL server? Any lag or latency can have a dramatic impact here.
  • Asking your DBAs to refresh the indexes and statistics of your SonarQube database can help with performance if for some reason they have grown stale