Hi guys.
Must-share information (formatted with Markdown):
- which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
■EC2
・JDK 11
・SonarQube 7.9.5
・EC2 instance m5.large
■RDS
・RDS Postgresql db.m5.large
・RDS Postgresql 10.5
- what are you trying to achieve
⇛ I’m trying to update my SonarQube which I actually already did but Sonar’s Project page take about 1 minute to show up and the issues pages just never show up.
It seems that issues pages is loading forever, stucked loading.
At this point: SonarQube v6.7.6 ⇛ v6.7.6
I can access any pages with no problem.
After update v6.7.7 ⇛ v7.9.5, after click the migrate database button, it took 4.5 hours and when it finished, I upgrade my RDS Postgresql v9.6 ⇛ v10.15.
After that, the project’s pages become too slow and issues pages just stuck loading and any issues show up.
I look into my database and I could see that the issues were still there.
sonardb=> select count(*) from issues;
count
548987
(1 line)
sonardb=> select count(*) from issue_changes;
count
1598
- what have you tried so far to achieve this
(1 line)
And I checked the used of RDS Postgresql on AWS RDS, and it appears that CPU is 99% used.
Any help is really welcome!
Thank you in advance!