calgo-lab / green-db

The monorepo that powers the GreenDB.
https://calgo-lab.github.io/green-db/
22 stars 2 forks source link

psycopg connection error in workers after restart of postgres #146

Open BigDatalex opened 1 year ago

BigDatalex commented 1 year ago

If the database is restarted/redeployed the db connection established by the workers gets terminated. This results in failed worker jobs, as they can no longer write to the database. So it seems there is no logic implemented for doing a reconnect. It needs to be investigated further.

The manual fix is just to restart the workers.