On two different installations we have transaction rollbacks when publishing objects.

[ Oct 29 2009 19:03:33 ] [192.168.1.100] eZMySQLDB:
Query error: Lock wait timeout exceeded; try restarting transaction. Query: UPDATE ezcontentobject_tree SET modified_subnode=1256839362 WHERE node_id='1' OR node_id='2' OR node_id='5753' OR node_id='7649' OR node_id='7652' OR node_id='33791'
[ Oct 29 2009 19:03:33 ] [192.168.1.100] eZDBInterface::commit TRANSID-4d0d9d9f57ae05bf0fa5df7bf28d8199:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-4d0d9d9f57ae05bf0fa5df7bf28d8199.

Steps to reproduce

Happens very randomly so it is very hard to specify steps to reproduce