How to debug when server is unresponsive

I’ve been getting notifications that my server goes down for a few minutes from uptime robot. When this happens, it looks like the metrics section of the app in the control panel shows blanks for the time it was down. Therefore I can’t really debug what the error was. How can I better debug what is causing my app to go down?
Thanks

Also, is there a way to log SQL queries that are taking too long:
http://www.heatware.net/databases/how-to-find-log-slow-queries-postgresql/

Since we don’t have access to the .conf file

Hey Waleed,

I’ve been getting notifications that my server goes down for a few minutes from uptime robot. When this happens, it looks like the metrics section of the app in the control panel shows blanks for the time it was down.

This is likely to be caused by the instance hosting the app running out of memory and thrashing for a while while it tries to free up some. The solution would be to enable memory management on your infrastructure.

I can double-check that this is indeed the cause, but I’d need to know which app we’re talking about. Feel free to open a support ticket about this.

Also, is there a way to log SQL queries that are taking too long:

Not yet, but this is a feature we’re planning to work on soon!

Cheers,

1 Like