[Bug]: Deadlock Issue Encountered During Query Execution

[abdelrhmanyosry]

Pimcore version

11

Steps to reproduce

importing objects using data-importer.

objects example
{"type_id":"simple","sku":"COM-2-EZ-SB-EA","has_options":"0","required_options":"0","created_at":"2022-08-09 17:41:22","updated_at":"2023-11-01 21:01:12","cstore":{"50-350":"3 years","50-416":["New"],"50-316":["Case Erector"],"50-325":"0","50-326":"0","50-370":"EA","50-404":"Sides","50-393":"Automatic","50-412":"18\"","50-374":"0","50-366":"Combi Packaging Systems LLC","50-411":"24\"","50-410":"16\"","50-409":"5\"","50-408":"8\"","50-407":"6\"","50-405":"15 cases\/min","50-402":"2\" - Standard","50-379":"0","50-365":"Combi Packaging System LLC","50-369":"EA","50-339":"0","50-343":"0","50-321":"Yes","50-344":"Yes","50-353":"Yes","50-364":"V100135","50-355":"0","50-384":"1","50-385":"10000","50-327":"Use config","50-345":"8' 10.5\" L x 9' 7\" W x 6' 7.375\" H","50-367":"2-EZ-SB-15","50-363":"2000"},"tax_class_id":"2","image":"\/c\/o\/combi-2ez-sb-case-erector.jpg","small_image":"\/c\/o\/combi-2ez-sb-case-erector.jpg","thumbnail":"\/c\/o\/combi-2ez-sb-case-erector.jpg","image_label":"Combi 2-EZ SB Case Erector & Bottom Sealer","small_image_label":"Combi 2-EZ SB Case Erector & Bottom Sealer","thumbnail_label":"Combi 2-EZ SB Case Erector & Bottom Sealer","msrp_display_actual_price_type":"0","gift_message_available":"2","swatch_image":"\/c\/o\/combi-2ez-sb-case-erector.jpg","price":"0.000000","weight":"2100.000000","id":"18406","ProductInWebsite":["base"],"category":["106"],"Downloadable":false,"links_purchased_separately":false,"o_key_system":"COM-2-EZ-SB-EA","parent_id":-1,"Related_Products":[],"Upsell_Products":["18273"],"Crosssell_Products":[],"CustomerGroupPrice_FC":[],"MainDownloadableLinks_FC":[],"SampleDownloadableLinks_FC":[],"CustomizableText_FC":[],"CustomizableFile_FC":[],"CustomizableSelect_FC":[],"CustomizableDate_FC":[],"Quantity":0,"stockStatus":1,"Image_FC":{"image0":{"Image":"https:\/\/pim-rocket.readymage.com\/media\/catalog\/product\/c\/o\/combi-2ez-sb-case-erector.jpg","altText":"Combi 2-EZ SB Case Erector & Bottom Sealer","HideFromProductPage":"0","Base":1,"Small":1,"Thumbnail":1,"Swatch":1}},"Video_FC":[],"requireToSync":false,"meta_keyword-default":"Combi 2-EZ SB Case Erector & Bottom Sealer","description-default":"<p>The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. The 2-EZ SB can process a wide variety of case sizes. The case blank is vertically positioned in the walk-in magazine. Easily load the cases, which are then extracted from the magazine and formed by a squaring arm. After the minor and flaps are formed, the cases are transferred into the dual belt drives where they are bottom sealed with 2\" tape. Combi's 2-EZ case erectors are designed for the most demanding environments with ultimate durability and reliability.<\/p>\r\n<h3>Features<\/h3>\r\n<ul>\r\n<li>Forms and bottom seals up to 15 cases per minute<\/li>\r\n<li>Accepts a range of box sizes: 8\" to 24\" length, 6\" to 16\" width, and 5\" to 18\" height<\/li>\r\n<li>EZ-load walk-in powered case magazine (150 case capacity)<\/li>\r\n<li>Dual belt drives<\/li>\r\n<li>Pneumatic carriage assembly<\/li>\r\n<li>3M Accuglide II 2\" tape head<\/li>\r\n<li>Control panel provides production &amp; diagnostic feedback<\/li>\r\n<li>\u201cNo tool\u201d changeover system<\/li>\r\n<li>Left or right hand operation<\/li>\r\n<li>Self-cleaning vacuum system<\/li>\r\n<li>Heavy-duty welded steel construction<\/li>\r\n<li>Optional add-ons and custom configurations are available<\/li>\r\n<\/ul>","short_description-default":"<ul>\r\n<li>Processes up to 15 cases per minute<\/li>\r\n<li>Walk-in powered case magazine<\/li>\r\n<\/ul>","cstore-default":{"50-350":"3 years","50-416":["New"],"50-316":["Case Erector"],"50-325":"0","50-326":"0","50-370":"EA","50-404":"Sides","50-393":"Automatic","50-412":"18\"","50-374":"0","50-366":"Combi Packaging Systems LLC","50-411":"24\"","50-410":"16\"","50-409":"5\"","50-408":"8\"","50-407":"6\"","50-405":"15 cases\/min","50-402":"2\" - Standard","50-379":"0","50-365":"Combi Packaging System LLC","50-369":"EA","50-339":"0","50-343":"0","50-321":"Yes","50-344":"Yes","50-353":"Yes","50-364":"V100135","50-355":"0","50-384":"1","50-385":"10000","50-327":"Use config","50-345":"8' 10.5\" L x 9' 7\" W x 6' 7.375\" H","50-367":"2-EZ-SB-15","50-363":"2000"},"status-default":"1","visibility-default":"4","name-default":"Combi 2-EZ SB Case Erector & Taper","meta_title-default":"Combi 2EZ SB Case Erector and Taper","meta_description-default":"The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. Walk-in powered case magazine. Standard 2\" tape head. Optional add-ons and custom configurations available.","options_container-default":"container1","url_key-default":"combi-2ez-sb-case-erector-with-bottom-sealer","meta_keyword-b2b":"Combi 2-EZ SB Case Erector & Bottom Sealer","description-b2b":"<p>The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. The 2-EZ SB can process a wide variety of case sizes. The case blank is vertically positioned in the walk-in magazine. Easily load the cases, which are then extracted from the magazine and formed by a squaring arm. After the minor and flaps are formed, the cases are transferred into the dual belt drives where they are bottom sealed with 2\" tape. Combi's 2-EZ case erectors are designed for the most demanding environments with ultimate durability and reliability.<\/p>\r\n<h3>Features<\/h3>\r\n<ul>\r\n<li>Forms and bottom seals up to 15 cases per minute<\/li>\r\n<li>Accepts a range of box sizes: 8\" to 24\" length, 6\" to 16\" width, and 5\" to 18\" height<\/li>\r\n<li>EZ-load walk-in powered case magazine (150 case capacity)<\/li>\r\n<li>Dual belt drives<\/li>\r\n<li>Pneumatic carriage assembly<\/li>\r\n<li>3M Accuglide II 2\" tape head<\/li>\r\n<li>Control panel provides production &amp; diagnostic feedback<\/li>\r\n<li>\u201cNo tool\u201d changeover system<\/li>\r\n<li>Left or right hand operation<\/li>\r\n<li>Self-cleaning vacuum system<\/li>\r\n<li>Heavy-duty welded steel construction<\/li>\r\n<li>Optional add-ons and custom configurations are available<\/li>\r\n<\/ul>","short_description-b2b":"<ul>\r\n<li>Processes up to 15 cases per minute<\/li>\r\n<li>Walk-in powered case magazine<\/li>\r\n<\/ul>","cstore-b2b":{"50-350":"3 years","50-416":["New"],"50-316":["Case Erector"],"50-325":"0","50-326":"0","50-370":"EA","50-404":"Sides","50-393":"Automatic","50-412":"18\"","50-374":"0","50-366":"Combi Packaging Systems LLC","50-411":"24\"","50-410":"16\"","50-409":"5\"","50-408":"8\"","50-407":"6\"","50-405":"15 cases\/min","50-402":"2\" - Standard","50-379":"0","50-365":"Combi Packaging System LLC","50-369":"EA","50-339":"0","50-343":"0","50-321":"Yes","50-344":"Yes","50-353":"Yes","50-364":"V100135","50-355":"0","50-384":"1","50-385":"10000","50-327":"Use config","50-345":"8' 10.5\" L x 9' 7\" W x 6' 7.375\" H","50-367":"2-EZ-SB-15","50-363":"2000"},"status-b2b":"1","visibility-b2b":"4","name-b2b":"Combi 2-EZ SB Case Erector & Taper","meta_title-b2b":"Combi 2EZ SB Case Erector and Taper","meta_description-b2b":"The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. Walk-in powered case magazine. Standard 2\" tape head. Optional add-ons and custom configurations available.","options_container-b2b":"container1","url_key-b2b":"b2b-combi-2ez-sb-case-erector-with-bottom-sealer","meta_keyword-floor_scrubbers":"Combi 2-EZ SB Case Erector & Bottom Sealer","description-floor_scrubbers":"<p>The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. The 2-EZ SB can process a wide variety of case sizes. The case blank is vertically positioned in the walk-in magazine. Easily load the cases, which are then extracted from the magazine and formed by a squaring arm. After the minor and flaps are formed, the cases are transferred into the dual belt drives where they are bottom sealed with 2\" tape. Combi's 2-EZ case erectors are designed for the most demanding environments with ultimate durability and reliability.<\/p>\r\n<h3>Features<\/h3>\r\n<ul>\r\n<li>Forms and bottom seals up to 15 cases per minute<\/li>\r\n<li>Accepts a range of box sizes: 8\" to 24\" length, 6\" to 16\" width, and 5\" to 18\" height<\/li>\r\n<li>EZ-load walk-in powered case magazine (150 case capacity)<\/li>\r\n<li>Dual belt drives<\/li>\r\n<li>Pneumatic carriage assembly<\/li>\r\n<li>3M Accuglide II 2\" tape head<\/li>\r\n<li>Control panel provides production &amp; diagnostic feedback<\/li>\r\n<li>\u201cNo tool\u201d changeover system<\/li>\r\n<li>Left or right hand operation<\/li>\r\n<li>Self-cleaning vacuum system<\/li>\r\n<li>Heavy-duty welded steel construction<\/li>\r\n<li>Optional add-ons and custom configurations are available<\/li>\r\n<\/ul>","short_description-floor_scrubbers":"<ul>\r\n<li>Processes up to 15 cases per minute<\/li>\r\n<li>Walk-in powered case magazine<\/li>\r\n<\/ul>","cstore-floor_scrubbers":{"50-350":"3 years","50-416":["New"],"50-316":["Case Erector"],"50-325":"0","50-326":"0","50-370":"EA","50-404":"Sides","50-393":"Automatic","50-412":"18\"","50-374":"0","50-366":"Combi Packaging Systems LLC","50-411":"24\"","50-410":"16\"","50-409":"5\"","50-408":"8\"","50-407":"6\"","50-405":"15 cases\/min","50-402":"2\" - Standard","50-379":"0","50-365":"Combi Packaging System LLC","50-369":"EA","50-339":"0","50-343":"0","50-321":"Yes","50-344":"Yes","50-353":"Yes","50-364":"V100135","50-355":"0","50-384":"1","50-385":"10000","50-327":"Use config","50-345":"8' 10.5\" L x 9' 7\" W x 6' 7.375\" H","50-367":"2-EZ-SB-15","50-363":"2000"},"status-floor_scrubbers":"1","visibility-floor_scrubbers":"4","name-floor_scrubbers":"Combi 2-EZ SB Case Erector & Taper","meta_title-floor_scrubbers":"Combi 2EZ SB Case Erector and Taper","meta_description-floor_scrubbers":"The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. Walk-in powered case magazine. Standard 2\" tape head. Optional add-ons and custom configurations available.","options_container-floor_scrubbers":"container1","url_key-floor_scrubbers":"combi-2ez-sb-case-erector-with-bottom-sealer","meta_keyword-packaging_tape":"Combi 2-EZ SB Case Erector & Bottom Sealer","description-packaging_tape":"<p>The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. The 2-EZ SB can process a wide variety of case sizes. The case blank is vertically positioned in the walk-in magazine. Easily load the cases, which are then extracted from the magazine and formed by a squaring arm. After the minor and flaps are formed, the cases are transferred into the dual belt drives where they are bottom sealed with 2\" tape. Combi's 2-EZ case erectors are designed for the most demanding environments with ultimate durability and reliability.<\/p>\r\n<h3>Features<\/h3>\r\n<ul>\r\n<li>Forms and bottom seals up to 15 cases per minute<\/li>\r\n<li>Accepts a range of box sizes: 8\" to 24\" length, 6\" to 16\" width, and 5\" to 18\" height<\/li>\r\n<li>EZ-load walk-in powered case magazine (150 case capacity)<\/li>\r\n<li>Dual belt drives<\/li>\r\n<li>Pneumatic carriage assembly<\/li>\r\n<li>3M Accuglide II 2\" tape head<\/li>\r\n<li>Control panel provides production &amp; diagnostic feedback<\/li>\r\n<li>\u201cNo tool\u201d changeover system<\/li>\r\n<li>Left or right hand operation<\/li>\r\n<li>Self-cleaning vacuum system<\/li>\r\n<li>Heavy-duty welded steel construction<\/li>\r\n<li>Optional add-ons and custom configurations are available<\/li>\r\n<\/ul>","short_description-packaging_tape":"<ul>\r\n<li>Processes up to 15 cases per minute<\/li>\r\n<li>Walk-in powered case magazine<\/li>\r\n<\/ul>","cstore-packaging_tape":{"50-350":"3 years","50-416":["New"],"50-316":["Case Erector"],"50-325":"0","50-326":"0","50-370":"EA","50-404":"Sides","50-393":"Automatic","50-412":"18\"","50-374":"0","50-366":"Combi Packaging Systems LLC","50-411":"24\"","50-410":"16\"","50-409":"5\"","50-408":"8\"","50-407":"6\"","50-405":"15 cases\/min","50-402":"2\" - Standard","50-379":"0","50-365":"Combi Packaging System LLC","50-369":"EA","50-339":"0","50-343":"0","50-321":"Yes","50-344":"Yes","50-353":"Yes","50-364":"V100135","50-355":"0","50-384":"1","50-385":"10000","50-327":"Use config","50-345":"8' 10.5\" L x 9' 7\" W x 6' 7.375\" H","50-367":"2-EZ-SB-15","50-363":"2000"},"status-packaging_tape":"1","visibility-packaging_tape":"4","name-packaging_tape":"Combi 2-EZ SB Case Erector & Taper","meta_title-packaging_tape":"Combi 2EZ SB Case Erector and Taper","meta_description-packaging_tape":"The Combi 2-EZ side belt drive case erector forms and bottom seals up to 15 cartons per minute. Walk-in powered case magazine. Standard 2\" tape head. Optional add-ons and custom configurations available.","options_container-packaging_tape":"container1","url_key-packaging_tape":"combi-2ez-sb-case-erector-with-bottom-sealer"}

Actual Behavior

the issue occurred while executing a query and resulted in a deadlock error (SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction).

Expected Behavior

It should be able to save the objects

[dpfaffenbauer]

@abdelrhmanyosry maybe this solves it: #16482