Adobe Summit is here.

Experience keynotes, Sneaks, sessions, and more — all on demand.

Watch now
DocumentationCommerceTools

ACSD-63572: catalogrule indexer temporary tables are not cleaned if the indexer process is terminated

Last update: March 6, 2025
  • Topics:
  • System

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-63572 patch fixes the issue where the indexer temporary tables aren’t cleaned up when the process was terminated due to a system/upgrade or halt in CLI. This patch is available when the Quality Patches Tool (QPT) 1.1.58 is installed. The patch ID is ACSD-63572. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.8.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.6-p8

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.5 - 2.4.7-p3
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe 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

Indexer temporary tables aren’t cleaned up when the process was terminated due to a system upgrade or halt in CLI.

Steps to reproduce:

  1. Open CLI.

  2. Run command: bin/magento indexer:reindex catalogrule_rule.

  3. Cancel the process before it is finished using: ^C.

  4. Reset indexers using: bin/magento indexer:reset catalogrule_rule catalogrule_product.

  5. Repeat the previous steps several times.

  6. Check for the following temporary tables that have been created in the database:

    catalogrule_product__temp*
catalogrule_product_price__temp*

Expected results:

The old temporary tables are deleted when they aren’t needed.

Actual results:

The old temporary tables aren’t removed.

Apply the patch

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

  • Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
  • Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.

Related reading

To learn more about Quality Patches Tool, refer to:

  • Quality Patches Tool: A self-service tool for quality patches in the Tools guide.
recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3