ACP2E-4695: Catalog rule indexer consumes excessive memory and fails to complete…
Catalog rule indexer consumes excessive memory and fails to complete, causing instability and out-of-memory errors. Quality patch ACP2E-4695 for magento/module-catalog applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.7-p10.
- Categories
- Catalog/Product, Performance
- Components
- magento/module-catalog, magento/module-catalog-rule, magento/module-catalog-rule-configurable, magento/module-catalog-search, magento/module-indexer
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.82
Issue
Catalog rule indexer consumes excessive memory and fails to complete, causing instability and out-of-memory errors.
Steps to reproduce
1. On the Admin sidebar, go to Stores > Attributes > Product. Edit each test attribute, set Scope to Website, and under Storefront Properties, set Use for Promo Rule Conditions to Yes. 1. On the Admin sidebar, go to Marketing > Promotions > Catalog Price Rules and click Add New Rule. 1. Create a catalog price rule that uses all of these attributes in the Conditions section. 1. Set the PHP memory limit to 1 GB. 1. Run bin/magento indexer:reindex catalogrule_rule.
Adobe's page lists 2.4.7 - 2.4.7-p10 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.9.
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-4695. On Cloud, add ACP2E-4695 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-4695/ 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.8
- Magento Open Source
- 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.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-4695_2.4.7-p9.patch
- vendor/magento/module-catalog/Model/Indexer/Product/Full.php
- vendor/magento/module-catalog-rule/Model/Indexer/CatalogRuleInsertBatchSizeCalculator.php (added)
- vendor/magento/module-catalog-rule/Model/Indexer/CatalogRuleProductPriceRowSizeEstimator.php (added)
- vendor/magento/module-catalog-rule/Model/Indexer/DynamicBatchSizeCalculator.php (added)
- vendor/magento/module-catalog-rule/Model/Indexer/IndexBuilder.php
- vendor/magento/module-catalog-rule/Model/Indexer/ReindexRuleProduct.php
- vendor/magento/module-catalog-rule/Model/Indexer/Rule/GetAffectedProductIds.php (added)
- vendor/magento/module-catalog-rule/Model/Indexer/Rule/RuleProductIndexer.php
- vendor/magento/module-catalog-rule/Model/Indexer/Rule/RuleProductProcessor.php
- vendor/magento/module-catalog-rule/Model/ResourceModel/Product/AttributeValuesLoader.php (added)
- vendor/magento/module-catalog-rule/Model/ResourceModel/Product/Collection.php (added)
- vendor/magento/module-catalog-rule/Model/ResourceModel/Rule.php
- vendor/magento/module-catalog-rule/Model/ResourceModel/Rule/RuleIdProvider.php (added)
- vendor/magento/module-catalog-rule/Model/Rule.php
- vendor/magento/module-catalog-rule/etc/di.xml
- vendor/magento/module-catalog-rule-configurable/Plugin/CatalogRule/Model/Rule/ConfigurableProductHandler.php
- vendor/magento/module-catalog-search/etc/mview.xml
- vendor/magento/module-indexer/Model/Indexer.php
- vendor/magento/module-indexer/Model/Indexer/DependencyDecorator.php
