ACSD-59083: Base table or view not found errors during simultaneous mview updates

ACSD-59083: Base table or view not found errors during simultaneous `mview` updates

Last update: Wed Jan 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
System

CREATED FOR:

Experienced
Admin
Developer

The ACSD-59083 patch fixes the issue where certain database update operations fail with the error â€˜Base table or view not foundâ€™ when mview updates run simultaneously. This patch is available when the Quality Patches Tool (QPT) 1.1.57 is installed. The patch ID is ACSD-59083. Please note that the issue was fixed in ÃÛ¶¹ÊÓÆµ Commerce 2.4.8.

Affected products and versions

The patch is created for ÃÛ¶¹ÊÓÆµ Commerce version:

ÃÛ¶¹ÊÓÆµ Commerce (all deployment methods) 2.4.5-p5

Compatible with ÃÛ¶¹ÊÓÆµ Commerce versions:

ÃÛ¶¹ÊÓÆµ Commerce (all deployment methods) 2.4.4 - 2.4.7-p3

NOTE

The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your ÃÛ¶¹ÊÓÆµ Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

Certain database update operations result in â€˜Base table or view not foundâ€™ errors when mview updates run simultaneously.

Steps to reproduce:

Set indexer mode to Update on Schedule.

Insert records into cl tables using the following SQL commands:

code language-none

code language-none
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;

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;

Install the setup/performance-toolkit/profiles/ce/small.xml profile.
Add a breakpoint in the file magento2ee/lib/internal/Magento/Framework/ForeignKey/Config/DbReader.php at line 72.
Clear the cache.
Click Add to Cart on any product.
Start the cron job when execution hits the breakpoint.
Resume the process after starting the cron job.

Expected results:

The database operations execute successfully without errors.

Actual results:

An error occurs during execution:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento24.design_config_dummy_cl__tmp663bb682960345_17794892' doesn't exist in /www/magento24/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:90

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

ÃÛ¶¹ÊÓÆµ Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
ÃÛ¶¹ÊÓÆµ Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.

To learn more about Quality Patches Tool, refer to:

Quality Patches Tool: A self-service tool for quality patches in the Tools guide.

recommendation-more-help

c2d96e17-5179-455c-ad3a-e1697bb4e8c3

ÃÛ¶¹ÊÓÆµ