Mailing List Archive: Zope: DB

MySQL gone away

Index | Next | Previous | View Threaded

ticino at hccnet

Mar 20, 2007, 1:18 AM

Post #1 of 3 (1561 views)
Permalink

MySQL gone away

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

_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

lists at zopyx

Mar 20, 2007, 1:20 AM

Post #2 of 3 (1473 views)
Permalink

Re: MySQL gone away [In reply to]

--On 20. März 2007 09:18:19 +0100 ticino [at] hccnet wrote:

> 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?

How shall we know why your database went down? :-)
Check for indications on the mysql server side - means: check your mysql
server logs.

-aj

ticino at hccnet

Mar 20, 2007, 2:36 AM

Post #3 of 3 (1460 views)
Permalink

MySQL gone away [In reply to]

Thanks, Andreas, I will look at the mysql log files.
I was also thinking about incompatibilities between the zmysql database
adapter and the last Zope version. I have used the same setup with Zope
2.9.2 before without this problem.

Henk

Op Di, 20 maart, 2007 9:20 am schreef Andreas Jung:
>

>
> --On 20. März 2007 09:18:19 +0100 ticino [at] hccnet wrote:
>
>
>> 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?
>
> How shall we know why your database went down? :-)
> Check for indications on the mysql server side - means: check your mysql
> server logs.
>
> -aj

_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads