Luuk wrote:
> John Nagle schreef:
>> 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?
>>
>> John Nagle
>
> does this happen when your logfiles rotate ? (just a wild guess...)

It happens every Sunday morning, when the first new transaction
comes in after 5 AM or so. Unfortunately, I don't have the error
message from Python, because I'm logging errors in the database,
not a log file. This has happened for three weeks in a row now,
and it's the only time the app crashes.

I run a big batch update from another process every Sunday from
0030 to 0330 or so. But that's loading some tables that shouldn't
affect the Python application at all. The update creates some
new tables and does a LOAD DATA LOCAL INFILE. At the end of the update,
the tables are renamed. But the tables are completely different from
the ones used by the app that crashes.

The Linux server and mysqld instance have been up without a crash for
months. It's not a database engine restart.

John Nagle