Reports not loading after PostgreSQL version upgrade

Felix · October 17, 2022, 3:03pm

Hello All,

We have encountered an issue after we upgraded PostgreSQL form 10 to 13.4. All reports are not loading even though PostGreSQL 13 version is compatible with Sonarqube version 9.4 that we are running and up. When we restored the database back to version 10, all the reports are loading. Is there a way to fix this issue as AWS RDS postGreSQL 10 is at EOC.

Thanks

Felix

ganncamp · October 18, 2022, 3:50pm

Hi Felix,

Could you clarify what you mean by this? Is it that the numbers don’t show up in the UI?

And is there anything interesting in your server logs?

Ann

Felix · October 18, 2022, 5:37pm

Hello Ann,

The numbers do not show up in the UI. I have attached two screen shots.

Felix

ganncamp · October 18, 2022, 5:45pm

Hi,

Thanks for the clarification. Can you re-generate your Elastisearch indices by:

stop server
delete `$SONARQUBE-HOME/data/es7
restart server

This will force your indices to be rebuilt. The time this takes varies by instance size, so if you have a large instance, you might want to kick it off in the evening.

Ann

Felix · October 18, 2022, 8:25pm

Hello Ann,

I perform the steps but the issue was not resolved
sonar.20221018.log (3.7 KB)

Felix

ganncamp · October 19, 2022, 11:09am

Hi Felix,

Anything interesting in your other server logs?

Ann

Felix · October 19, 2022, 2:23pm

access.log (55.1 KB)
web.log (44.2 KB)
ce.log (491.8 KB)

ganncamp · October 19, 2022, 3:02pm

Hi,

Was there an es.log?

Do you see anything in your browser console?

Ann

Felix · October 19, 2022, 3:30pm

Hello Ann,

I do see Failed to load resource: the server responded with a status of 404 ()

es.log (8.5 KB)

ganncamp · October 19, 2022, 3:44pm

Hi,

And then it responded with two 504s, which are “Gateway Timeout” errors. Since your server logs look fine, can you double-check this with your network folks?

Ann