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

concurrency error when creating content in parallel with same name in same parent - Integrity constraint violation: 1062 Duplicate entry

    XMLWordPrintable

Details

    Description

      This happens when using the ez5 api and running multiple processes in parallel to create content.

      The error message is akin to:

      [14662] An exception occurred while executing 'INSERT INTO `ezurlalias_ml` (`id`, `link`, `parent`, `action`, `lang_mask`, `text`, `text_md5`, `is_original`, `is_alias`, `alias_redirects`, `action_type`) VALUES (:placeholder1, :placeholder2, :placeholder3, :placeholder4, :placeholder5, :placeholder6, :placeholder7, :placeholder8, :placeholder9, :placeholder10, :placeholder11)' with params ["964915", "964915", "154123", "eznode:964926", 2, "Vitamin-D5", "1ece9beb6d9473d66f31b1647de592ac", 1, 0, 0, "eznode"]:
      [14662] 
      [14662] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '154123-1ece9beb6d9473d66f31b1647de592ac' for key 'PRIMARY'
      [14662] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '154123-1ece9beb6d9473d66f31b1647de592ac' for key 'PRIMARY'
      [14662] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '154123-1ece9beb6d9473d66f31b1647de592ac' for key 'PRIMARY' in file /var/www/wrbm/vendor/ezsystems/ezpublish-kernel/eZ/Publish/Core/Persistence/Legacy/Content/UrlAlias/Gateway/ExceptionConversion.php line 174
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: