This site has been archived and you can no longer log in or post new messages. For up-to-date community resources please visit ezplatform.com

eZ Community » Forums » General » Rollbacked transactions
expandshrink

Rollbacked transactions

Rollbacked transactions

Tuesday 14 May 2013 5:36:39 pm - 1 reply

We have been struggling with deadlocked transactions for a couple of days. Unfortunately they are sporadic and hard to reproduce. Usually once a day, there's apparently a huge hickup on the database, and not a single publishing / deletion event succeeds any more. Then after an hour or so, all of sudden everything works perfectly fine again. There might be some erroneous extension that triggers it or some cron job, but so far I have not been able to get hold of it. The logs show rollbacks for transactions on ezcontentobject, ezcontentobject_tree, or ezcontentobject_version. Any suggestions on troubleshooting would be highly appreciated.

[ May 14 2013 10:49:10 ] [62.206.91.36] eZMySQLiDB:
Query error (1205): Lock wait timeout exceeded; try restarting transaction. Query: UPDATE ezcontentobject_version SET contentobject_id=39106, creator_id=109, version=23, status=0,
created=1368520526, modified=1368521049, workflow_event_pos=0, user_id=0,
language_mask=5, initial_language_id=4 WHERE id='2064560'
[ May 14 2013 10:49:10 ] [62.206.91.36] eZDBInterface::commit TRANSID-ef8a5cbe5dd81f053be7ce9dbbe5349e:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-ef8a5cbe5dd81f053be7ce9dbbe5349e.
[ May 14 2013 10:52:56 ] [62.206.91.36] eZMySQLiDB:
Query error (1205): Lock wait timeout exceeded; try restarting transaction. Query: UPDATE ezcontentobject_version SET contentobject_id=70441, creator_id=109, version=19, status=2,
created=1368520874, modified=1368521104, workflow_event_pos=0, user_id=0,
language_mask=5, initial_language_id=4 WHERE id='2064600'
[ May 14 2013 10:52:56 ] [62.206.91.36] eZMySQLiDB:
Query error (1205): Lock wait timeout exceeded; try restarting transaction. Query: UPDATE ezcontentobject_version SET contentobject_id=70441, creator_id=109, version=19, status=2,
created=1368520874, modified=1368521201, workflow_event_pos=0, user_id=0,
language_mask=5, initial_language_id=4 WHERE id='2064600'
[ May 14 2013 10:52:56 ] [62.206.91.36] eZMySQLiDB:
Query error (1205): Lock wait timeout exceeded; try restarting transaction. Query: UPDATE ezcontentobject_version SET contentobject_id=70441, creator_id=109, version=19, status=2,
created=1368520874, modified=1368521237, workflow_event_pos=0, user_id=0,
language_mask=5, initial_language_id=4 WHERE id='2064600'
[ May 14 2013 10:52:56 ] [62.206.91.36] eZDBInterface::commit TRANSID-dd8f3aa81e54b6ffaec321f1a3a2534c:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-dd8f3aa81e54b6ffaec321f1a3a2534c.
[ May 14 2013 10:52:56 ] [62.206.91.36] eZDBInterface::commit TRANSID-9944592b67b8e8452d740f1e3bd2a693:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-9944592b67b8e8452d740f1e3bd2a693.
[ May 14 2013 10:52:56 ] [62.206.91.36] eZDBInterface::commit TRANSID-7c441616ffff76c2ce273c397ed30016:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-7c441616ffff76c2ce273c397ed30016.

Tuesday 14 May 2013 8:11:41 pm

Is there maybe a db backup going on?

You could use the mysql slow query log to troubleshoot...

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from