Postgres Database - Fly.io Pushed a release and now my database is pending?

Hi All,

I am hosting a postgres database on fly io and everything was going perfect until recently.

For some reason, the database is showing at “pending” on the fly.io dashboard and “fly.io” pushed a release 14 days ago. (I’m sure Fly.io notified us of something and I just missed it - after further testing, I realized anything from the fly cli shows up as from “Fly.io”)

Screenshot 2022-12-04 at 12.05.11 PM

I can’t push a new release of my app, because when using the github CI/CD it can not connect to the database, but I can connect to it by using the proxy command from the fly cli.

17:00:11.676 [error] Postgrex.Protocol (#PID<0.136.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (top2.nearest.of.app_name-db.internal:5432): non-existing domain - :nxdomain

I do see a message saying an IP is not associated with my database server on the Fly Dashboard.

Screenshot 2022-12-04 at 12.08.40 PM

And I see these errors on my database server

 2022-12-04T17:43:26.970 app[f7c58ef5] ewr [info] Starting init (commit: f447594)...

2022-12-04T17:43:26.990 app[f7c58ef5] ewr [info] Mounting /dev/vdc at /data w/ uid: 0, gid: 0 and chmod 0755

2022-12-04T17:43:26.994 app[f7c58ef5] ewr [info] could not resize filesystem to fill device size: Operation not permitted (os error 1)

2022-12-04T17:43:26.995 app[f7c58ef5] ewr [info] Preparing to run: `docker-entrypoint.sh start` as root

2022-12-04T17:43:27.005 runner[f7c58ef5] ewr [info] Virtual machine started successfully

2022-12-04T17:43:27.011 app[f7c58ef5] ewr [info] 2022/12/04 17:43:27 listening on [fdaa:0:58e0:a7b:ab2:1:353e:2]:22 (DNS: [fdaa::3]:53)

2022-12-04T17:43:27.055 app[f7c58ef5] ewr [info] [ 0.163848] EXT4-fs error (device vdc): ext4_validate_block_bitmap:390: comm start: bg 0: bad block bitmap checksum

2022-12-04T17:43:27.072 app[f7c58ef5] ewr [info] [ 0.180424] EXT4-fs error (device vdc): ext4_lookup:1709: inode #8193: comm chown: deleted inode referenced: 1433