{"data":{"id":"ACSD-59083","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where some database update operations result in 'Base table or view not found' error if the mview update is running at the same time.","categories":["Other"],"components":["magento/module-scalable-oms"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-57/acsd-59083-fix-base-table-or-view-not-found-errors-during-simultaneous-mview-updates","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-57/acsd-59083-fix-base-table-or-view-not-found-errors-during-simultaneous-mview-updates.md","blobSha":"6a1c7f08ddedde3d463eeda02bb1672da5610126","description":"Certain database update operations result in 'Base table or view not found' errors when mview updates run simultaneously.","stepsToReproduce":"1. Set indexer mode to Update on Schedule. 1. Insert records into cl tables using the following SQL commands: INSERT INTO catalogrule_product_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalogrule_rule_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalogsearch_fulltext_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalog_category_product_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalog_product_attribute_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalog_product_category_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO catalog_product_price_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO customer_dummy_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO design_config_dummy_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO salesrule_rule_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO targetrule_product_rule_cl SELECT NULL, entity_id FROM catalog_product_entity; INSERT INTO targetrule_rule_product_cl SELECT NULL, entity_id FROM catalog_product_entity; 1. Install the setup/performance-toolkit/profiles/ce/small.xml profile. 1. Add a breakpoint in the file magento2ee/lib/internal/Magento/Framework/ForeignKey/Config/DbReader.php at line 72. 1. Clear the cache. 1. Click Add to Cart on any product. 1. Start the cron job when execution hits the breakpoint. 1. Resume the process after starting the cron job.","introducedInQpt":"1.1.57","createdFor":["2.4.5-p5"],"documentedRange":"2.4.4 - 2.4.7-p3","scheduledFixRelease":null},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.4 <2.4.8","path":"patches/commerce/ACSD-59083_2.4.5-p5.patch","blobSha":"2f4478fcb956969691d208b2a37ea6f8dbb9298c","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-59083_2.4.5-p5.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-scalable-oms/etc/di.xml","change":"modified","package":"magento/module-scalable-oms"}],"packages":["magento/module-scalable-oms"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","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"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/exception.log","match":"report.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '*design_config_dummy_cl_*' doesn't exist in *DB/Statement/Pdo/Mysql.php:"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-59083 details"}