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

Object creation in concurrrency : Primary Key Duplicate error on urlalias_ml

    XMLWordPrintable

Details

    Description

      When we create an object in concurrency (ie: 2 users publish the same obj during the same time). We have a fatal error.

      Query error:

      Duplicate entry '5106-853b63e86e3eba9ad3fd2fe69d592390' for key 'PR IMARY'.
      Query: INSERT INTO ezurlalias_ml (id, parent, lang_mask, text, text_md5, action, action_type, link, is_alias, is_original, alias_redirects)
      VALUES(43487 , 5106, 2, 'Commentaire-a-traiter-sur-l-offre-API-click-to-call', '853b63e86e3eb a9ad3fd2fe69d592390', 'eznode:38694', 'eznode', 43487, 0, 1, 1)
      [ Feb 01 2012 16:02:48 ] [10.114.13.34] eZDBInterface::commit TRANSID-4f16cf62fe 5e6fca32ef3493c8807b5e:
      Transaction in progress failed due to DB error, transaction was rollbacked. Tran saction ID is TRANSID-4f16cf62fe5e6fca32ef3493c8807b5e.

      Steps to reproduce
      • Open the same folder in admin portal in 2 different browsers.
      • Create an article with the same title in each of the browsers.
      • Press publish button on both browsers at the same time (or as much overlapping the other as possible)
      • The above error will occur.

      Attachments

        Activity

          People

            dp@ez.no dp@ez.no
            joc@ez.no joc@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: