{"data":{"id":"magento2-38316","source":"github-pr","sourceRef":"magento/magento2#38316","title":"Missing indexing of required columns in catalog_product_entity_int table","pr":{"number":38316,"url":"https://github.com/magento/magento2/pull/38316","author":"rostilos","mergedAt":"2025-04-25T14:52:43Z","mergeCommit":"0ac260f64d529b7db82007fc407ee6ca94c87509","headCommit":"b83f427ed15913e06e59d1957f15ed9fc54a5093","baseRef":"2.4-develop","diffSha256":"a2e7435421dc713eae8a27add0be739d2d313ba220383ccea6b6d7cda4e78387"},"issues":[{"number":38315,"url":"https://github.com/magento/magento2/issues/38315","title":"Missing indexing of required columns in catalog_product_entity_int table","labels":["Area: Catalog","Issue: Confirmed","Priority: P2","Progress: PR in progress","Progress: done","Reported on 2.4.6","Reproduced on 2.4.x"],"kind":"human"}],"fixedIn":"2.4.9","containingTags":["2.4.9"],"reportedOn":"2.4.6","codeMatch":{"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.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.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.9":"conflict"},"affectedVersions":["2.4.6","2.4.6-p1","2.4.6-p2","2.4.6-p3","2.4.6-p4","2.4.6-p5","2.4.6-p6","2.4.6-p7","2.4.6-p8","2.4.6-p9","2.4.6-p10","2.4.6-p11","2.4.6-p12","2.4.6-p13","2.4.6-p14","2.4.6-p15","2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5","2.4.7-p6","2.4.7-p7","2.4.7-p8","2.4.7-p9","2.4.7-p10","2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5"],"components":["magento/module-catalog"],"files":[{"path":"app/code/Magento/Catalog/etc/db_schema.xml","change":"modified","package":"magento/module-catalog"},{"path":"app/code/Magento/Catalog/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-catalog"}],"stripped":{"tests":[],"docs":[],"outsideCode":[]},"linesChanged":5,"mergeBatched":false,"excluded":null,"sections":{"description":"Reindexing is not happening. Indexes are created in elasticsearch, but the data does not get into them","stepsToReproduce":"1. A relatively large catalog is needed.\nIn a test environment, it is reproduced on a test catalog generated with the \n`bin/magento setup:perf:generate-fixtures setup/performance-toolkit/profiles/ce/extra_large.xml`\n2. Start the reindex process \n`bin/magento indexer:reset`\n`bin/magento indexer:reindex catalogsearch_fulltext`","expectedResult":"Reindexing is successful, there are docs in elasticsearch/opensearch indexes","actualResult":"Reindexing is not happening. Indexes are created in elasticsearch, but the data does not get into them","source":"issue"},"signatures":[],"labels":{"area":["Catalog"],"component":[],"priority":"P2","severity":null,"reportedOn":["2.4.6"]},"categories":["Catalog/Product"],"triage":{"model":"@cf/cloudflare/clef","requestHash":"629db16644e3202b796d70c17b00cfcccd38bf39d8e2ba4fe7c1b7c4fe20d740","isBugfix":0.9737,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.8942,"feature":0.0219,"refactor":0.0236,"tests_only":0.0133,"docs_only":0.0102,"dependency":0.0122,"cleanup":0.0246},"confidence":0.7686},"scope":{"score":0.2929,"probabilities":{"0":0.7677,"1":0.1717,"2":0.0606},"confidence":0.4338},"risk":{"score":1.3898,"probabilities":{"0":0.2689,"1":0.0723,"2":0.6588},"confidence":0.2673},"area":{"choice":"catalog","probabilities":{"catalog":0.8356,"checkout":0.0144,"customer":0.0103,"admin":0.0313,"graphql_api":0.01,"framework":0.0601,"frontend":0.0159,"other":0.0224},"confidence":0.6617},"securityRelevant":0.0067,"reportedVersion":{"choice":"2.4.6","probabilities":{"2.4.0":0.0025,"2.4.0-p1":0.0026,"2.4.1":0.0022,"2.4.1-p1":0.0024,"2.4.2":0.0027,"2.4.2-p1":0.0028,"2.4.2-p2":0.0033,"2.4.3":0.0037,"2.4.3-p1":0.004,"2.4.3-p2":0.0039,"2.4.3-p3":0.0031,"2.4.4":0.0032,"2.4.4-p1":0.003,"2.4.4-p10":0.0035,"2.4.4-p11":0.0038,"2.4.4-p12":0.0041,"2.4.4-p13":0.0036,"2.4.4-p14":0.0035,"2.4.4-p15":0.0034,"2.4.4-p16":0.0039,"2.4.4-p17":0.0034,"2.4.4-p18":0.0032,"2.4.4-p2":0.0023,"2.4.4-p3":0.0026,"2.4.4-p4":0.0026,"2.4.4-p5":0.0029,"2.4.4-p6":0.004,"2.4.4-p7":0.003,"2.4.4-p8":0.0037,"2.4.4-p9":0.0029,"2.4.5":0.0055,"2.4.5-p1":0.0042,"2.4.5-p10":0.0032,"2.4.5-p11":0.0046,"2.4.5-p12":0.0054,"2.4.5-p13":0.0043,"2.4.5-p14":0.0041,"2.4.5-p15":0.0042,"2.4.5-p16":0.0046,"2.4.5-p17":0.0033,"2.4.5-p2":0.0027,"2.4.5-p3":0.0029,"2.4.5-p4":0.0032,"2.4.5-p5":0.0035,"2.4.5-p6":0.0045,"2.4.5-p7":0.0035,"2.4.5-p8":0.0031,"2.4.5-p9":0.0028,"2.4.6":0.5858,"2.4.6-p1":0.0281,"2.4.6-p10":0.0106,"2.4.6-p11":0.0104,"2.4.6-p12":0.0081,"2.4.6-p13":0.0086,"2.4.6-p14":0.0076,"2.4.6-p15":0.0061,"2.4.6-p2":0.0065,"2.4.6-p3":0.011,"2.4.6-p4":0.0109,"2.4.6-p5":0.0125,"2.4.6-p6":0.018,"2.4.6-p7":0.0088,"2.4.6-p8":0.0088,"2.4.6-p9":0.0059,"2.4.7":0.0045,"2.4.7-p1":0.0044,"2.4.7-p10":0.0033,"2.4.7-p2":0.0033,"2.4.7-p3":0.0042,"2.4.7-p4":0.0048,"2.4.7-p5":0.0037,"2.4.7-p6":0.0049,"2.4.7-p7":0.004,"2.4.7-p8":0.0032,"2.4.7-p9":0.0029,"2.4.8":0.0037,"2.4.8-p1":0.0044,"2.4.8-p2":0.0047,"2.4.8-p3":0.0053,"2.4.8-p4":0.0052,"2.4.8-p5":0.0046,"2.4.9":0.0047,"unspecified":0.0111},"confidence":0.3384},"backportWorthy":{"score":1.6897,"probabilities":{"0":0.0602,"1":0.1898,"2":0.75},"confidence":0.4031}},"curated":{"title":"Fixes hanging catalog_product_entity_int selects when reindexing large catalogs","description":"On a large catalog, SELECT queries on catalog_product_entity_int hang, so the catalogsearch_fulltext reindex puts no data into the Elasticsearch/OpenSearch indexes. Magento_Catalog db_schema.xml adds the btree index CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID_ENTITY_ID on attribute_id and entity_id.","categories":["Catalog/Product"],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-38316 details"}