How can we debug why our web application is misbehaving?

Hi there,
Our platform is currently down and we’re unable to access it. Could you please check what’s happening and let us know how and when this issue will be resolved?

Thank you for your help!

Best,
Aline

Hi… Sorry to hear you’ve been having trouble… This is the community forum, so you will generally get the most help if you can say more about what your application is, what the exact problem you’re encountering looks like, etc. For example, do you get a 502 response when trying to connect to app-name.fly.dev via a browser? Or you can’t log in to fly.io/dashboard at all?

(Conversely, if you have a Support Plan, then it’s best to file a ticket through the dashboard or email, since that way it’s officially lodged in their tracking/queue, etc.)

[In my opinion, as soon as there’s a “we” involved, then you do want at least the basic support package.]

1 Like

We have a course platform, but the dashboard doesn’t load information, it’s very slow, and it doesn’t display registered students.

We don’t offer email support.

Try looking through fly logs as a first step. Often there would be complaints about failed database queries, or the like. (Also fly logs -a db-app-name if you have a Legacy Postgres database; substitute its actual name for db-app-name—it’s distinct from your main app.)

I meant a Fly.io support plan, :sweat_smile:. I.e., it’s a way for you to get “can you check this” kind of support:

https://fly.io/support

Oh, hahaha, sorry. I got confused, haha.

Ok, I’ll try to do that. Thanks

1 Like

@thayrck I checked and your Postgres cluster seems to be malfunctioning, your machines have some errors (check them with fly checks list).

You can try recovering the cluster as-is, but I would also recommend trying to get a database dump out of the machines, with this you could create a new cluster and load your data in it, if the old cluster turns out to be unsalvageable.

For example, fly ssh console -a your-database-app and then once in a shell, run this to connect to Postgres locally and get a dump of the my_app database:

su - postgres -c "pg_dump -h /run/postgresql/ -p 5433 -d my_app" > my_app.sql

Then you can fly ssh sftp get the sql file out of the machine.

  • Daniel
1 Like

I’d say that if you’re running unmanaged Postgres and you’re not actually an experienced DBA, switch to MPG or a third-party service (RDS, Supabase, etc) as soon as you can. It really isn’t worth the hassle fighting with time-consuming DBA tasks if you’ve got an enterprise to run.

1 Like