ACP2E-4913: Creating a shipment or an invoice through the REST API fails permanently…
Creating a shipment or an invoice through the REST API fails permanently when a database deadlock occurs because the operation is not retried. Quality patch ACP2E-4913 for app/etc applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.8-p5. Adobe lists the fix as scheduled for 2.4.10.
Source: Adobe Experience League
- Categories
- Admin, Order/Checkout
- Components
- app/etc, magento/framework, magento/module-developer, magento/module-sales
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.84
Issue
Creating a shipment or an invoice through the REST API fails permanently when a database deadlock occurs because the operation is not retried.
Steps to reproduce
1. Prepare several orders that can be shipped and several orders that can be invoiced. 1. Send several POST /rest/V1/order/<orderId>/ship requests in parallel for these orders, as an integration might under load. 1. Send several POST /rest/V1/order/<orderId>/invoice requests in parallel in the same way. 1. Check the API responses and var/log/exception.log.
Adobe's page lists 2.4.7 - 2.4.8-p5 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Adobe scheduled the permanent fix for 2.4.10.
Install
Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACP2E-4913. On Cloud, add ACP2E-4913 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACP2E-4913/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.
Patch files and compatible versions
magento/magento2-base >=2.4.7 <2.4.9
- Magento Open Source
- 2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8, 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
- Adobe Commerce
- 2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8, 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
- Patch file
- patches/os/ACP2E-4914_2.4.8-p3.patch
- vendor/magento/module-developer/Console/Command/QueryLogEnableCommand.php
- vendor/magento/module-sales/Model/OrderMutex.php
- app/etc/di.xml
- vendor/magento/framework/Config/ConfigOptionsListConstants.php
- vendor/magento/framework/DB/DeadlockRecoveryExecutor.php (added)
- vendor/magento/framework/DB/DeadlockRecoveryExecutorInterface.php (added)
- vendor/magento/framework/DB/Logger/File.php
- vendor/magento/framework/DB/Logger/LoggerAbstract.php
- vendor/magento/framework/DB/Logger/LoggerProxy.php
- vendor/magento/framework/DB/Logger/QueryAnalyzerException.php (added)
- vendor/magento/framework/DB/Logger/QueryAnalyzerInterface.php (added)
- vendor/magento/framework/DB/Logger/QueryIndexAnalyzer.php (added)
