查看完整版本: [-- 论坛报错了,好像是MySQL连接问题,郁闷~ --]

风信Java论坛 ›› 论坛公告和信息发布区 ›› 论坛报错了,好像是MySQL连接问题,郁闷~ 登录 -> 注册

1F 论坛报错了,好像是MySQL连接问题,郁闷~   唧唧 Post by : 2008-06-25 10:52:03.0

10:47:52,734  WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 08S01
10:47:52,734 ERROR JDBCExceptionReporter:78 - The last packet successfully received from the server was123786 seconds ago.The last packet sent successfully to the server was 123786 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
10:47:52,843 ERROR JDBCTransaction:124 - JDBC commit failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
 at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1552)
 at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
 at org.javawind.hibernate.DataDAO.RecordCount(DataDAO.java:126)
 at org.javawind.beans.OnLineList.userSum(OnLineList.java:38)
 at org.javawind.jsp.PageIndex.execute(PageIndex.java:47)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.javawind.filters.EncodingProcessor.process(EncodingProcessor.java:15)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:114)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at org.javawind.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:29)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:435)
 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
 at java.lang.Thread.run(Thread.java:619)
org.hibernate.TransactionException: JDBC commit failed
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130)
 at org.javawind.hibernate.DataDAO.RecordCount(DataDAO.java:126)
 at org.javawind.beans.OnLineList.userSum(OnLineList.java:38)
 at org.javawind.jsp.PageIndex.execute(PageIndex.java:47)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.javawind.filters.EncodingProcessor.process(EncodingProcessor.java:15)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:114)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at org.javawind.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:29)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:435)
 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
 at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
 at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1552)
 at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
 ... 22 more
10:48:11,484  WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 08S01
10:48:11,484 ERROR JDBCExceptionReporter:78 - The last packet successfully received from the server was123805 seconds ago.The last packet sent successfully to the server was 123805 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
org.hibernate.exception.JDBCConnectionException: could not execute query
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.doList(Loader.java:2216)
 at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2136)
 at org.hibernate.loader.Loader.list(Loader.java:2096)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
 at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
 at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
 at org.javawind.hibernate.DataDAO.getAll(DataDAO.java:84)
 at org.javawind.beans.ForumList.getForumMap(ForumList.java:51)
 at org.javawind.beans.ForumList.getParentForumList(ForumList.java:76)
 at org.javawind.jsp.PageForum.ShowList(PageForum.java:41)
 at org.javawind.jsp.PageForum.execute(PageForum.java:29)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.javawind.filters.EncodingProcessor.process(EncodingProcessor.java:15)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:114)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at org.javawind.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:29)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:435)
 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
 at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was123805 seconds ago.The last packet sent successfully to the server was 123805 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
 at sun.reflect.GeneratedConstructorAccessor70.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
 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.executeQuery(PreparedStatement.java:1885)
 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
 at org.hibernate.loader.Loader.doQuery(Loader.java:674)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 at org.hibernate.loader.Loader.doList(Loader.java:2213)
 ... 31 more
Caused by: java.net.SocketException: Software caused connection abort: 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.write(BufferedOutputStream.java:109)
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3225)
 ... 41 more

2F    唧唧 Post by : 2008-06-25 11:14:51.0

or using the Connector/J connection property 'autoReconnect=true' to avoid this problem

昨天已经加了啊,还是报错,郁闷ing...

3F    唧唧 Post by : 2008-06-25 17:48:55.0

今天又第二次出错,变态啊~

郁闷~,到底怎么了,运行了一个月现在才出现呢

准备使用连接池了~


风信Java论坛 ›› 论坛公告和信息发布区 ›› 论坛报错了,好像是MySQL连接问题,郁闷~ 登录 -> 注册

查看完整版本: [-- 论坛报错了,好像是MySQL连接问题,郁闷~ --]
CopyRight © 2008-2009 JavaWind.Net Studio All Rights Reserved
Powered By JWind.BBS Vesion 1.0.0 Beta1 Processed in 8 ms,0 (Queries)  Gzip enabled
粤ICP备07511478号