Increase DB size

SonarQube Server / Community Build
,
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube Server / Community Build, Scanner, Plugin, and any relevant extension): v2025.1.o
  • how is SonarQube deployed: zip, Docker, Helm: Docket
  • what are you trying to achieve: Currently users are facing timeout issues in Sonar, can you please confirm if we can increase DB size from 450 GB to bigger size
2

Currently we are using 2cpu/4 gb of memory
Mostly its reading from data file and causing this issue and please confirm if we can increase the DB size from Sonar end.

It’s issue with below query highly consuming “EBSByteBalance%” which is data-file reads:
“SELECT p.kee, p.uuid FROM components p INNER JOIN components root ON root.uuid=p.branch_uuid AND root.kee=$1 LEFT JOIN project_branches pb ON pb.uuid = root.uuid WHERE (pb.is_main = true OR (pb.uuid is NULL AND (p.qualifier IN (‘VW’, ‘SVW’) OR (p.qualifier = ‘TRK’ AND p.scope = ‘FIL’))))”

3

Hi,

Your DBA should be the ultimate arbiter of how to manage your database. From a SonarQube standpoint, I don’t see a problem with increasing the size. And if your web users are waiting, I would look at the resources holistically:

  • Does the web process (which serves user requests) have enough resources?*
  • Does the Elasticsearch process (which you allude to with you mention of “data-file” have enough resources?*
  • Is the SonarQube instance “close” to the DB on the network to reduce latency?
  • …

 
Ann

* See the SONAR_*_JAVAOPTS properties

4

There is a deprecation log in the application with deprecated componentKeys and projectKey parameter warnings. These warnings seem to be linked to a highly resource-consuming query below. please check if this issue is related.

“SELECT p.kee, p.uuid FROM components p INNER JOIN components root ON root.uuid=p.branch_uuid AND root.kee=$1 LEFT JOIN project_branches pb ON pb.uuid = root.uuid WHERE (pb.is_main = true OR (pb.uuid is NULL AND (p.qualifier IN (‘VW’, ‘SVW’) OR (p.qualifier = ‘TRK’ AND p.scope = ‘FIL’))))”

Can you please confirm if the timeout issue is because o this ^^

5

Hi,

Let’s back up. What’s timing out? And can you provide the full log, redacted as necessary, where you’re seeing that query?

 
Thx,
Ann