很急手 Io 异常: End of TNS data channel

Question

请各高手帮忙 服务不定时的老挂，重启就好了。
Io 异常: End of TNS data channel
15:07:25,109 ERROR [STDERR] java.sql.SQLException: Io 异常: End of TNS data channel
15:07:25,109 ERROR [STDERR]     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
15:07:25,109 ERROR [STDERR]     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
15:07:25,109 ERROR [STDERR]     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
15:07:25,109 ERROR [STDERR]     at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1224)
15:07:25,109 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManage
dConnection.java:429)
15:07:25,109 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:525)
15:07:25,109 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:155)
15:07:25,109 ERROR [STDERR]     at com.ddtech.bdingonline.listener.ReplyTask.run(ReplyTask.java:30)
15:07:25,109 ERROR [STDERR]     at java.util.TimerThread.mainLoop(Timer.java:512)
15:07:25,109 ERROR [STDERR]     at java.util.TimerThread.run(Timer.java:462)
15:07:25,281 INFO  [STDOUT] server:RmiJndiInitialContextFactoryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.180.12.70:2680](remote
),objID:[79002359:13048bcfb12:-7ffe, -8407673329275631937]]]]

Answer 1

http://hi.baidu.com/softmind/blog/item/3d69180613a93f7f020881c6.html

Answer 2

莫非是有connection没有及时关闭导致服务器内存不够？

Answer 3

Io 异常: End of TNS data channel
有时间刷新页面也会出现这个错误，但在刷新一次又正常了。

Answer 4

严重: Caught exception rolling back connection: java.sql.SQLException: Io 异常: End of TNS data channel
java.sql.SQLException: Io 异常: End of TNS data channel
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1380)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:581)
at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:340)
at groovy.sql.Sql.rollback(Sql.java:1238)
at sun.reflect.GeneratedMethodAccessor619.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)
at com.ddtech.base.GroovyControler.run(GroovyControler.groovy:158)
at com.ddtech.base.DDGroovyControlServlet.doGet(DDGroovyControlServlet.java:27)
at com.ddtech.base.DDGroovyControlServlet.doPost(DDGroovyControlServlet.java:35)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2011-06-02 11:16:33,844 DEBUG [org.jboss.resource.connectionmanager.TxConnectionManager] Unfinished local transaction was rolled back.org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1876db1[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@aa0a07 handles=0 lastUse=1306984496031 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@d04073 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@377f10 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@17877dc txSync=null]
2011-06-02 11:16:33,844 ERROR [STDERR] java.sql.SQLException: Io 异常: End of TNS data channel
2011-06-02 11:16:33,844 ERROR [STDERR]  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
2011-06-02 11:16:33,844 ERROR [STDERR]  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
2011-06-02 11:16:33,844 ERROR [STDERR]  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
2011-06-02 11:16:33,844 ERROR [STDERR]  at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1380)
2011-06-02 11:16:33,844 ERROR [STDERR]  at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:581)
2011-06-02 11:16:33,844 ERROR [STDERR]  at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:340)
2011-06-02 11:16:33,844 ERROR [STDERR]  at groovy.sql.Sql.rollback(Sql.java:1238)
2011-06-02 11:16:33,844 ERROR [STDERR]  at sun.reflect.GeneratedMethodAccessor619.invoke(Unknown Source)
2011-06-02 11:16:33,844 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2011-06-02 11:16:33,844 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:597)
2011-06-02 11:16:33,844 ERROR [STDERR]  at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)
2011-06-02 11:16:33,859 ERROR [STDERR]  at com.ddtech.base.GroovyControler.run(GroovyControler.groovy:158)
2011-06-02 11:16:33,859 ERROR [STDERR]  at com.ddtech.base.DDGroovyControlServlet.doGet(DDGroovyControlServlet.java:27)
2011-06-02 11:16:33,859 ERROR [STDERR]  at com.ddtech.base.DDGroovyControlServlet.doPost(DDGroovyControlServlet.java:35)
2011-06-02 11:16:33,859 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
2011-06-02 11:16:33,859 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
2011-06-02 11:16:33,859 ERROR [STDERR]  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
2011-06-02 11:16:33,875 ERROR [STDERR]  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
2011-06-02 11:16:33,875 ERROR [STDERR]  at java.lang.Thread.run(Thread.java:619)

Answer 5

2L引用的是共享服务器连接所导致的问题，专用服务器就不会有这个问题
让你的DBA去监控一下发生这个问题是数据库的状态吧

Answer 6

java.sql.SQLException: Io 异常: End of TNS data channel提示的是DB的错误。你先去看下DB。