[前][次][番号順一覧][スレッド一覧]

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]