Hi John,

John Nagle <nagle@animats.com> wrote:
> Luuk wrote:

>>> I have a Python application which seems to lose its connection
>>> to the database exactly once per week. It's not an idle time issue;
>>> there's a transaction every few seconds, continuously. Is there
>>> a 1-week timeout somewhere in MySQL or MySQLdb?

> It happens every Sunday morning, when the first new transaction
> comes in after 5 AM or so.
>
> The Linux server and mysqld instance have been up without a crash for
> months. It's not a database engine restart.

I guess you checked this in the MySQL error log? No other messages
for this time? You should add log_warnings=2 to my.cnf. This will
enable some additional messages in the MySQL error log.

http://dev.mysql.com/doc/refman/5.0/...d_log-warnings


XL
--
Axel Schwenke, MySQL Support Engineer, Sun Microsystems GmbH

MySQL User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/