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<div>
<div><br></div><div><br></div><div>Traceback:</div><div><br></div><div><div>2010-02-24T09:43:09 ERROR Zope.SiteErrorLog <a href="http://www.mywebsite.com/login_form">http://www.mywebsite.com/login_form</a></div><div>Traceback (innermost last):</div>
<div> Module ZPublisher.Publish, line 125, in publish</div><div> Module Zope2.App.startup, line 238, in commit</div><div> Module transaction._manager, line 96, in commit</div><div> Module transaction._transaction, line 395, in commit</div>
<div> Module transaction._transaction, line 498, in _commitResources</div><div> Module ZODB.Connection, line 726, in tpc_vote</div><div> Module relstorage.relstorage, line 711, in tpc_vote</div><div> Module relstorage.relstorage, line 686, in _vote</div>
<div> Module relstorage.relstorage, line 593, in _prepare_tid</div><div> Module relstorage.adapters.mysql, line 506, in start_commit</div><div> Module relstorage.adapters.mysql, line 672, in _hold_commit_lock</div><div>
StorageError: Unable to acquire commit lock</div><div><br></div> <div><br></div><div><br></div><div>I looked at the code and this function _hold_commit_lock has the following SELECT statement:</div><div><br></div><div>SELECT GET_LOCK(CONCAT(DATABASE(), '.commit'), %s)</div>
<div><br></div><div>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.</div><div><br></div><div><br></div><div><br></div><div>Does anybody already had this problem?</div>
<div><br></div><div><br></div><div>Thanks for any reply.</div><div><br></div><br>Regards,<br><br>- -<br>iarlyy selbir | ski0s<br><br>:wq!<br>
</div></div>