I have a flask application interfaced with a postgres db on fly. Very small application, with 1 instance each on the flask app and postgres.
I haven’t done any updates on the application or db in a few weeks, but all of a sudden i’ve noticed the flask application is failing to connect to the database the errors:
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] File "/layers/paketo-buildpacks_pip-install/packages/lib/python3.12/site-packages/psycopg2/__init__.py", line 122, in connect
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "postgres-db-hostname" (ipv6 address), port 5432 failed: SSL SYSCALL error: Success
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] connection to server at "postgres-db-hostname/ipv6", port 5432 failed: server closed the connection unexpectedly
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] This probably means the server terminated abnormally
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] before or while processing the request.
2024-10-17T02:28:51.726 app[4d891deec6e068] yyz [info] (Background on this error at: https://sqlalche.me/e/20/e3q8)
I’ve ran the application locally with a fly proxy to the database and that seems to be running fine.
I’m wondering if this is environmental and if so how can i overcome this. It seems the connection is being refused by the postgres instance repeatedly.