ACP2E-4894: Issue where new orders appear with a delay in the Admin order management grids…
Issue where new orders appear with a delay in the Admin order management grids when asynchronous indexing is enabled on high-volume stores. Quality patch ACP2E-4894 for magento/module-sales applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.8-p5.
- Categories
- Order/Checkout, Performance
- Components
- magento/module-sales, magento/module-sales-archive
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.82
Issue
Issue where new orders appear with a delay in the Admin order management grids when asynchronous indexing is enabled on high-volume stores.
Steps to reproduce
1. Enable asynchronous indexing by running bin/magento config:set dev/grid/async_indexing 1. 1. Create 50000 orders that are missing from sales_order_grid. 1. Run bin/magento cron:run until sales_grid_order_async_insert processes the backlog and sales_grid_async_last_entity_id_sales_order_grid reaches the latest order entity_id. 1. Verify that sales_grid_async_last_entity_id_sales_order_grid matches the highest processed entity_id. 1. Run bin/magento cron:run again after the backlog is cleared. 1. Verify whether sales_grid_async_last_entity_id_sales_order_grid resets to 10000. 1. Place a new order on the storefront. 1. Run bin/magento cron:run again to trigger sales_grid_order_async_insert. 1. Log in to the Admin and navigate to Sales > Orders.
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-4894. On Cloud, add ACP2E-4894 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-4894/ 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-4894_2.4.8-p4.patch
- vendor/magento/module-sales/Model/GridAsyncInsert.php
- vendor/magento/module-sales/Model/ResourceModel/Grid.php
- vendor/magento/module-sales/Model/ResourceModel/Provider/Query/IdListBuilder.php
- vendor/magento/module-sales/Model/ResourceModel/Provider/UpdatedIdListProvider.php
- vendor/magento/module-sales/etc/di.xml
magento/magento2-ee-base >=2.4.7 <2.4.9
- Magento Open Source
- —
- vendor/magento/module-sales-archive/Plugin/ArchivedEntitiesProcessorPlugin.php
