ACP2E-4894: New orders appear in the Admin Orders grid with a delay when asynchronous indexing is enabled
The ACP2E-4894 patch fixes the issue where new orders appear with a delay in the Admin Orders grid when asynchronous indexing is enabled. This patch is available when the Quality Patches Tool (QPT) 1.1.82 is installed. The patch ID is ACP2E-4894. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.10.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce (all deployment methods) 2.4.8-p4
Compatible with Adobe Commerce versions:
- Adobe Commerce (all deployment methods) 2.4.7 - 2.4.8-p5
magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.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:
- Enable asynchronous indexing by running
bin/magento config:set dev/grid/async_indexing 1. - Create 50000 orders that are missing from
sales_order_grid. - Run
bin/magento cron:rununtilsales_grid_order_async_insertprocesses the backlog andsales_grid_async_last_entity_id_sales_order_gridreaches the latest orderentity_id. - Verify that
sales_grid_async_last_entity_id_sales_order_gridmatches the highest processedentity_id. - Run
bin/magento cron:runagain after the backlog is cleared. - Verify whether
sales_grid_async_last_entity_id_sales_order_gridresets to 10000. - Place a new order on the storefront.
- Run
bin/magento cron:runagain to triggersales_grid_order_async_insert. - Log in to the Admin and navigate to Sales > Orders.
Expected results:
On the next cron run, new orders are added to the sales_order_grid table and appear in Admin > Sales > Orders.
Actual results:
- After the backlog clears,
sales_grid_async_last_entity_id_sales_order_gridresets to 10,000. - Subsequent cron runs restart from the lower cursor and repeatedly reprocess older ranges.
- Backlog processing is delayed because each cron run may insert only part of the missing data.
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide
- Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide