I have backed up the hammerhead database and restored it to our dedicated postgress database server and entered the connection details into the docker.env file. Upon starting the docker containers again the jobs-runner, workflows_worker and temportal containers do not start up. As per the screenshot below. If i change the database details back to the original all works as it should. We have performed a database migration previously on a different older version of a retool instance which worked without issue. The only difference i can see between our older retool migration and this new one is the postgress port number is different (which i changed in the docker.env file).
Any suggestions what is causing this issue?
Apologies for this odd issue. It sounds like you followed all the right steps
My first thought it that the failing containers have a dependency on another crashing container.
To better assist with troubleshooting the containers crashing, could you share the docker configs?
If you can exec into these containers and see if they provide a more verbose error message to help us pinpoint what error they are running into on launch.
The only other possibility that jumped to the top of mind on trouble shooting this is that maybe part of the connection string to the new DB is missing?
It sounds like you set up everything according to our docs and similar enough to how you set it up the last time. But if you are able to switch back to the old DB and it works but switching to the new DB fails then maybe try testing out the connection string to the DB on a running Retool instance via a Resource to confirm the connection can work.
