SonarQube - Project Reload Data and Project Analysis Cancellations and Failures

  • What version are you upgrading from? 8.9 LTS
  • System information (Operating system, Java version, Database provider/version) RHEL 7, Java 11, MSSQL
  • What’s the issue you’re facing? Project Reload Data and Project Analysis cancellations and failures.

While I can’t add anymore information because company rules and regulations. And we are getting behind the scenes help from Sonar Support. I wanted to reach out to the community and see if this has also happen to any of you and how you went about solving your problem.

We are currently upgrading from SonarQube 8.9 LTS to SonarQube 9.9 LTS. Our dev instance was fine upgraded with no problems but because prod is prod we are having problems. We are experiencing project data reload and project analysis problems. Now while the majority of our projects are getting indexed we still have over 300 projects not doing so. This leads to projects appearing grayed out and other functionality not being available.

We have checked our logs and we are getting two things it looks like.

  • Duplicate Key Errors

  • Task ID not found

Has this happen to any of you? And if so how did you go about solving it? I do realize that your solution(s) might not work for us but it would be interesting to know.

Thank you in advance!

Hey there.

It sounds like you might accidentally have two SonarQUbe instances connected to the same database. This is not supported outside of Data Center Edition.

You should be able to monitor active connections.