[Zope-DB] MySQL gone away

ticino at hccnet.nl ticino at hccnet.nl
Tue Mar 20 04:18:19 EDT 2007


Hello,

I am getting errors in queries on a MySQL 5.027 database using zmysqlda
2.0.9b3 and mysql-python 1.2.1 with Zope 2.10.2.

The errors occured the next day after setting the whole thing up and
while at first it was working all right. The event log tells me that
MySQL has 'gone away', it probably has lost its connection in the zmysql
adapter. But why or how?

Henk Laloli

The event log:

2007-03-19T12:51:12 ERROR ZMySQLDA exception during _begin
Traceback (most recent call last):
  File "/home/amsterdamhistorie/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/amsterdamhistorie/zope/Products/ZMySQLDA/db.py", line
389, in _abort
    self._tlock.release()
error: release unlocked lock




More information about the Zope-DB mailing list