ACSD-64112: `indexer_update_all_views` cron execution fails when `MAGE_INDEXER_THREADS_COUNT` is set

Last update: February 24, 2025

CREATED FOR:

Experienced
Admin
Developer

The ACSD-64112 patch fixes the issue where the indexer_update_all_views cron execution fails when MAGE_INDEXER_THREADS_COUNT is set. This patch is available when the Quality Patches Tool (QPT) 1.1.59 is installed. The patch ID is ACSD-64112. 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.5-p10

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

The indexer_update_all_views cron execution fails when MAGE_INDEXER_THREADS_COUNT is set to a value greater than 2, specifically affecting the Customer Segments indexer with B2B enabled.

Steps to reproduce:

Install a clean instance with B2B.
Enable B2B Company and Shared Catalog.
Create a category.
Create a few products and assign them to the category.
Execute a full reindex.

Set the following indexers to Update on Schedule:

bin/magento indexer:set-mode schedule catalogpermissions_category catalogpermissions_product

Go to the backend and load the newly created category.
Click Category Permissions and create a New Permission for an existing customer group.
Ensure the catalogpermissions_category indexer has a backlog. Execute the following command to verify this:
bin/magento indexer:status
Set the following indexer thread count in env.php:
'MAGE_INDEXER_THREADS_COUNT' => 8
Run the cron job:
bin/magento cron:run

Expected results:

The cron job should execute without any issues.

Actual results:

The indexer_update_all_views cron job encounters the following error:

report.CRITICAL: PDOException: There is no active transaction in /home/vendor/magento/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php:326

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.

Additional steps required after the patch installation

(This section is optional; there might be some steps required after applying the patch to fix the issue.)

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