Need a more robust database access
Brought to you by:
amitchatterjee,
beckymc
There is a rare issue in production: all will run well until one day, if an operator attempts to login, s/he gets the "Connecting" popup, but nothing happens after that. After a minute or two, the "Server Disconnected" popup comes up. No logs come out on the server indicating the connection issue. It happens for any operator/group. It seems that the database connection is hung. We need to make the database access more robust and also use a connection pool instead of a single dedicated connection.