Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-15734

Transaction rollback on updating modified_subnode

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.1.3
    • Fix Version/s: 4.5.0
    • Component/s: Database related
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bd Bertrand Dunogier
              Reporter:
              gof Ivo Luka─Ź
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: