mysql:10760
From: Hiroshi Kitabata <Hiroshi Kitabata <kitabata@xxxxxxxxxx>>
Date: Sun, 09 Jan 2005 21:58:39 +0900
Subject: [mysql 10760] Java DataSourceからの接続で時間が立つとエラーになる
きたばたと申します。 Tomcat4.1.27とMySQL 4.1.6-gammaをjakarta-commonsのDBCPを使って接続するテ ストを行っています。Tomcat起動時はうまく動くのですが時間が立つと(おそら く数時間)下記のようなExceptionが出てそれ以降接続することが出来なくなり ます。MySQLは初心者でどこを調べれば良いのか検討もつきません。これだけで は情報不足かもしれませんが、なにかお分かりになる方がおられましたらご教示 頂けると幸いです。 java.sql.SQLException: No operations allowed after connection closed. Connection was closed due to the following exception: ** BEGIN NESTED EXCEPTION ** java.sql.SQLException MESSAGE: Communication link failure: java.io.EOFException, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at com.mysql.jdbc.Connection.execSQL(Connection.java:2248) at com.mysql.jdbc.Connection.execSQL(Connection.java:2208) at com.mysql.jdbc.Connection.execSQL(Connection.java:2189) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:546) at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:237) at org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:273) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312) at cx.ath.triaxis.jtasks.BaseDBAction.execute(BaseDBAction.java:123) at cx.ath.triaxis.jtasks.JTasksControlServlet.processCommon(JTasksControlServlet.java:208) at cx.ath.triaxis.jtasks.JTasksControlServlet.doPost(JTasksControlServlet.java:112) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at cx.ath.triaxis.jtasks.common.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) -- Hiroshi Kitabata <kitabata@xxxxxxxxxx>
-> 10760 2005-01-09 21:58 [Hiroshi Kitabata <ki] Java DataSourceからの接続で時間が立つとエラーになる 10761 2005-01-10 01:27 ┣[bon <bon@xxxxxxxxxx>] 10764 2005-01-10 19:53 ┃┗[Hiroshi Kitabata <ki] 10763 2005-01-10 03:56 ┗[Teruyuki SATAKE <sat] 10765 2005-01-10 19:56 ┗[Hiroshi Kitabata <ki] 10767 2005-01-11 10:10 ┗["TAKAHASHI, Tomohiro] 10768 2005-01-11 12:24 ┗[Teruyuki SATAKE <sat] 10769 2005-01-11 12:41 ┣[seiji takegata <take] 10771 2005-01-11 13:15 ┃┗["TAKAHASHI, Tomohiro] 10775 2005-01-11 20:17 ┃ ┗[seiji takegata <take] コネクションプーリング 10776 2005-01-11 20:29 ┃ ┗["TAKAHASHI, Tomohiro] 10777 2005-01-11 22:42 ┃ ┗[seiji takegata <take] 10770 2005-01-11 13:15 ┗["TAKAHASHI, Tomohiro] 10772 2005-01-11 13:55 ┣[Teruyuki SATAKE <sat] 10773 2005-01-11 14:09 ┃┗["TAKAHASHI, Tomohiro] 10778 2005-01-12 07:36 ┗[とみたまさひろ <tomm]