You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2006/05/24 09:50:10 UTC
DO NOT REPLY [Bug 39651] New: - Communication error while connecting to MySQL server
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
DO NOT REPLY [Bug 39651] - Communication error while connecting to MySQL server
Posted by bu...@apache.org.
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
dpotter@mitre.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
------- Additional Comments From dpotter@mitre.org 2006-05-24 17:57 -------
This isn't a bug. MySQL, by default, times out connections after a prolonged
period of time. See:
http://dev.mysql.com/doc/connector/j/en/cj-faq.html#connector_j_wait_timeout_q_and_a
Just add "autoReconnect=true" to your JDBC URL options. Something like:
jdbc:mysql://localhost/mydb?autoReconnect=true
This should solve this problem.
--
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
Re: DO NOT REPLY [Bug 39651] New: - Communication error while connecting to MySQL server
Posted by Sameer Acharya <ac...@yahoo.com>.
This sounds like a connection timeout issue to me.
-Sameer
bugzilla@apache.org wrote: DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
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
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.