No more data to read from socket error
来源:互联网 发布:双拼com域名价格 编辑:程序博客网 时间:2024/06/04 18:47
转载自:http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error.
Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1142) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1869) at org.hibernate.loader.Loader.doQuery(Loader.java:718) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 63 more
We use spring, hibernate and i have the following for the datasource in my applciation context file.
<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource"> <property name="driverClassName" value="${database.driverClassName}" /> <property name="url" value="${database.url}" /> <property name="username" value="${database.username}" /> <property name="password" value="${database.password}" /> <property name="defaultAutoCommit" value="false" /> <property name="initialSize" value="10" /> <property name="maxActive" value="30" /> <property name="validationQuery" value="select 1 from dual" /> <property name="testOnBorrow" value="true" /> <property name="testOnReturn" value="true" /> <property name="poolPreparedStatements" value="true" /> <property name="removeAbandoned" value="true" /> <property name="logAbandoned" value="true" /> </bean>
I am not sure whether this is because of application errors, database errors or network errors.
We see the following on the oracle logs
Thu Oct 20 10:29:44 2011Errors in file d:\oracle\diag\rdbms\ads\ads\trace\ads_ora_3836.trc (incident=31653):ORA-03137: TTC protocol internal error : [12333] [4] [195] [3] [] [] [] []Incident details in: d:\oracle\diag\rdbms\ads\ads\incident\incdir_31653\ads_ora_3836_i31653.trcThu Oct 20 10:29:45 2011Trace dumping is performing id=[cdmp_20111020102945]Thu Oct 20 10:29:49 2011Sweep [inc][31653]: completedSweep [inc2][31653]: completedThu Oct 20 10:34:20 2011Errors in file d:\oracle\diag\rdbms\ads\ads\trace\ads_ora_860.trc (incident=31645):ORA-03137: TTC protocol internal error : [12333] [4] [195] [3] [] [] [] []Incident details in: d:\oracle\diag\rdbms\ads\ads\incident\incdir_31645\ads_ora_860_i31645.trcThu Oct 20 10:34:21 2011
For errors like this you should involve oracle support. Unfortunately you do not mention what oracle release you are using. The error can be related to optimizer bind peeking. Depending on the oracle version different workarounds apply.
You have two ways to address this:
- upgrade to 11.2
- set oracle parameter “_optim_peek_user_binds”=false
Of course underscore parameters should only be set if advised by oracle support
Try two things:
- Set in $ORACLE_HOME/network/admin/tnsnames.ora on the oracle server server=dedicated to server=shared to allow more than one connection at a time. Restart oracle.
- If you are using Java this might help you: In
java/jdk1.6.0_31/jre/lib/security/Java.security
changesecurerandom.source=file:/dev/urandom
tosecurerandom.source=file:///dev/urandom
- No more data to read from socket error
- No more data to read from socket问题
- (精)java.sql.SQLException: No more data to read from socket
- ST测试时操作量过大出现java.sql.SQLException: No more data to read from socket异常
- 拣点芝麻:dbcp (Oracle)重新链接的问题 - Cause: java.sql.SQLException: No more data to read from socket
- [ERROR]-Error: failure: repodata/filelists.xml.gz from addons: [Errno 256] No more mirrors to try.
- <BEA-000449><Closing socket as no data read from it on timeout of 5 secs>问题
- Error: failure: repodata/filelists.sqlite.bz2 from updates: [Errno 256] No more mirrors to try.
- Error: failure: repodata/filelists.sqlite.bz2 from base: [Errno 256] No more mirrors to try.
- [linux]Error: failure: repodata/repomd.xml from fedora: [Errno 256] No more mirrors to try.
- [linux]Error: failure: repodata/repomd.xml from fedora: [Errno 256] No more mirrors to try.
- Unable to read additional data from client sessionid 0x0, likely client has closed socket
- Use pandas to read data from files
- Citrix XEN VM Boot Error code: INVALID_SOURCE Unable to Boot from CD/DVD Read more: http://eitwebgu
- Solution for<Closing socket as no data read from it on during the configured idle timeout of 5 secs
- How-to read data from selected tree node
- How to read binary data from HDFS with Thrift?
- CE Unable to read data from the transport connection.
- SQLite Cursor
- Android ListView 使用checkbox 实现 单选、多选操作
- hdu1257(最少拦截系统 )
- FTP客户端
- windows系统自带压缩解压命令
- No more data to read from socket error
- PHP设计模式-单例模式
- 【js学习笔记-023】-- 变量声明
- css3代码生成器
- Activity的创建和使用
- vi编辑器使用讲解(转)
- [精华] 跟我一起写 Makefile
- Java修改Access数据库,无需添加数据源。
- Mac操作技巧