This page has moved to Adobe Experience League and will be redirected soon.
MDVA-21095: INSERT INTO "search_tmp..." never ends after mass attribute update
MDVA-21095: INSERT INTO "search_tmp..." never ends after mass attribute update
The MDVA-21095 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 Adobe Commerce version:
Adobe Commerce on cloud infrastructure 2.3.2
Compatible with Adobe Commerce versions:
Adobe Commerce (all deployment methods) 2.3.0 - 2.3.4-p2
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 [!DNL Quality Patches Tool]: Search for patches page. Use the patch ID as a search keyword to locate the patch.
Issue
INSERT INTO "search_tmp..." never ends after a mass attribute update.
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 deployment method:
To learn more about Quality Patches Tool, refer to:
For info about other patches available in QPT, refer to Patches available in QPT in our developer documentation.