The MDVA-21095 Magento patch fixes the issue when a query
INSERT INTO "search_tmp..." never ends after a mass attribute update.
This patch is available when the Quality Patches Tool (QPT) 1.0.20 is installed. The patch ID is MDVA-21095. Please note that there is no current plan to fix this issue in future versions.
Affected products and versions
The patch is created for Magento version: Magento Commerce Cloud 2.3.2
Compatible with Magento versions: Magento Commerce and Magneto Commerce Cloud 2.3.0-2.3.4-p2
Note: the patch might become applicable to other versions with new QPT tool releases. To check if the patch is compatible with your Magento version, run
./vendor/bin/magento-patches status .
Step to reproduce :
Perform a mass attribute values update with ~30,000 items.
Expected results :
The reindex process completes normally, as expected.
Actual results :
The reindex process completes, but a lot of queries
INSERT INTO “search_tmp…” start until the server reaches the
pm.max_children parameter value and PHP-fpm dies, and these constantly reoccur even after MySQL restart and process kill.
Apply the patch
To apply individual patches use the following links depending on your Magento product:
- Magento Commerce: DevDocs Software Update Guide > Apply Patches .
- Magento Commerce Cloud: DevDocs Upgrades and Patches > Apply Patches .
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool released: a new tool to self-serve quality patches .
- Check patch for Magento issue with Quality Patches Tool .
For info about other patches available in QPT tool, refer to the Patches available in QPT tool section.