Sonarqube Database Migration

[Joao_Escusa (João Escusa)]

Hello everyone.

I have been trying to migrate a Sonarqube database from a Kubernetes Cluster to an RDS/other cluster.
I have done a dump and applied said dump on a fresh Postgres environment.

All Postgres have the same version (13.2) and the same applies to Sonarqube, same version across different platforms.

Every time the dump was applied the following error occurred and once Sonarqube was started it always failed and crashed

Persistent files from the original environment were copied to the respective directories in the secondary environments.

I am not versed in database administration.
Is the error above the probable cause of failure? Is there a simple way to correct it and test?

Thank you for your help.

[ganncamp (G Ann Campbell)]

Hi,

Welcome to the community!

Unfortunately, I’m afraid this topic is really outside the scope of this community. Looking at your error message, I’m quite confident there aren’t any columns in the sonar schema with that name. It appears that your DB dump is corrupted at some point in the process.

 

Ann

[Joao_Escusa (João Escusa)]

Hello Ann.

That’s what I figured but I thought it would still be worth a shot.

Thank you for your time.