Anyone else having similar issues? I have made no changes ot my app but suddenly i cant connect to postgres from the app.
PG::ConnectionBad: connection to server at “fdaa:3:711f:0:1::8”, port 5432 failed: server closed the connection unexpectedly (PG::ConnectionBad)
This probably means the server terminated abnormally
before or while processing the request.
I’ve never seen this before.
I’ve tried: rebooting instances, destroying machines and re-creating them, deploying the app.
I am seeing the same thing, both my apps are having issues connecting to the respective Postgres DBs i.e. I am seeing Postgrex.Protocol (#PID<0.2231.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
Seems like one of them will connect off and on. Maybe a fly thing?
Same issue here I think, my app suddenly cannot find my Postgres instance when it was working fine before. I tried destroying my app and scaling back up but it fails to connect everytime.
Can you reach the db through a wireshark tunnel? I could the entire time which is the only reason i knew the db was fine. I’d check that to rule out any other issues.
Hi, same here across 4 apps, they all started throwing the same error. It seems it’s only affecting apps in my personal organization, I have two apps in outside organizations and they’re fine.
I was suffering from the same issue, the way i resolved it was i rollbacked my postgres instance to a snapshot before the latest snapshot. The new instance from the snapshot didn’t suffer from the same issue. I’m going to assume the daily snapshot was the issue ?
I can confirm this solution worked - I created a new secret “DATABASE_URL_ALT” which replaces “.flycast” with “.internal” and updated my app to use this new var
I am running pretty old versions of flyio/postgres-flex (0.0.39) and haven’t touched the databases forever. Fortunately one instance of my app remained able to connect to the .flycast url, but no other instances or new machines could