[Zope] unable to acquire commit lock

Jonathan (dev101) dev101 at magma.ca
Wed Feb 24 08:24:22 EST 2010

Just a guess, but it looks like you are trying to get a transaction lock on
a mysql table, so does the mysql table you are using have a storage engine
that supports transactions (eg. InnoDB)?




From: zope-bounces at zope.org [mailto:zope-bounces at zope.org] On Behalf Of
iarly selbir | ski0s
Sent: February-24-10 8:12 AM
To: zope at zope.org
Subject: [Zope] unable to acquire commit lock


few days ago my I'm getting this errors when trying logging on /manage,
googling I don't found any reasonable solution and/or  information about,
only thing was, "restarting zope instances works", thats true





2010-02-24T09:43:09 ERROR Zope.SiteErrorLog

Traceback (innermost last):

  Module ZPublisher.Publish, line 125, in publish

  Module Zope2.App.startup, line 238, in commit

  Module transaction._manager, line 96, in commit

  Module transaction._transaction, line 395, in commit

  Module transaction._transaction, line 498, in _commitResources

  Module ZODB.Connection, line 726, in tpc_vote

  Module relstorage.relstorage, line 711, in tpc_vote

  Module relstorage.relstorage, line 686, in _vote

  Module relstorage.relstorage, line 593, in _prepare_tid

  Module relstorage.adapters.mysql, line 506, in start_commit

  Module relstorage.adapters.mysql, line 672, in _hold_commit_lock

StorageError: Unable to acquire commit lock




I looked at the code and this function _hold_commit_lock has the following
SELECT statement:




I tried to reproduce it querying manually but  it looks like an unknown
command, and other point, I don't know what Zope put in %s variable.




Does anybody already had this problem?



Thanks for any reply.



- -
iarlyy selbir | ski0s


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20100224/e4065735/attachment.html 

More information about the Zope mailing list