tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Januski, Ken" <>
Subject RE: Tomcat problems every morning.
Date Mon, 02 Jun 2003 15:57:38 GMT
Just out of curiosity have you posted this question to mysql users list now
that you see the problem pointing to mysql?

-----Original Message-----
From: Hemendra Rana []
Sent: Monday, June 02, 2003 9:33 AM
To: Tomcat Users List
Subject: Re: Tomcat problems every morning.

The traces that I put yesterday did indeed show that it is the MySQL 
database driver that times out the connection. I have added 
autoReconnect=true to the URL. Lets see if that works. Following is the 
stack trace of the exception that I got:

java.sql.SQLException: Communication link failure:
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.sendCommand(
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
        at com.mysql.jdbc.Connection.execSQL(


Paul (BRI) wrote:

>My comment won't be that helpful - but I started out at the same place -
>each morning I came in a got a call from staff saying the pages with
>content pulled from the dbase was down. 
>One thing I know, as others suggested, it has to do with the
>JDBC/connection - in our case it happens when the network connection
>between our linux box and our sql box os broken at some point - I think
>the ISP does late night maintenance on the line (this is setup on an
>office DSL line). We are still working to isolate the problem - but it
>does seem to be JDBC related. I have tried simply pulling the cable on
>the back of one box for a few seconds and the connection does die and
>will not reconnect.
>I plan to post back to the group when we get a better sense of the
>problem - we are still fooling with it. In our case we are using MSSQL
>with the MS JDBC driver. I thought I saw a post somewhere that said the
>mySQL driver had a autoReconnect=true setting - I think I saw it on the
>Apache site.
>I hope you figure things out.
>-----Original Message-----
>From: Hollerman Geralyn M [] 
>Sent: Sunday, June 01, 2003 9:07 PM
>To: Tomcat Users List
>Subject: Re: Tomcat problems every morning.
>On Sun, 01 Jun 2003 18:14:05 -0700, Hemendra Rana wrote
>>Are you using mysql database on the backend too. Someone here
>>pointed out that by default, mysql driver times out after every 8 
>>hours. I still needs to verify whether that is the cause of my 
>>problem though. Will let you know of my finds.
>Why, yes, I am. And I thought perhaps MySQL was the problem - but I was
>told by some people using Oracle and PostgreSQL databases that they'd
>seen the problem as well. I tried putting in some code to set the driver
>time-out value, but evidently I didn't do it correctly, as the problem
>persisted. I don't see the error with versions of Tomcat previous to
>4.1.x, tho.
>Lynn Hollerman.
>To unsubscribe, e-mail:
>For additional commands, e-mail:
>To unsubscribe, e-mail:
>For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message