No more data to read from socket
Getting this exception intermittently while connecting to an external DB. (via a SQL to get data).
ERROR LOG:
"SQL: <QUERY HERE>
SQL Inserts:
Caused by SQL Problems.
Problem #1, SQLState 08000, Error code 17410: java.sql.SQLRecoverableException: No more data to read from socket"
Any thoughts on what this is and how to avoid it?
Appreicate your repsonses.
-Chaithu
CAP GEMINI
US
We are using oracle DB. Pega 716.
It is a simple read query.
SELECT TRANSACTIONID AS "TransactionId" , PROCESS_STATUS AS "Process_Status" , STARTDATETIME AS "StartDateTime" , PYLABEL AS "pyLabel" from TABLENAME WHERE ( TRANSACTIONID = ? )
Exception:
Not returning connection 176 for database "pegadata" to the pool as it previously encountered the following error
User ID: (unknown)
<QUERY>
We are using oracle DB. Pega 716.
It is a simple read query.
SELECT TRANSACTIONID AS "TransactionId" , PROCESS_STATUS AS "Process_Status" , STARTDATETIME AS "StartDateTime" , PYLABEL AS "pyLabel" from TABLENAME WHERE ( TRANSACTIONID = ? )
Exception:
Not returning connection 176 for database "pegadata" to the pool as it previously encountered the following error
User ID: (unknown)
<QUERY>
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:449)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1104)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
Pegasystems Inc.
IN
The "no more data from socket" error is sometimes caused by a bug and it is related to the client software (JDBC driver) and not a database problem. The no more data from socket error can also mean that the shadow process crashed, often with an ORA-00600 or ORA-07445 error. Also upgrade to the latest release of the JDBC driver.
I am not a expert with Database.But the below suggestion was suggested in the link ( http://www.dba-oracle.com/t_sqlexception_17410_no_more_data.htm)
In Oracle 11gR1 this "no data from socket" is a hidden parameter issue with bind variable peeking, and you should make this change after contacting Oracle technical support:
alter system set "_optim_peek_user_binds"=false scope=both;
Also, refer the link --> http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error