Getting MySQL Error All of Sudden (Caused by java.sql.SQLNonTransientConnectionException)
Summary:
Error message: -
Caused by java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed..
Content (required):
Hi Team,
I'm using MySQL Database Service on OCI and installed OIC Connectivity Agent in the MySQL VM (Compute Instance).
It was working fine until today morning, I'm getting below errors: -
PURE SQL:-
<err:serviceInvocationError
xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault">
<err:type>Pure SQL Exception</err:type><err:title>Pure SQL
Execute of select count(*) cnt from [table] WHERE
[few conditions].</err:title>
<err:detail>Caused by java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed..</err:detail>
<err:errorCode>serviceInvocationError</err:errorCode>