App suddenly cannot connect to postgres db

Questions / Help
1

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
2

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