15th May 2020, 2:44 PM
-- Note to self. Technical things below. --
The database connection times out if it's kept open for too long with no activity (I believe), which causes the server to crash. An example of this is PR2 Staff crashing as soon as I log out after no one has logged in for a while.
The connection is set to renew daily, but I'm wondering if it should be done more often? Maybe hourly? That would be a nice start to debugging this really obscure anomaly. The other option is to create a function to perform DB calls, and if a call fails then attempt to reconnect before crashing the entire server. That's probably the better option.
The database connection times out if it's kept open for too long with no activity (I believe), which causes the server to crash. An example of this is PR2 Staff crashing as soon as I log out after no one has logged in for a while.
The connection is set to renew daily, but I'm wondering if it should be done more often? Maybe hourly? That would be a nice start to debugging this really obscure anomaly. The other option is to create a function to perform DB calls, and if a call fails then attempt to reconnect before crashing the entire server. That's probably the better option.