wibaut - 2007-03-26

I have a strange problem with ZMySQLDA. After a night (or many hours when I not use my site) it gets disconnected. Opening the
zmysqlda connection in Zope gets it right back on its feet again. I don't understand what happens here. MySQL keeps running.
I have a working installation of Zope 2.10.2 with mysql-python 1.2.2, zmysqlda 2.0.9b3 and MYSQL 5.027.
The errors are solely noticeable in Zope as far as I can see.
Can someone point out what this could be?

Enrico

The event log:

2007-03-19T12:51:12 ERROR ZMySQLDA exception during _begin
Traceback (most recent call last):
File "/home/mysite/zope/Products/ZMySQLDA/db.py", line
349, in _begin
self.db.ping()
OperationalError: (2006, 'MySQL server has gone away')

2007-03-15T12:01:32 ERROR txn.32773 Failed to abort object: Surrogate
oid=<object object at 0x4023b478>
Traceback (most recent call last):
File "/usr/local/zope/lib/python/transaction/_transaction.py", line
642, in abort
self.manager.abort(o, txn)
File "/usr/local/zope/lib/python/Shared/DC/ZRDB/TM.py", line 64, in abort
try: self._abort()
File "/home/mysite/zope/Products/ZMySQLDA/db.py", line
389, in _abort
self._tlock.release()
error: release unlocked lock