[PaaS only]{class="badge informative" title="Applies to Adobe Commerce on Cloud projects (Adobe-managed PaaS infrastructure) and on-premises projects only."}

ACSD-58739: Partial reindexing throws an error

NOTE
This patch is replaced by ACP2E-3705.

The ACSD-58739 patch fixes the issue where the partial reindexing throws an error. This patch is available when the Quality Patches Tool (QPT) 1.1.49 is installed. The patch ID is ACSD-58739. Please note that the issue is scheduled to be 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.7

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.7 - 2.4.8
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

Partial reindexing throws an error.

Steps to reproduce:

  1. Add slave connection settings to the app/etc/env.php.

  2. Generate up to 10000 products and execute the following command:

    code language-none
    bin/magento index:reindex
    
  3. Add generated product IDs into catalogsearch_fulltext_cl DB table.

    code language-none
    insert into catalogsearch_fulltext_cl (entity_id) select entity_id from catalog_product_entity;
    
  4. Execute the following command to trigger the partial reindex:

    code language-none
    bin/magento cron:run --group=index --bootstrap=standaloneProcessStarted=1
    
  5. Check the var/log/support_report.log file.

Expected Results

No error.

Actual Results:

Base table or view not found error occurs when partial reindexing is executed.

Apply the patch

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

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3