QUALITY PATCH

ACSD-51114: Random products disappeared from large catalogs when asynchronous indexing is enabled

Random products disappeared from large catalogs when asynchronous indexing is enabled. Quality patch ACSD-51114 for magento/framework applies to Magento Open Source and Adobe Commerce 2.4.3 to 2.4.6-p15.

Categories: Catalog/Product, Performance
Components: magento/framework, magento/module-eav
Origin: adobe-commerce-support
Since QPT: 1.1.30

Issue

Random products disappeared from large catalogs when asynchronous indexing is enabled.

Steps to reproduce

1. Create a set of 10 products. 1. Set all indexers to Update on Save mode. 1. Create a category and assign all products to it. 1. Disable all products. 1. Open the category and verify that there are no products there. 1. Set all indexers to Update on Schedule mode. 1. Set the DEFAULT_BATCH_SIZE to 2 in lib/internal/Magento/Framework/Mview/View.php#L31. 1. Enable products in the following order: 1st, 9th, 2nd, 5th, 10th, 3rd. 1. Run cron command. 1. Open the category again.

Adobe's page lists 2.4.3 - 2.4.6 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.7.

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

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-51114/ 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.3 <2.4.7 deprecated

Magento Open Source: 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6, 2.4.5-p17, 2.4.5-p16, 2.4.5-p15, 2.4.5-p14, 2.4.5-p13, 2.4.5-p12, 2.4.5-p11, 2.4.5-p10, 2.4.5-p9, 2.4.5-p8, 2.4.5-p7, 2.4.5-p6, 2.4.5-p5, 2.4.5-p4, 2.4.5-p3, 2.4.5-p2, 2.4.5-p1, 2.4.5, 2.4.4-p18, 2.4.4-p17, 2.4.4-p16, 2.4.4-p15, 2.4.4-p14, 2.4.4-p13, 2.4.4-p12, 2.4.4-p11, 2.4.4-p10, 2.4.4-p9, 2.4.4-p8, 2.4.4-p7, 2.4.4-p6, 2.4.4-p5, 2.4.4-p4, 2.4.4-p3, 2.4.4-p2, 2.4.4-p1, 2.4.4, 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3
Adobe Commerce: 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6, 2.4.5-p17, 2.4.5-p16, 2.4.5-p15, 2.4.5-p14, 2.4.5-p13, 2.4.5-p12, 2.4.5-p11, 2.4.5-p10, 2.4.5-p9, 2.4.5-p8, 2.4.5-p7, 2.4.5-p6, 2.4.5-p5, 2.4.5-p4, 2.4.5-p3, 2.4.5-p2, 2.4.5-p1, 2.4.5, 2.4.4-p18, 2.4.4-p17, 2.4.4-p16, 2.4.4-p15, 2.4.4-p14, 2.4.4-p13, 2.4.4-p12, 2.4.4-p11, 2.4.4-p10, 2.4.4-p9, 2.4.4-p8, 2.4.4-p7, 2.4.4-p6, 2.4.4-p5, 2.4.4-p4, 2.4.4-p3, 2.4.4-p2, 2.4.4-p1, 2.4.4, 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3
Patch file: patches/os/ACSD-51114_2.4.3-p2.patch

vendor/magento/module-eav/Model/Mview/ChangeLogBatchWalker.php
vendor/magento/framework/Mview/View.php
vendor/magento/framework/Mview/View/ChangeLogBatchWalker.php
vendor/magento/framework/Mview/View/ChangeLogDuplicateCleaner.php (added)