QUALITY PATCH

ACSD-68064: Creating scheduled updates in environments with a high number of nested categories…

Creating scheduled updates in environments with a high number of nested categories results in duplicate entries, leading to errors and failure to save the category. Quality patch ACSD-68064 for magento/module-catalog applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.7-p10.

Categories: Admin, Performance
Components: magento/module-catalog
Origin: adobe-commerce-support
Since QPT: 1.1.72

Issue

Creating scheduled updates in environments with a high number of nested categories results in duplicate entries, leading to errors and failure to save the category.

Steps to reproduce

1. Install a clean instance. 1. Modify the performance fixtures file (small.xml) to include: 1. Categories: 2500 1. Products: 250,000 1. Generate the data using the command: bin/magento setup:performance:generate-fixtures var/performance-toolkit/profiles/ce/small.xml 1. After creating products and categories, ensure all categories are set as anchors by running the following query: UPDATE catalog_category_entity_int set value = 1 where attribute_id = (select attribute_id from eav_attribute where attribute_code = 'is_anchor'); 1. Reindex the data. 1. Log in to the Admin panel and navigate to Catalog > Categories. 1. Move Category 2 under Category 1to create a more nested structure. 1. Go to a deeply nested category, for example, Category 2.1.1. 1. Create a Scheduled Update. 1. Click Save.

Adobe's page lists 2.4.7 - 2.4.7-p7 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 ACSD-68064. On Cloud, add ACSD-68064 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-68064/ 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/ACSD-68064_2.4.7-p6.patch

vendor/magento/module-catalog/Model/ResourceModel/Category/Collection.php