{"data":{"id":"ACSD-66404","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where the cron job fails to clear changelog tables, causing Galera Cluster crashes when handling large amounts of data.","categories":["Cron"],"components":["magento/framework","magento/module-indexer","magento/module-theme","setup/src"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-66404-cron-job-fails-to-clear-changelog-tables-due-to-galera-cluster-transaction-size-limits","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-66404-cron-job-fails-to-clear-changelog-tables-due-to-galera-cluster-transaction-size-limits.md","blobSha":"92f2503ad265800b718acaa6769cf1f2cf994271","description":"Cron job not clearing changelog tables and causing Galera Cluster issues in case of large amount of data in these tables.","stepsToReproduce":"1. Generate a lot of products using performance profiles. 1. Perform a bulk update for all the products in the system, so there are a lot of entries in inventory_cl DB table. 1. Run the indexer_clean_all_changelogs cron job.","introducedInQpt":"1.1.69","createdFor":["2.4.6-p6","2.4.7-p6"],"documentedRange":"2.4.4 - 2.4.8-p1","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.4 <2.4.4-p18 || >=2.4.5 <2.4.5-p17 || >=2.4.6 <2.4.6-p15","path":"patches/os/ACSD-66755_2.4.6-p6.patch","blobSha":"a83d051579c009f2f3180b48b8a388d98c49e0d6","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-66755_2.4.6-p6.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-indexer/etc/crontab.xml","change":"modified","package":"magento/module-indexer"},{"path":"vendor/magento/framework/Mview/View/Changelog.php","change":"modified","package":"magento/framework"}],"packages":["magento/module-indexer","magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["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-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-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"],"magento-commerce":["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-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-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"],"mage-os":[]},"unknownVersions":[],"requires":["ACSD-53583"],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.7 <2.4.7-p6","path":"patches/os/ACSD-66404_2.4.7-p6.patch","blobSha":"353210f57d2978dadcaf52fc76a4d56819c091e1","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-66404_2.4.7-p6.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-indexer/etc/crontab.xml","change":"modified","package":"magento/module-indexer"},{"path":"vendor/magento/framework/Mview/View/Changelog.php","change":"modified","package":"magento/framework"}],"packages":["magento/module-indexer","magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"magento-commerce":["2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":"ACSD-69086","deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.7-p6 <2.4.8","path":"patches/os/ACSD-68075_2.4.7-p7.patch","blobSha":"f7c87a2edea9da5c565ff11fc27e44f3a477820d","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-68075_2.4.7-p7.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-indexer/etc/crontab.xml","change":"modified","package":"magento/module-indexer"},{"path":"vendor/magento/module-theme/Model/Indexer/Design/IndexerHandler.php","change":"modified","package":"magento/module-theme"},{"path":"vendor/magento/framework/DB/Adapter/Pdo/Mysql.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/DB/Ddl/Table.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Mview/View/Changelog.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaWriter.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Setup/Declaration/Schema/Dto/Columns/StringBinary.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Setup/Declaration/Schema/Dto/Columns/Text.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Setup/Declaration/Schema/Dto/Factories/Table.php","change":"modified","package":"magento/framework"},{"path":"setup/src/Magento/Setup/Model/Installer.php","change":"modified","package":"magento/magento2-base"}],"packages":["magento/module-indexer","magento/module-theme","magento/framework","magento/magento2-base"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6"],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":"ACSD-69086","deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.8 <2.4.9","path":"patches/os/ACSD-66404_2.4.7-p6.patch","blobSha":"353210f57d2978dadcaf52fc76a4d56819c091e1","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-66404_2.4.7-p6.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-indexer/etc/crontab.xml","change":"modified","package":"magento/module-indexer"},{"path":"vendor/magento/framework/Mview/View/Changelog.php","change":"modified","package":"magento/framework"}],"packages":["magento/module-indexer","magento/framework"],"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":null,"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","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","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-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-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"],"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","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","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-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-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"],"mage-os":[]},"conditions":null,"requirements":"The patch depends on ACSD-53583. Do not install it on versions earlier than 2.4.7 if you are using Live Search. Refer to the KB article related to ACSD-53583 for more details."},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-66404 details"}