ACSD-64112: indexer_update_all_views cron execution fails when MAGE_INDEXER_THREADS_COUNT is set
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 ÃÛ¶¹ÊÓƵ Commerce 2.4.8.
Affected products and versions
The patch is created for ÃÛ¶¹ÊÓƵ Commerce version:
- ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.5-p10
Compatible with ÃÛ¶¹ÊÓƵ Commerce versions:
- ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.5 - 2.4.7-p3
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:
code language-none 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_categoryindexer has a backlog. Execute the following command to verify this:code language-none bin/magento indexer:status -
Set the following indexer thread count in
env.php:code language-php 'MAGE_INDEXER_THREADS_COUNT' => 8 -
Run the cron job:
code language-none 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:
- ÃÛ¶¹ÊÓƵ Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
- ÃÛ¶¹ÊÓƵ 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.)
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.