UPSTREAM FIX

magento2-38316: Hanging catalog_product_entity_int selects when reindexing large catalogs

Community fix magento2-38316 merged into magento/magento2 on 2025-04-25, released in 2.4.9; applies cleanly to 33 releases from 2.4.6 to 2.4.8-p5.

Fixes hanging catalog_product_entity_int selects when reindexing large catalogs edited

Pull request title: Missing indexing of required columns in catalog_product_entity_int table
Pull request: magento/magento2#38316
Issues: #38315 human
Author: @rostilos
Merged: 2025-04-25
Fixed in: 2.4.9
Reported on: 2.4.6
Categories: Catalog/Product
Components: magento/module-catalog

Labels

Area: Catalog
Component: —
Priority: P2
Severity: —
Reported on (labels): 2.4.6

Issue

Title and steps come from the upstream issue and pull request.

Description

Reindexing is not happening. Indexes are created in elasticsearch, but the data does not get into them

Steps to reproduce

1. A relatively large catalog is needed.
In a test environment, it is reproduced on a test catalog generated with the
bin/magento setup:perf:generate-fixtures setup/performance-toolkit/profiles/ce/extra_large.xml
2. Start the reindex process
bin/magento indexer:reset
bin/magento indexer:reindex catalogsearch_fulltext

Expected result

Reindexing is successful, there are docs in elasticsearch/opensearch indexes

Actual result

Reindexing is not happening. Indexes are created in elasticsearch, but the data does not get into them

Taken from the upstream issue.

Code match per tag

Each tag was checked with git apply --check against that tag's files. A clean match means the change applies; it is not a test result. Tags that already contain the fix are marked.

Line	Code match per tag	Tests
2.4.6	2.4.6 clean 2.4.6-p1 clean 2.4.6-p2 clean 2.4.6-p3 clean 2.4.6-p4 clean 2.4.6-p5 clean 2.4.6-p6 clean 2.4.6-p7 clean 2.4.6-p8 clean 2.4.6-p9 clean 2.4.6-p10 clean 2.4.6-p11 clean 2.4.6-p12 clean 2.4.6-p13 clean 2.4.6-p14 clean 2.4.6-p15 clean	2.4.6: no test data 2.4.6-p1: no test data 2.4.6-p2: no test data 2.4.6-p3: no test data 2.4.6-p4: no test data 2.4.6-p5: no test data 2.4.6-p6: no test data 2.4.6-p7: no test data 2.4.6-p8: no test data 2.4.6-p9: no test data 2.4.6-p10: no test data 2.4.6-p11: no test data 2.4.6-p12: no test data 2.4.6-p13: no test data 2.4.6-p14: no test data 2.4.6-p15: no test data
2.4.7	2.4.7 clean 2.4.7-p1 clean 2.4.7-p2 clean 2.4.7-p3 clean 2.4.7-p4 clean 2.4.7-p5 clean 2.4.7-p6 clean 2.4.7-p7 clean 2.4.7-p8 clean 2.4.7-p9 clean 2.4.7-p10 clean	2.4.7: no test data 2.4.7-p1: no test data 2.4.7-p2: no test data 2.4.7-p3: no test data 2.4.7-p4: no test data 2.4.7-p5: no test data 2.4.7-p6: no test data 2.4.7-p7: no test data 2.4.7-p8: no test data 2.4.7-p9: no test data 2.4.7-p10: no test data
2.4.8	2.4.8 clean 2.4.8-p1 clean 2.4.8-p2 clean 2.4.8-p3 clean 2.4.8-p4 clean 2.4.8-p5 clean	2.4.8: no test data 2.4.8-p1: no test data 2.4.8-p2: no test data 2.4.8-p3: no test data 2.4.8-p4: no test data 2.4.8-p5: no test data
2.4.9	2.4.9 conflictcontains the fix	2.4.9: no test data

Triage

Model @cf/cloudflare/clef. Probability this is a bug fix: 97.5%. Probability it is security relevant: 0.6%.

Show the model's answers and probabilities

Question	Answer	Probabilities	Confidence
Change kind	bugfix	bugfix 91.6%, refactor 2.4%, feature 2.2%, dependency 1.4%, tests_only 1.3%, docs_only 1.1%	80.9%
Area	catalog	catalog 85.1%, framework 5.7%, admin 2.8%	69.1%
Reported version	2.4.6	2.4.6 59.1%, 2.4.6-p1 2.6%, 2.4.6-p6 1.7%	34.4%
Scope	0.28 of 2	0 77.9%, 1 16.6%, 2 5.5%	45.6%
Risk	1.44 of 2	2 68.7%, 0 24.6%, 1 6.8%	30.5%
Worth backporting	1.67 of 2	2 73.6%, 1 20.1%, 0 6.3%	38.0%

Download

For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-38316/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Test files are always removed; paths are relative to each package root, using the default -p1 level.

Bundle README (what the ZIP ships)

# magento2-38316

Community fix merged upstream into magento/magento2, adapted by magento.watch.
This is not a patch published by Adobe.

Pull request: https://github.com/magento/magento2/pull/38316
Issue: https://github.com/magento/magento2/issues/38315
Author: @rostilos
Source commit: b83f427ed15913e06e59d1957f15ed9fc54a5093
Modifications: test files and documentation removed, paths rewritten relative to each Composer package.
Licence: OSL-3.0 / AFL-3.0, as the original Magento Open Source code.
Maintainer: Łukasz Bajsarowicz (@lbajsarowicz)

Licence: Magento Open Source code under OSL-3.0 and AFL-3.0. The bundle carries the original author, source commit and the list of modifications.