ÃÛ¶¹ÊÓƵ

DocumentationCommerceTools

[PaaS only]{class="badge informative" title="Applies to ÃÛ¶¹ÊÓƵ Commerce on Cloud projects (ÃÛ¶¹ÊÓƵ-managed PaaS infrastructure) and on-premises projects only."}

ACSD-66404: Cron job fails to clear changelog tables due to Galera Cluster transaction size limits

Last update: Mon Aug 18 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-66404 patch fixes the issue where the cron job fails to clear changelog tables, causing Galera Cluster issues when handling large amounts of data. This patch is available when the Quality Patches Tool (QPT) 1.1.69 is installed. The patch ID is ACSD-66404. Please note that this issue is scheduled to be fixed in ÃÛ¶¹ÊÓƵ Commerce 2.4.9.

Affected products and versions

The patch is created for ÃÛ¶¹ÊÓƵ Commerce version:

  • ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.6-p6, 2.4.7-p6

Compatible with ÃÛ¶¹ÊÓƵ Commerce versions:

  • ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.4 - 2.4.8-p1
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your ÃÛ¶¹ÊÓƵ Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

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.
  2. Perform a bulk update for all the products in the system, so there are a lot of entries in inventory_cl DB table.
  3. Run the indexer_clean_all_changelogs cron job.

Expected results:

The indexer_clean_all_changelogs cron job is able to perform changelog cleanup on large changelog (10+ GB) in multiple delete queries, without causing Galera Cluster issues.

Actual results:

The indexer_clean_all_changelogs cron job performs changelog cleanup on large changelog (10+ GB) in a single delete query, causing Galera Cluster issues.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3