Mailing-List: contact dev-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Developers List" <dev@tomcat.apache.org>
From: bugzilla@apache.org
To: tomcat-dev@jakarta.apache.org
Subject: DO NOT REPLY [Bug 39651]  New:  - Communication error while
 connecting to MySQL server
Message-ID: <bug-39651-78@http.issues.apache.org/bugzilla/>
Date: Wed, 24 May 2006 07:50:10 +0000 (GMT)

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=39651>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=39651

           Summary: Communication error while connecting to MySQL server
           Product: Tomcat 5
           Version: 5.5.9
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: critical
          Priority: P2
         Component: Catalina
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: arriees@hotmail.com


I am using Apache Tomcat 5.5.9
 Mysql 5.0.20.
When I try to connect after a prolonged interval,  I get the following error. 
Note: initially I am able to connect to MySQL and perform all operation.  I 
get this error only when there are no activity for a long time. 
Should I do any config changes for this or is it a known bug?

thanks,
Aravind.

/*ERROR MESSAGE */
May 22, 2006 3:39:34 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-6495
May 22, 2006 3:39:34 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2109 ms
May 22, 2006 3:39:34 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
May 22, 2006 3:39:34 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.9
May 22, 2006 3:39:34 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
May 22, 2006 3:39:38 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-6495
May 22, 2006 3:39:38 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
May 22, 2006 3:39:38 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/78  config=null
May 22, 2006 3:39:38 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
May 22, 2006 3:39:39 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4672 ms
com.mysql.jdbc.CommunicationsException: Communications link failure due to 
under
lying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1865)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2256)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2756)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3025)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2954)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1009)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery
(Delegati
ngStatement.java:205)
        at loginServlet.login(loginServlet.java:102)
        at loginServlet.doPost(loginServlet.java:60)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java
:856)
        at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:744)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpo
int.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFol
lowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadP
ool.java:684)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


Last packet sent to the server was 5953 ms ago.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org