QUALITY PATCH

ACSD-66404: Cron job not clearing changelog tables and causing Galera Cluster issues in case of large…

Cron job not clearing changelog tables and causing Galera Cluster issues in case of large amount of data in these tables. Quality patch ACSD-66404 for magento/framework applies to Magento Open Source and Adobe Commerce 2.4.4 to 2.4.8-p5.

Categories
Cron
Components
magento/framework, magento/module-indexer, magento/module-theme, setup/src
Origin
adobe-commerce-support
Since QPT
1.1.69

Issue

Cron job not clearing changelog tables and causing Galera Cluster issues in case of large amount of data in these tables.

Steps to reproduce

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.

Adobe's page lists 2.4.4 - 2.4.8-p1 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.

Additional steps

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.

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-66404. On Cloud, add ACSD-66404 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-66404/ 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

Packages across compatible versions (4): magento/module-indexer, magento/framework, magento/module-theme, magento/magento2-base
Packages across compatible versions (4): magento/module-indexer, magento/framework, magento/module-theme, magento/magento2-base

magento/magento2-base >=2.4.4 <2.4.4-p18 || >=2.4.5 <2.4.5-p17 || >=2.4.6 <2.4.6-p15

Magento Open Source
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
Adobe 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
Requires
ACSD-53583
Patch file
patches/os/ACSD-66755_2.4.6-p6.patch
  • vendor/magento/module-indexer/etc/crontab.xml
  • vendor/magento/framework/Mview/View/Changelog.php

magento/magento2-base >=2.4.7 <2.4.7-p6

Magento Open Source
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-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
Replaced with
ACSD-69086
Patch file
patches/os/ACSD-66404_2.4.7-p6.patch
  • vendor/magento/module-indexer/etc/crontab.xml
  • vendor/magento/framework/Mview/View/Changelog.php

magento/magento2-base >=2.4.7-p6 <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
Adobe Commerce
2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6
Replaced with
ACSD-69086
Patch file
patches/os/ACSD-68075_2.4.7-p7.patch
  • vendor/magento/module-indexer/etc/crontab.xml
  • vendor/magento/module-theme/Model/Indexer/Design/IndexerHandler.php
  • vendor/magento/framework/DB/Adapter/Pdo/Mysql.php
  • vendor/magento/framework/DB/Ddl/Table.php
  • vendor/magento/framework/Mview/View/Changelog.php
  • vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php
  • vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaWriter.php
  • vendor/magento/framework/Setup/Declaration/Schema/Dto/Columns/StringBinary.php
  • vendor/magento/framework/Setup/Declaration/Schema/Dto/Columns/Text.php
  • vendor/magento/framework/Setup/Declaration/Schema/Dto/Factories/Table.php
  • setup/src/Magento/Setup/Model/Installer.php

magento/magento2-base >=2.4.8 <2.4.9

Magento Open Source
2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8
Adobe Commerce
2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8
Patch file
patches/os/ACSD-66404_2.4.7-p6.patch
  • vendor/magento/module-indexer/etc/crontab.xml
  • vendor/magento/framework/Mview/View/Changelog.php

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.

Work with me Sponsor on GitHub