SonarQube Community EditionVersion 7.7 (build 23042)

Hi,
We recently upgrade SonarQube to Community Edition Version 7.7 (build 23042). After the upgrade, we noticed everyday at around 1:30am, there was alert on DB, and the undo tablespace usage for the database being fully consumed.

Here is the query that we noticed during the tablespace spike
update live_measures set
value = :1 ,
variation = :2 ,
text_value = :3 ,
measure_data = :4 ,
updated_at = :5
where
component_uuid = :6
and metric_id = :7

Did anyone face the similar issue? thanks!

Hi,

Do you have any large analyses running at that time?

 
Ann

Hi G Ann,
Could you advise how I can I check if any large analysis is running? Thanks!

Hi,

They would show up in your global background tasks log (Administration > Projects > Background Tasks). You can see there when each job was submitted, started, and finished.

 
Ann

Hi Ann,
Ok, I was checking this previously. From what I see, there is no big analysis was running. For this few days, there is no more alert on the undospace. We will keep an eye on this, thanks for getting back.