[Zope] Lost connection to MySQL server during query

[Dieter Maurer]

Chris Muldrow wrote at 2003-10-9 09:18 -0400:
 > We're getting several ZMySQLDA exceptions in our logs right before one of
 > our ZEO clients locks up. My reading of the errors below is some sort of
 > network interruption, but I wanted to post and see if anyone else had any
 > ideas about what might be happening.
 > 
 > 2003-10-09T06:15:30 ERROR(200) ZMySQLDA exception during _begin
 > Traceback (innermost last):
 >   File /var/www/zope/ZEOZOPE/lib/python/Products/ZMySQLDA/db.py, line 367,
 > in _begin
 > OperationalError: (2013, 'Lost connection to MySQL server during query')

Your "MySQL" server died...

 > ...
 > 2003-10-09T06:15:53 ERROR(200) ZODB A storage error occured during
 > transaction abort.  This shouldn't happen.
 > Traceback (innermost last):
 > File /var/www/zope/zope262c1/lib/python/ZODB/Transaction.py, line 262, in
 > commit
 >   File /var/www/zope/zope262c1/lib/python/ZODB/Transaction.py, line 393, in
 > _commit_error
 > AttributeError: Surrogate instance has no attribute '_p_oid'

Apparently a bug in ZODB. Please file a bug report...

 > ...
 > 2003-10-09T06:16:00 PANIC(300) ZODB A storage error occurred in the last
 > phase of a two-phase commit.  This shouldn't happen.
 > Traceback (innermost last):
 > : File /var/www/zope/zope262c1/lib/python/ZODB/Transaction.py, line 401, in
 > _commit_error
 >   File /var/www/zope/zope262c1/lib/python/Shared/DC/ZRDB/TM.py, line 60, in
 > abort
 >   File /var/www/zope/ZEOZOPE/lib/python/Products/ZMySQLDA/db.py, line 405,
 > in _abort
 > error: release unlocked lock

Probably a secondary error in the "ZMySQLDA" code.
You may want to file a bug report to the author.


Dieter