App suddenly cannot connect to postgres db

Hi, my django web app seems to not be able to connect to postgres anymore. Earlier this week it was fine but recently when going to my web url…it is giving me a 500 error. I did not make any changes to the codebase / infrastructure this week.

django error:
django.db.utils.OperationalError: could not translate host name “top2.nearest.of.mtdb-db.internal” to address: No address associated with hostname

Looking at flyctl postgres list
the db seems to be suspended?

Also when trying flyctl postgres restart
I get the message Error no active leader found

flyctl status -a mtdb-db

ID              STATE           ROLE    REGION  HEALTH CHECKS   IMAGE                           CREATED                UPDATED
6e82575fe17387  starting        error   ord     3 total         flyio/postgres:14.4 (v0.0.32)   2022-10-30T20:01:14Z   2022-11-27T08:24:03Z

flyctl checks list -a mtdb-db

  NAME | STATUS  | MACHINE        | LAST UPDATED | OUTPUT
-------*---------*----------------*--------------*--------------------------
  pg   | warning | 6e82575fe17387 | 0s           | the machine is starting
-------*---------*----------------*--------------*--------------------------
  role | warning | 6e82575fe17387 | 0s           | the machine is starting
-------*---------*----------------*--------------*--------------------------
  vm   | warning | 6e82575fe17387 | 0s           | the machine is starting
-------*---------*----------------*--------------*--------------------------

It seems be stuck in the ‘machine is starting’ phase

Any help would be appreciated.
Thanks!

1 Like

I have this exact issue with a Rails app. I’m not able to find any help on how to resolve it.