ACSD-63139: Product export fails when product attributes contain thousands of option values
The ACSD-63139 patch fixes the issue where product export fails when product attributes contain thousands of option values. This patch is available when the Quality Patches Tool (QPT) 1.1.64 is installed. The patch ID is ACSD-63139. Please note that this 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.6 - 2.4.6-p10
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 product export fails when product attributes contain thousands of option values.
Steps to reproduce:
- Install Adobe Commerce with the B2B module.
- Import a large database dump with:
- ~7,000 products
- ~450 product attributes
- Some attributes having more than 100 options - Run the following command to install cron (if not already installed):
bin/magento cron:install
- Configure RabbitMQ by following the instructions in RabbitMQ prerequisites.
- Open the
php.inifile, set the memory limit to 4G, and restart the PHP service. - In the Admin Panel, go to System > Data Transfer > Export.
- In the Export Settings section, set Entity Type to Products, scroll to the bottom and click Continue.
- Run the following command to start the export processor:
bin/magento queue:consumers:start exportProcessor --max-messages=1
Expected results:
The product export should be finished successfully.
Actual results:
The product export process fails and returns the following fatal error:
Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 12288 bytes) in /var/www/html/app/code/Magento/Catalog/Model/ResourceModel/Product/Collection.php on line 597
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.