QUALITY PATCH

MDVA-21095: A query INSERT INTO search_tmp will not end after mass attribute value update

A query INSERT INTO search_tmp will not end after mass attribute value update. Quality patch MDVA-21095 for magento/module-catalog-search applies to Magento Open Source and Adobe Commerce 2.3.0 to 2.3.4-p2.

Categories
Performance
Components
magento/module-catalog-search
Origin
adobe-commerce-support

No Adobe documentation page exists for this patch.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply MDVA-21095. On Cloud, add MDVA-21095 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-21095/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Packages across compatible versions (1): magento/module-catalog-search
Packages across compatible versions (1): magento/module-catalog-search

magento/magento2-base >=2.3.0 <2.3.5

Magento Open Source
2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2, 2.3.1, 2.3.0
Adobe Commerce
2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2, 2.3.1, 2.3.0
Patch file
patches/os/MDVA-21095_2.3.2.patch
  • vendor/magento/module-catalog-search/Model/Adapter/Mysql/BaseSelectStrategy/BaseSelectAttributesSearchStrategy.php
  • vendor/magento/module-catalog-search/Model/Search/FilterMapper/CustomAttributeFilter.php
  • vendor/magento/module-catalog-search/Model/Search/FilterMapper/FilterMapper.php
  • vendor/magento/module-catalog-search/Model/Search/FilterMapper/StockStatusFilter.php

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.