ACSD-59083: Certain database update operations result in 'Base table or view not found' errors…
Certain database update operations result in 'Base table or view not found' errors when mview updates run simultaneously. Quality patch ACSD-59083 for magento/module-scalable-oms applies to Magento Open Source and Adobe Commerce 2.4.4 to 2.4.7-p10.
- Categories
- Other
- Components
- magento/module-scalable-oms
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.57
Issue
Certain database update operations result in 'Base table or view not found' errors when mview updates run simultaneously.
Steps to reproduce
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.
Adobe's page lists 2.4.4 - 2.4.7-p3 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Install
Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-59083. On Cloud, add ACSD-59083 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-59083/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.
Patch files and compatible versions
magento/magento2-ee-base >=2.4.4 <2.4.8
- Magento Open Source
- —
- Adobe 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
- vendor/magento/module-scalable-oms/etc/di.xml
