{"data":{"id":"ACSD-67643","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where duplicate entries are created during scheduled updates in environments with a high number of nested categories.","categories":["Catalog/Product"],"components":["magento/module-catalog"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-71/acsd-67643","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-71/acsd-67643.md","blobSha":"f2a2ee6e112d76d06565a441c3edac9bb600c525","description":"Duplicate entries occur when creating scheduled updates for environments that have a large number of nested categories.","stepsToReproduce":"1. Generate sample data: Use a performance fixtures file (For example: small.xml) with modifications: Categories: 2,500 Products: 250,000 1. Run the following command: bin/magento setup:performance:generate-fixtures var/performance-toolkit/profiles/ce/small.xml 1. After creating products and categories, ensure all categories are anchors by running: UPDATE catalog_category_entity_int SET value = 1 WHERE attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'is_anchor'); 1. Run a full reindex. 1. Log into the backend and open the Categories page. 1. Move Category 2 to Category 1 to increase tree nesting. 1. Go to the most nested category (For example: Category 2.1.1). 1. Create a Scheduled Update and save the category.","introducedInQpt":"1.1.71","createdFor":["2.4.8-p1"],"documentedRange":"2.4.8 - 2.4.8-p2","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.8 <2.4.9","path":"patches/os/ACSD-67643_2.4.8-p1.patch","blobSha":"ba56bc6dadfb52a6f8874f597b6b9254abf7eb0d","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-67643_2.4.8-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog/Model/ResourceModel/Category/Collection.php","change":"modified","package":"magento/module-catalog"}],"packages":["magento/module-catalog"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":"ACP2E-5205","deprecated":false}],"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/exception.log","match":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*' for key 'temp_category_descendants_*', query was: INSERT INTO `temp_category_descendants_*` (`category_id`, `descendant_id`)"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-67643 details"}