java - Getting org.hibernate.util.JDBCExceptionReporter: Connection reset by peer: socket write error -
i'm using hibernate, spring, jboss , microsoft sql server 2008 r2. @ seemingly random times error
error [http-0.0.0.0-8080-7] org.hibernate.util.jdbcexceptionreporter [jdbcexceptionreporter.java:101] connection reset peer: socket write error 2013-05-20 14:43:51,171 error [http-0.0.0.0-8080-7] org.hibernate.transaction.jdbctransaction [jdbctransaction.java:202] jdbc rollback failed com.microsoft.sqlserver.jdbc.sqlserverexception: connection closed. @ com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdrivererror(sqlserverexception.java:170) ~[sqljdbc4.jar!/:na] @ com.microsoft.sqlserver.jdbc.sqlserverconnection.checkclosed(sqlserverconnection.java:304) ~[sqljdbc4.jar!/:na] @ com.microsoft.sqlserver.jdbc.sqlserverconnection.setautocommit(sqlserverconnection.java:1592) ~[sqljdbc4.jar!/:na] @ org.jboss.resource.adapter.jdbc.basewrappermanagedconnection.checktransaction(basewrappermanagedconnection.java:545) @ org.jboss.resource.adapter.jdbc.wrappedconnection.checktransaction(wrappedconnection.java:826) ~[jboss-common-jdbc-wrapper.jar!/:5.1.0.ga (build: svntag=jboss_5_1_0_ga date=200905221634)] @ org.jboss.resource.adapter.jdbc.wrappedconnection.rollback(wrappedconnection.java:499) @ org.hibernate.transaction.jdbctransaction.rollbackandresetautocommit(jdbctransaction.java:217) ~[hibernate3.jar:3.5.4-final] @ org.hibernate.transaction.jdbctransaction.rollback(jdbctransaction.java:196) ~[hibernate3.jar:3.5.4-final] @ com.wideplay.warp.persist.hibernate.hibernatelocaltxninterceptor.rollbackifnecessary(hibernatelocaltxninterceptor.java:149) @ com.wideplay.warp.persist.hibernate.hibernatelocaltxninterceptor.invoke(hibernatelocaltxninterceptor.java:72) @ com.google.inject.internal.interceptorstackcallback$interceptedmethodinvocation.proceed(interceptorstackcallback.java:72) [guice-3.0.jar:na] @ com.google.inject.internal.interceptorstackcallback.intercept(interceptorstackcallback.java:52) [guice-3.0.jar:na] @ com.myclassa$$enhancerbyguice$$6f61ba26.getdefaultsettings(<generated>) [guice-3.0.jar:na] @ com.myclassb.getdefaultsettings(myclassb.java:155) [classes:na] @ com.myclassbimpl.getdefaultsettings(myclassbimpl.java:106) [classes:na] @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.6.0_24] @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) ~[na:1.6.0_24] @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) ~[na:1.6.0_24] @ java.lang.reflect.method.invoke(method.java:597) ~[na:1.6.0_24] @ com.sun.xml.ws.api.server.instanceresolver$1.invoke(instanceresolver.java:246) [webservices-rt.jar:1.0] @ com.sun.xml.ws.server.invokertube$2.invoke(invokertube.java:146) [webservices-rt.jar:1.0] @ com.sun.xml.ws.server.sei.endpointmethodhandler.invoke(endpointmethodhandler.java:257) [webservices-rt.jar:1.0] @ com.sun.xml.ws.server.sei.seiinvokertube.processrequest(seiinvokertube.java:95) [webservices-rt.jar:1.0] @ com.sun.xml.ws.api.pipe.fiber.__dorun(fiber.java:629) [webservices-rt.jar:1.0] @ com.sun.xml.ws.api.pipe.fiber._dorun(fiber.java:588) [webservices-rt.jar:1.0] @ com.sun.xml.ws.api.pipe.fiber.dorun(fiber.java:573) [webservices-rt.jar:1.0] @ com.sun.xml.ws.api.pipe.fiber.runsync(fiber.java:470) [webservices-rt.jar:1.0] @ com.sun.xml.ws.server.wsendpointimpl$2.process(wsendpointimpl.java:295) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.httpadapter$httptoolkit.handle(httpadapter.java:519) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.httpadapter.handle(httpadapter.java:288) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.servlet.servletadapter.handle(servletadapter.java:143) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.servlet.wsservletdelegate.doget(wsservletdelegate.java:155) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.servlet.wsservletdelegate.dopost(wsservletdelegate.java:189) [webservices-rt.jar:1.0] @ com.sun.xml.ws.transport.http.servlet.wsservlet.dopost(wsservlet.java:76) [webservices-rt.jar:1.0] @ javax.servlet.http.httpservlet.service(httpservlet.java:637) @ javax.servlet.http.httpservlet.service(httpservlet.java:717) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:290) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ org.jboss.web.tomcat.filters.replyheaderfilter.dofilter(replyheaderfilter.java:96) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:235) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:191) @ org.jboss.web.tomcat.security.securityassociationvalve.invoke(securityassociationvalve.java:190) @ org.jboss.web.tomcat.security.jacccontextvalve.invoke(jacccontextvalve.java:92) @ org.jboss.web.tomcat.security.securitycontextestablishmentvalve.process(securitycontextestablishmentvalve.java:126) @ org.jboss.web.tomcat.security.securitycontextestablishmentvalve.invoke(securitycontextestablishmentvalve.java:70) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:127) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:102) @ org.jboss.web.tomcat.service.jca.cachedconnectionvalve.invoke(cachedconnectionvalve.java:158) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:330) @ org.apache.coyote.http11.http11processor.process(http11processor.java:829) @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:598) @ org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:447) @ java.lang.thread.run(thread.java:662) working on since last 2 weeks, couldn't figure out root cause. appreciated.
edit : after editing server time out getting following exception
warning [com.microsoft.sqlserver.jdbc.internals.tds.reader] (pool-26-thread-7) connectionid:4 tds header contained invalid packet length:12590; packet size:8000 2013-05-21 15:59:15,777 severe [com.microsoft.sqlserver.jdbc.internals.tds.reader] (pool-26-thread-7) connectionid:4 got unexpected value in tds response @ offset:7992 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) exception in thread "pool-25-thread-2" 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) org.hibernate.transactionexception: jdbc rollback failed 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ org.hibernate.transaction.jdbctransaction.rollback(jdbctransaction.java:204) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.wideplay.warp.persist.hibernate.hibernatelocaltxninterceptor.rollbackifnecessary(hibernatelocaltxninterceptor.java:149) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.wideplay.warp.persist.hibernate.hibernatelocaltxninterceptor.invoke(hibernatelocaltxninterceptor.java:72) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.softpak.marserm.engine.library.impl.jobreportstatusutil.updatereportstatus(unknown source) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.softpak.marserm.engine.library.impl.executablejob.run(unknown source) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:886) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:908) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ java.lang.thread.run(thread.java:662) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) caused by: com.microsoft.sqlserver.jdbc.sqlserverexception: connection closed. 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdrivererror(sqlserverexception.java:170) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.checkclosed(sqlserverconnection.java:304) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.rollback(sqlserverconnection.java:1655) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ org.jboss.resource.adapter.jdbc.basewrappermanagedconnection.jdbcrollback(basewrappermanagedconnection.java:697) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ org.jboss.resource.adapter.jdbc.wrappedconnection.rollback(wrappedconnection.java:500) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ org.hibernate.transaction.jdbctransaction.rollbackandresetautocommit(jdbctransaction.java:217) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) @ org.hibernate.transaction.jdbctransaction.rollback(jdbctransaction.java:196) 2013-05-21 15:59:15,808 error [stderr] (pool-25-thread-2) ... 7 more second edit error log
severe [com.microsoft.sqlserver.jdbc.internals.tds.token] (pool-27-thread-7) connectionid:1: fetchbuffertokenhandler: encountered unexpected unknown token (0x30) severe [com.microsoft.sqlserver.jdbc.internals.tds.reader] (pool-27-thread-7) connectionid:1 got unexpected value in tds response @ offset:7282 severe [com.microsoft.sqlserver.jdbc.internals.tds.token] (pool-27-thread-7) connectionid:1: getnextresult: encountered unexpected unknown token (0x30) severe [com.microsoft.sqlserver.jdbc.internals.tds.reader] (pool-27-thread-7) connectionid:1 got unexpected value in tds response @ offset:7282
the data you're trying fetch big fit packet / or corrupted
warning [com.microsoft.sqlserver.jdbc.internals.tds.reader] (pool-26-thread-7) connectionid:4 tds header contained invalid packet length:12590; packet size:8000
depending on jdbc driver use, might want tweak of parameters.
Comments
Post a Comment