ACSD-58739: Partial reindexing throws an error
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
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:
-
Add slave connection settings to the
app/etc/env.php. -
Generate up to 10000 products and execute the following command:
code language-none bin/magento index:reindex -
Add generated product IDs into
catalogsearch_fulltext_clDB table.code language-none insert into catalogsearch_fulltext_cl (entity_id) select entity_id from catalog_product_entity; -
Execute the following command to trigger the partial reindex:
code language-none bin/magento cron:run --group=index --bootstrap=standaloneProcessStarted=1 -
Check the
var/log/support_report.logfile.
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:
- 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
- Quality Patches Tool released: a new tool to self-serve quality patches in the support knowledge base
- Check if patch is available for your Adobe Commerce issue using Quality Patches Tool in the Quality Patches Tool guide
- Best practices for modifying database tables in the Commerce Implementation Playbook
For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.