Unable to scan after upgrading postgresSql engine version only

[Colin]

Hey there.

When upgrading – pay attention to this guide:

SonarQube becomes slow after PostgreSQL upgrade

Hello SonarQube Operators! It’s common that after performing an upgrade of PostgreSQL, a SonarQube instance connected to a PostgreSQL database can become painfully slow. Thankfully, we know how the issue can usually be addressed (it works almost every time!): by executing the following command against your Postgres database. VACUUM FULL ANALYZE For a PostgreSQL database, a VACUUM FULL command reclaims unused storage, while the ANALYZE command updates statistics used by the planner to determi…

@jeverakes

After restoring the old database, i can successfully scan still, but i still get a 404 on the cache, however it is able to load the projects.

This is fine and expected in certain contexts. The information is only available at DEBUG level. You can safely ignore it.