{"data":{"id":"MDVA-38852","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where the catalog inventory by design locks tables for updates that significantly decrease performance in cases with several parallel orders.","categories":["Performance"],"components":["magento/module-catalog-inventory","magento/module-customer","magento/module-eav","magento/module-customer-custom-attributes"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-2/mdva-38852-catalog-inventory-locks-tables-for-updates-that-significantly-decrease-performance","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-2/mdva-38852-catalog-inventory-locks-tables-for-updates-that-significantly-decrease-performance.md","blobSha":"ea0aa41db10b3a70958b3c782ff0ad266a7d5813","description":"Catalog inventory locks tables for updates which significantly decreases performance in cases when several parallel orders are placed.","stepsToReproduce":"1. Add a product to the cart. 1. Proceed to checkout and try to place an order.","introducedInQpt":"1.1.2","createdFor":["2.3.3"],"documentedRange":"2.3.0 - 2.3.5-p2","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.3.0 <=2.3.5-p2","path":"patches/os/MDVA-38852_2.3.3.patch","blobSha":"80a5f4a079609448c6a04079f9813aa7f82b0d0e","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-38852_2.3.3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-inventory/Model/ResourceModel/Stock.php","change":"modified","package":"magento/module-catalog-inventory"},{"path":"vendor/magento/module-catalog-inventory/etc/db_schema.xml","change":"modified","package":"magento/module-catalog-inventory"},{"path":"vendor/magento/module-catalog-inventory/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-catalog-inventory"},{"path":"vendor/magento/module-customer/etc/db_schema.xml","change":"modified","package":"magento/module-customer"},{"path":"vendor/magento/module-customer/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-customer"},{"path":"vendor/magento/module-eav/Model/ResourceModel/Entity/Attribute.php","change":"modified","package":"magento/module-eav"},{"path":"vendor/magento/module-eav/etc/db_schema.xml","change":"modified","package":"magento/module-eav"},{"path":"vendor/magento/module-eav/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-eav"}],"packages":["magento/module-catalog-inventory","magento/module-customer","magento/module-eav"],"hasTests":false,"applicableVersions":{"magento-community":["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"],"magento-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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-ee-base","constraint":">=2.3.0 <=2.3.5-p2","path":"patches/commerce/MDVA-38852_2.3.3.patch","blobSha":"a4a0695719f6d835722792dbaa918b449d5fd904","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/MDVA-38852_2.3.3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-customer-custom-attributes/Model/ResourceModel/Sales/AbstractSales.php","change":"modified","package":"magento/module-customer-custom-attributes"}],"packages":["magento/module-customer-custom-attributes"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["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"],"magento-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"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-38852 details"}