DocumentationTools

ACP2E-4732: Partial indexation stops for customers with many updates when the version_id column in the changelog table reaches its maximum value

Last update: May 14, 2026

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACP2E-4732 patch fixes the issue where partial indexation stops for customers with a large number of updates when the version_id column in the changelog table reaches its maximum value. This patch is available when the Quality Patches Tool (QPT) 1.1.78 is installed. The patch ID is ACP2E-4732. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.9.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.7-p8

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.4 - 2.4.7-p9
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

Partial indexation stops for customers with a large number of updates after the version_id column in the changelog table reaches its maximum value.

Prerequisites:

  1. The instance runs in production mode.
  2. Indexers are set to the Update on Schedule mode.

Steps to reproduce:

  1. Create a product and update it 4,294,967,295 times (the maximum unsigned integer value in MySQL).
  2. Update the product one additional time.

Expected results:

  1. All updates are synchronized correctly when using the Update on Schedule mode.

Actual results:

  1. Products are not displayed on the Storefront.
  2. The catalog_product_index_price table does not contain price entries for these products.

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
commerce-operations-help-tools