Sonarqube Postgres throwing error ""project_uuid" does not exist"

[sameer_khamkar (SAM)]

Hello There,

We have upgraded SQ from 9.6.0 to 9.4.4 with Postgres 11, Sonarqube is working fine but we are seeing below errors in Sonarqube Postgres,

ERROR: column “project_uuid” does not exist at character 133
2024-05-22 09:30:01.904 CEST [4847] STATEMENT: SELECT component_uuid, count(component_uuid) as total, name FROM ce_activity inner JOIN components on ce_activity.component_uuid=project_uuid WHERE module_uuid is NULL GROUP BY (component_uuid,name)

can you please guide what these errors are coming for and how we can resolve this.

Regards,
SAM

[Colin]

Hey there.

Is it possible that another instance of SonarQube is still connected to this database?

[Solved] Error message in PostgreSQL logs for missing column id in projects table

Finally, an old Sonarqube (version 7.6) was running on another server but connected to the same database. The error message was from this instance. Thanks for your help.

How to list active connections on PostgreSQL?

[sameer_khamkar (SAM)]

Thank you Colin, let me confirm that