日期:2014-05-20  浏览次数:20880 次

java.net.SocketException
mysql异常,昨天好好的,开了一晚上,第二天来就出现这个异常。高手帮助解决下啊!!
java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
  at java.net.SocketOutputStream.socketWrite0(Native Method)
  at java.net.SocketOutputStream.socketWrite(Unknown Source)
  at java.net.SocketOutputStream.write(Unknown Source)
  at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
  at java.io.BufferedOutputStream.flush(Unknown Source)
  at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1332)
  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1467)
  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
208)
  at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  at org.hibernate.loader.Loader.doQuery(Loader.java:802)
  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:274)
  at org.hibernate.loader.Loader.doList(Loader.java:2533)
  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  at org.hibernate.loader.Loader.list(Loader.java:2271)
  at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java
:119)
  at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
  at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
  at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
  at com.rzcm.user.dao.impl.UserDaoImpl.getUserByName(UserDaoImpl.java:203
)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:309)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:196)
  at $Proxy14.getUserByName(Unknown Source)
  at com.rzcm.user.service.impl.UserServiceImpl.getUserByName(UserServiceI
mpl.java:66)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:309)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
  at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:110)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
  at $Proxy17.getUserByName(Unknown Source)
  at edu.yale.its.tp.cas.auth.provider.SampleHandler.authenticate(SampleHa
ndler.java:25)
  at edu.yale.its.tp.cas.servlet.Login.doGet(Login.java:186)
  at edu.yale.its.tp.cas.servlet.Login.doPost(Login.java:103)
  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(Appl
icationFilterChain.java:290)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:216)
  at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

  at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
  at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
  at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.ja
va:697)
  at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSock
et.java:889)
  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:686)
  at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **

------解决方案--------------------
明显跟数据库的连接坏掉了,看看mysql是否还在正常运行,会不会是mysql down掉了?

还是网络出现问题了? 最后看看连接池配置,有时候连接池没配好也会出现这种情况。连接超时了以后再请求数据库的时候就会报socket连接错误。