{"data":{"id":"magento2-25859","source":"github-pr","sourceRef":"magento/magento2#25859","title":"[Investigation] Indexers stuck after redeploy","pr":{"number":25859,"url":"https://github.com/magento/magento2/pull/25859","author":"fredden","mergedAt":"2024-05-16T19:44:59Z","mergeCommit":"963c22c6c973e894a1f7d8ae1b6db9d84af7fceb","headCommit":"28de31a6dbc839138103d40eff6403ae4aad5970","baseRef":"2.4-develop","diffSha256":"63249cfb29dad70e1812bef91540bcc070ae3ca97449e864dadc044bf520d77d"},"issues":[{"number":729,"url":"https://github.com/magento/magento2/issues/729","title":"[Investigation] Indexers stuck after redeploy","labels":["Magento internal","Progress: done","bug"],"kind":"human"},{"number":29789,"url":"https://github.com/magento/magento2/issues/29789","title":"[Issue] Drop indexer changelog tables on mview unsubscribe","labels":["Area: Admin UI","Component: Indexer","Component: Mview","Issue: Clear Description","Issue: Confirmed","Issue: Format is valid","Issue: Ready for Work","Priority: P3","Progress: done","Reported on 2.4.0","Reproduced on 2.4.x","Severity: S3"],"kind":"human"}],"fixedIn":"2.4.8","containingTags":["2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5","2.4.9"],"reportedOn":"2.4.0","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":"conflict","2.4.8-p1":"conflict","2.4.8-p2":"conflict","2.4.8-p3":"conflict","2.4.8-p4":"conflict","2.4.8-p5":"conflict","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"],"components":["magento/framework","magento/module-indexer"],"files":[{"path":"app/code/Magento/Indexer/Model/Indexer.php","change":"modified","package":"magento/module-indexer"},{"path":"app/code/Magento/Indexer/Setup/Recurring.php","change":"modified","package":"magento/module-indexer"},{"path":"lib/internal/Magento/Framework/Mview/View.php","change":"modified","package":"magento/framework"},{"path":"lib/internal/Magento/Framework/Mview/ViewInterface.php","change":"modified","package":"magento/framework"}],"stripped":{"tests":["app/code/Magento/Indexer/Test/Unit/Model/IndexerTest.php","lib/internal/Magento/Framework/Mview/Test/Unit/ViewSubscribeTest.php"],"docs":[],"outsideCode":[]},"linesChanged":38,"mergeBatched":false,"excluded":null,"sections":{"description":"1. Some indexers can be stuck","stepsToReproduce":"1. Try to redeploy when some indexer works","expectedResult":"1. Indexers can be run","actualResult":"1. Some indexers can be stuck\n\nInternal ticket: MCLOUD-5992","source":"issue"},"signatures":[],"labels":{"area":["Admin UI"],"component":["Indexer","Mview"],"priority":"P3","severity":"S3","reportedOn":["2.4.0"]},"categories":[],"triage":{"model":"@cf/cloudflare/clef","requestHash":"ee4d74a58c9298a28cf99e34c8ce6538b72c6ab3f0cb83b34988197f68c04582","isBugfix":0.9037,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.9293,"feature":0.0214,"refactor":0.0301,"tests_only":0.0092,"docs_only":0.0037,"dependency":0.0063},"confidence":0.838},"scope":{"score":0.9666,"probabilities":{"0":0.2777,"1":0.478,"2":0.2443},"confidence":0.0479},"risk":{"score":1.5655,"probabilities":{"0":0.1132,"1":0.208,"2":0.6788},"confidence":0.2752},"area":{"choice":"framework","probabilities":{"catalog":0.0358,"checkout":0.0138,"customer":0.0104,"admin":0.1238,"graphql_api":0.0109,"framework":0.6855,"frontend":0.0122,"other":0.1076},"confidence":0.427},"securityRelevant":0.0055,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.1192,"2.4.0-p1":0.0183,"2.4.1":0.0176,"2.4.1-p1":0.0133,"2.4.2":0.0157,"2.4.2-p1":0.0128,"2.4.2-p2":0.0147,"2.4.3":0.0161,"2.4.3-p1":0.0149,"2.4.3-p2":0.0139,"2.4.3-p3":0.0094,"2.4.4":0.0155,"2.4.4-p1":0.0092,"2.4.4-p10":0.0063,"2.4.4-p11":0.01,"2.4.4-p12":0.0077,"2.4.4-p13":0.008,"2.4.4-p14":0.0083,"2.4.4-p15":0.0071,"2.4.4-p16":0.007,"2.4.4-p17":0.0062,"2.4.4-p18":0.0075,"2.4.4-p2":0.005,"2.4.4-p3":0.0052,"2.4.4-p4":0.0057,"2.4.4-p5":0.0073,"2.4.4-p6":0.006,"2.4.4-p7":0.0068,"2.4.4-p8":0.0064,"2.4.4-p9":0.005,"2.4.5":0.007,"2.4.5-p1":0.0074,"2.4.5-p10":0.0054,"2.4.5-p11":0.0077,"2.4.5-p12":0.0095,"2.4.5-p13":0.007,"2.4.5-p14":0.0075,"2.4.5-p15":0.0056,"2.4.5-p16":0.0055,"2.4.5-p17":0.0062,"2.4.5-p2":0.0041,"2.4.5-p3":0.0054,"2.4.5-p4":0.007,"2.4.5-p5":0.0072,"2.4.5-p6":0.0057,"2.4.5-p7":0.0053,"2.4.5-p8":0.0052,"2.4.5-p9":0.0037,"2.4.6":0.01,"2.4.6-p1":0.0069,"2.4.6-p10":0.0058,"2.4.6-p11":0.0082,"2.4.6-p12":0.0073,"2.4.6-p13":0.0071,"2.4.6-p14":0.0074,"2.4.6-p15":0.0052,"2.4.6-p2":0.004,"2.4.6-p3":0.0062,"2.4.6-p4":0.0084,"2.4.6-p5":0.0076,"2.4.6-p6":0.0089,"2.4.6-p7":0.007,"2.4.6-p8":0.0049,"2.4.6-p9":0.004,"2.4.7":0.0079,"2.4.7-p1":0.0055,"2.4.7-p10":0.007,"2.4.7-p2":0.0052,"2.4.7-p3":0.0082,"2.4.7-p4":0.0105,"2.4.7-p5":0.0111,"2.4.7-p6":0.0099,"2.4.7-p7":0.0087,"2.4.7-p8":0.006,"2.4.7-p9":0.0043,"2.4.8":0.0062,"2.4.8-p1":0.0055,"2.4.8-p2":0.008,"2.4.8-p3":0.0082,"2.4.8-p4":0.009,"2.4.8-p5":0.0103,"2.4.9":0.0106,"unspecified":0.2305},"confidence":0.0621},"backportWorthy":{"score":1.296,"probabilities":{"0":0.15,"1":0.4041,"2":0.4459},"confidence":0.077}},"curated":{"title":"Drops the indexer changelog table when an index switches to update on save","description":"Changing an index from update on schedule to update on save does not remove the unused changelog tables. With the change, mview unsubscribe in View.php drops the changelog table and Indexer.php marks the index as invalid, so it is fully indexed via normal minutely cron; Recurring.php setup does not drop the tables.","categories":[],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":{"2.4.7-p10":{"before":"fail","after":"pass","adapted":false,"runAt":"2026-10-06T09:29:06.714Z","releaseCommit":"72561bf80652f57cc642a03e2c9a51d74a285b14","suites":{"unit":{"before":"fail","after":"pass","runAt":"2026-10-06T09:29:06.714Z"}}}}},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-25859 details"}