Error after backup and restore DB

Custom Deployment
1

I did the backup and restore following the guide Developer Guide: Useful commands and queries · openremote/openremote Wiki · GitHub
But then the manager was unable to work, the log showed the following error:

Screenshot 2023-07-05 150334
Screenshot 2023-07-05 1503341899×469 51.3 KB

I have checked very carefully the commands according to the instructions and refer to the articles below but still can’t fix it, someone help me! Thanks a lot!
OR platform DB backup and restore - Custom Deployment - OpenRemote
DB Backup and restore issue - Custom Deployment - OpenRemote

2

Anyone help me please :frowning:

3

Don’t exactly know how you did the migration,
is it on the same system or on a different one?

Trying to get an idea of where this is coming from…

Were the keycloak and manager instances turned off during the restore process?
Did you specify the correct passwords in the docker-compose files?
Are you using the same version as the server you did the backup on, or have you upgraded?

1 Like
4

Don’t exactly know how you did the migration, is it on the sameme system or on a different one?

  • I have a server running, and I want to migrate data to a new server without interrupting the old server.

Were the keycloak and manager instances turned off during the restore process?

  • Yes, both were stopped before proceeding.

Did you specify the correct passwords in the docker-compose files?

  • The docker-compose file used is the same (only the domain name is different).

Are you using the same version as the server you did the backup on, or have you upgraded?

  • I don’t know, the old server was deployed about a month ago. The docker-compose file used is the same (only the domain name is different). I don’t know if the containers in this new deployment will be upgraded.
5

Don’t remember any breaking database changes in the last month.
In that case a OR version mismatch wouldn’t be the cause.

Maybe @Rich can help here since he’s more experienced with migrations.
I don’t want to make wrong assumptions here :sweat_smile:

1 Like
6

Thank you for trying to help, I will wait for another help