We use Oracle DB as our data store. The DB is offered by another service internally. So we do not have control over its operations. In one of our calls to the DB, we are seeing "Internal Exception: java.sql.SQLRecoverableException: No more data to read from socket Error Code: 17410" error while trying to execute an SQL statement. Similar questions were asked before but the situation in my case is different No more data to read from socket error
org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: java.sql.SQLRecoverableException: No more data to read from socket
Error Code: 17410
Call: SELECT ID, KEYS, REQ, TOKEN, TIME_OF_CREATION FROM LOG WHERE (((ID = ?) AND (RETRY_TOKEN = ?)) AND (TIME_CREATED >= ?))
bind => [abcd1.saml2ip.ol1..aaabgtyazrfgjbdfdgyhiijjn556ggvjn/4288807, 612345-9o87-5556-t567-g6yu789i128, 2022-04-27 13:09:08.597]
Query: ReadAllQuery(referenceClass=RetryLog sql="SELECT ID, KEYS, REQ, TOKEN, TIME_OF_CREATION FROM LOG WHERE (((ID = ?) AND (TOKEN = ?)) AND (TIME_OF_CREATION >= ?))")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1650)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:683)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2096)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:332)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:728)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2773)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2726)
When I tried to reproduce the same error locally by bringing up an Oracle DB, I am not seeing the same error. How can I fix this ?
