Communications link failure due to underlying exception:

Question

2008-12-17 20:39:46,328 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL E
rror: 0, SQLState: 08S01>
2008-12-17 20:39:46,328 ERROR [org.hibernate.util.JDBCExceptionReporter] - <Comm
unications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.net.SocketException
MESSAGE: Connection reset by peer: socket write errorSTACKTRACE:java.net.SocketException: Connection reset by peer: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65
)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
        at com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatem
ent.java:892)
        at com.mysql.jdbc.ServerPreparedStatement.close(ServerPreparedStatement.
java:458)
        at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement
.java:165)
        at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBat
cher.java:471)
        at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.jav
a:218)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
198)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:91)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:86)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatc
her.java:171)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2048)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2421)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja
va:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:296)
        at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
aultAutoFlushEventListener.java:41)
        at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:9
78)
        at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessio
nImpl.java:135)
        at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImp
l.java:113)
        at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1602)
        at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate
(HibernateTemplate.java:856)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:366)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedParam
(HibernateTemplate.java:854)
        at org.jdxplatform.core.commons.HibernateGenericDao.findByNamedParam(Hib
ernateGenericDao.java:233)
        at com.testonline.manager.TTestPlanManager.doAcceptRemoteTestInfo(TTestP
lanManager.java:190)
        at com.testonline.manager.TTestPlanManager$$FastClassByCGLIB$$64e85bfb.i
nvoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
        at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:709)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:100)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:647)
        at com.testonline.manager.TTestPlanManager$$EnhancerByCGLIB$$5e0224f4.do
AcceptRemoteTestInfo(<generated>)
        at com.testonline.webapp.action.TTestPlanAction.acceptRemoteTestInfo(TTe
stPlanAction.java:91)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:217)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:191)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
     

Answer 1

   at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:72)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.jdxplatform.core.web.MessageFilter.doFilter(MessageFilter.java:24
)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:174)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:77)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:78)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:77)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.ecside.filter.ECSideFilter.doFilter(ECSideFilter.java:256)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
        at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **Last packet sent to the server was 0 ms ago.>===========================
我查过一些帖，说项目运行8小时以上会出现这个问题，而我的是插入数据的时候产生这个问题的
在线等，解决给满分

Answer 2

这个问题我遇到过一般是锁冲突，主要是innodb引擎的表较常发生，一般是进行大量的insert操作会出现这样的情况，使用unlock tables试试，如果不行只能重启服务

Answer 3

谢谢楼上的朋友
不过mysql这个问题真让人郁闷，同样的操作，同样的表，数据量更大，都没有碰到过这个问题

Answer 4

我刚遇到，不过问题解决了，是Jdbc.properties的连接字符串有问题，本来是将localhost改为公司的ip地址，后来，在家重启的时候就出现了这个问题，再将ip地址改为localhost问题就解决了。