banner-4
Adobe Summit is here.
Experience keynotes, Sneaks, sessions, and more — all on demand.
Watch now
DocumentationCommerceTools

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 Adobe Commerce 2.4.8.

Affected products and versions

The patch is created for Adobe Commerce version:

Adobe Commerce (all deployment methods) 2.4.5-p5

Compatible with Adobe Commerce versions:

Adobe 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 Adobe 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:

  1. Set indexer mode to Update on Schedule.

  2. 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;

  3. Install the setup/performance-toolkit/profiles/ce/small.xml profile.

  4. Add a breakpoint in the file magento2ee/lib/internal/Magento/Framework/ForeignKey/Config/DbReader.php at line 72.

  5. Clear the cache.

  6. Click Add to Cart on any product.

  7. Start the cron job when execution hits the breakpoint.

  8. 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:

  • Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
  • Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.

Related reading

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