QUALITY PATCH

MDVA-38852: Catalog inventory locks tables for updates which significantly decreases performance…

Catalog inventory locks tables for updates which significantly decreases performance in cases when several parallel orders are placed. Quality patch MDVA-38852 for magento/module-catalog-inventory applies to Magento Open Source and Adobe Commerce 2.3.0 to 2.3.5-p2.

Categories: Performance
Components: magento/module-catalog-inventory, magento/module-customer, magento/module-eav, magento/module-customer-custom-attributes
Origin: adobe-commerce-support
Since QPT: 1.1.2

Issue

Catalog inventory locks tables for updates which significantly decreases performance in cases when several parallel orders are placed.

Steps to reproduce

1. Add a product to the cart. 1. Proceed to checkout and try to place an order.

Adobe's page lists 2.3.0 - 2.3.5-p2 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

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 MDVA-38852. On Cloud, add MDVA-38852 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-38852/ 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.3.0 <=2.3.5-p2

Magento Open Source: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2, 2.3.1, 2.3.0
Adobe Commerce: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2, 2.3.1, 2.3.0
Patch file: patches/os/MDVA-38852_2.3.3.patch

vendor/magento/module-catalog-inventory/Model/ResourceModel/Stock.php
vendor/magento/module-catalog-inventory/etc/db_schema.xml
vendor/magento/module-catalog-inventory/etc/db_schema_whitelist.json
vendor/magento/module-customer/etc/db_schema.xml
vendor/magento/module-customer/etc/db_schema_whitelist.json
vendor/magento/module-eav/Model/ResourceModel/Entity/Attribute.php
vendor/magento/module-eav/etc/db_schema.xml
vendor/magento/module-eav/etc/db_schema_whitelist.json

magento/magento2-ee-base >=2.3.0 <=2.3.5-p2

Magento Open Source: —
Adobe Commerce: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2, 2.3.1, 2.3.0
Patch file: patches/commerce/MDVA-38852_2.3.3.patch

vendor/magento/module-customer-custom-attributes/Model/ResourceModel/Sales/AbstractSales.php