SonarQube Version 8.9.0.43852
Official Docker container sonarqube:lts-community
PostgreSQL 10 (AWS Aurora PostgreSQL)
The issue:
SonarQube makes connection to database server every 2 seconds submitting following queries:
select cq.uuid
from
ce_queue cq
where
cq.status='PENDING'
and cq.started_at is null
and cq.task_type <> 'ISSUE_SYNC'
and not exists (
select
1
from
ce_queue cq2
where
cq.main_component_uuid=cq2.main_component_uuid
and cq2.status <> 'PENDING'
)
order by
cq.created_at asc,
cq.uuid asc
and
select cq.uuid
from
ce_queue cq
left join components c on c.uuid = cq.main_component_uuid and c.qualifier <> 'VW'
where
cq.status='PENDING'
and cq.started_at is null
and not exists (
select
1
from
ce_queue cq2
where
cq.main_component_uuid=cq2.main_component_uuid
and cq2.status <> 'PENDING'
)
order by
cq.created_at asc,
cq.uuid asc
I am guessing those are to check for pending analyses. However, this results in constant activity on database server. We use Serverless Aurora and run code analysis once a week, and we would like our Aurora PostgreSQL pause when it is not used. This (pause) happens after 5 min of no activity, but since SonarQube makes above queries every 2 seconds, pause never happens and we incur AWS costs.
Can above checks frequency be configurable, please?
Or is there a way to make them less frequent? Like once a day?
Thanks!