spring + c3p0 + mybatis + mysql 数据库连接偶尔异常

SDY-小五 2015-06-28 01:31:12

数据可是在阿里云上的，在本地和阿里部署的项目运行都是正常的，但是在新浪云上部署后，登录获取用户信息，
直接报错如下：纠结了好几天，网上找了好多，都未能解决！

我要说的是项目启动完成，登录就出现这个，也没有8小时。搞不明白！



org.springframework.dao.RecoverableDataAccessException: 

### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



Last packet sent to the server was 1 ms ago.

### The error may exist in file [/data1/jetty_work/335/**********/WEB-INF/classes/com/mapper/Account_mapper.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT           *        FROM  account WHERE  name = ?

### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



Last packet sent to the server was 1 ms ago.

; SQL []; Communications link failure



Last packet sent to the server was 1 ms ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



Last packet sent to the server was 1 ms ago.

	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98)

	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)

	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)

	at $Proxy11.selectOne(Unknown Source)

	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)

	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)

	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)

	at $Proxy13.getAccountInfo(Unknown Source)

	at com.sun.jd.service.AccountService.loginJdAccount(AccountService.java:61)

	at com.sun.jd.web.controller.LoginController.loginJd(LoginController.java:88)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:624)

	at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)

	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)

	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)

	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)

	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)

	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538)

	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1357)

	at com.sina.sae.facade.SaeFilterChain.doFilter(SaeFilterChain.java:28)

	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

	at com.sina.sae.servlet.SaeServletHandler.servletHandlerDoFilter(SaeServletHandler.java:56)

	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1328)

	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476)

	at com.sina.sae.servlet.SaeServletHandler.doHandle(SaeServletHandler.java:49)

	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517)

	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)

	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937)

	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)

	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)

	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871)

	at com.sina.sae.webapp.SaeWebAppContext.doScope(SaeWebAppContext.java:166)

	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:259)

	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)

	at com.sina.sae.handler.SaeUserInfoHandler.handle(SaeUserInfoHandler.java:109)

	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)

	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:305)

	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)

	at org.eclipse.jetty.server.Server.handle(Server.java:349)

	at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589)

	at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1065)

	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:823)

	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220)

	at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411)

	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535)

	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)

	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529)

	at java.lang.Thread.run(Thread.java:714)

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



Last packet sent to the server was 1 ms ago.

	at sun.reflect.GeneratedConstructorAccessor24.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)

	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)

	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)

	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)

	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:1392)

	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)

	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)

	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)

	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)

	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)

	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)

	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:624)

	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)

	... 55 more

Caused by: java.net.SocketException: Connection reset

	at java.net.SocketInputStream.read(SocketInputStream.java:185)

	at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

	at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

	at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

	... 78 more