StoRM connection pool doesn't seem to test connection health.
This causes several issues, for instance StoRM connections does not survive a MySQL restart.
From QMUL log:
04:16:44.084 - ERROR [qtp1991929472-36] - SQLException: The last packet successfully received from the server was 55,700,975 milliseconds ago. The last packet sent successfully to the server was 55,701,174 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem./nSQLState: 08S01/nVendorError: 0
- relates to
-
STOR-1333 Ensure Database connection pool tests connections on borrow and while ldle
-
- Closed
-