{"data":{"id":"MDVA-43601","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue with missing triggers after full reindex.","categories":["Catalog/Product"],"components":["magento/module-catalog-rule"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-13/mdva-43601-triggers-are-removed-from-catalogrule-product-price-table","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-13/mdva-43601-triggers-are-removed-from-catalogrule-product-price-table.md","blobSha":"d31be908987682ce619274eff27e4b5a8185d8b1","description":"Triggers are removed from catalogrule_product_price table after a full reindex of catalogrule_rule or catalogrule_product.","stepsToReproduce":"1. Set all the indexers to Update by Schedule. 1. Check the triggers created for catalogrule_product_price table by running the following SQL request: show triggers like '%catalogrule_%'\\G 1. Manually reindex catalogrule_rule or catalogrule_product by running the following command: bin/magento indexer:reindex catalogrule_rule 1. Check the triggers of catalogrule_product_price table again.","introducedInQpt":"1.1.13","createdFor":["2.4.2-p2"],"documentedRange":"2.3.0 - 2.4.4","scheduledFixRelease":"2.4.5"},"files":[{"package":"magento/magento2-base","constraint":">=2.3.0 <2.4.3","path":"patches/os/MDVA-43601_2.4.1.patch","blobSha":"ad32d1fc1bd5d4b51f20a9955fa8cb54cfd08892","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-43601_2.4.1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-rule/Model/Indexer/IndexerTableSwapper.php","change":"modified","package":"magento/module-catalog-rule"}],"packages":["magento/module-catalog-rule"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","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"],"magento-commerce":["2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","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"],"mage-os":[]},"unknownVersions":[],"requires":["MDVA-38608-V2"],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.3 <2.4.5","path":"patches/os/MDVA-43601_2.4.1.patch","blobSha":"ad32d1fc1bd5d4b51f20a9955fa8cb54cfd08892","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-43601_2.4.1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-rule/Model/Indexer/IndexerTableSwapper.php","change":"modified","package":"magento/module-catalog-rule"}],"packages":["magento/module-catalog-rule"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","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"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","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"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-43601 details"}