ACSD-53750: Broken pipe or closed connection error during multi-threaded catalog_product_price reindex

The ACSD-53750 patch fixes the issue where a Broken pipe or closed connection error occurs during multi-threaded catalog_product_price reindex. This patch is available when the Quality Patches Tool (QPT) 1.1.37 is installed. The patch ID is ACSD-53750. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.7.

Affected products and versions

The patch is created for Adobe Commerce version:

• Adobe Commerce (all deployment methods) 2.4.6-p1

Compatible with Adobe Commerce versions:

• Adobe Commerce (all deployment methods) 2.4.4 - 2.4.6-p2

Issue

Broken pipe or closed connection error occurs during multi-threaded catalog_product_price reindex.

Steps to reproduce:

1. Configure RabbitMq.

2. Generate sample data using the attached small.xml file.

3. Go to Stores > Config > Catalog > Inventory > Inventory Indexer Setting and set Stock/Source reindex strategy = Asynchronous.

4. Set the dimension mode for indexes which support that. E.g., catalog_product_price_website_and_customer_group or customer_group.

   bin/magento indexer:set-dimensions-mode catalog_product_price customer_group
   

5. Run reset of indexers for catalog_product_price.

   bin/magento indexer:reset catalog_product_price
   

6. Run the indexer for the reset indexer using multiple threads.

   MAGE_INDEXER_THREADS_COUNT=10 bin/magento indexer:reindex catalog_product_price
   

Expected results:

No errors occur.

Actual results:

The following error is caused by an AMQP connection: Broken pipe or closed connection.

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 released: a new tool to self-serve quality patches in our support knowledge base.
• Check if patch is available for your Adobe Commerce issue using Quality Patches Tool in our support knowledge base.

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.