Upgrading postgres version 9.5.16 to 9.6.18 version getting CPU hits 100%

[koteswar_reddy]

• Sonar versions used (SonarQube 7.9.3) and DB is 9.6.18 ,
  we tried to upgrade AWS RDS postgras engine version from 09.5 to 9.6 after that the sonarqube is not loading and I tried to run some queries and geeting some long run queries.
  How do we resolve this issue in sonar
• error observed (we observed few queries on db , please see attached screenshots )
• steps to reproduce blog:
  
  
  

P.S.: use the #bug:fault sub-category if you’re hitting a specific crash/error , or the #bug:fp sub-category for rules-related behaviour

[ganncamp (G Ann Campbell)]

Hi,

Welcome to the community!

There are some DB maintenance steps that we recommend after upgrading your SonarQube version. At a guess, they may be helpful here too.

 
Ann

[koteswar_reddy]

HI @ganncamp ,
Thanks for looking into this issue.
I didn’t upgrade sonarqube version,i tried to upgrade the database(postgres) version from 9.5 to 9.6
after that i removed the complete es6 folded and tried to index again, indexing is complete .but still sonarqube is not loaded .in that UI showing the massage loading.and DB CPU hits 100% ,I’m using 64GB Ram and 4cpus.

[pierreguillot]

Hi, the VACUUM FULL recommendation does hold for PostgreSQL version upgrade as well.

[pierreguillot]

PS: related discussion Sonarqube analysis taking 1+hr after DB upgrade to postgres10

[koteswar_reddy]

HI @pierreguillot ,
I started VACUUM FULL ANALYZE. it’s started 6hous ago, but still not completed.
may I know how much time it will take?

Thanks,
Koteswara

[pierreguillot]

Hi, I can’t say, it’s PostgreSQL specific commands. But basically, it’s re-writing your all database, table by table, to benefits from sequential reads from your disk. So it very much depends on your disk speed, and database size.

[koteswar_reddy]

Thank you @pierreguillot
VACUUM FULL is resolved my Sonarqube issue.