We have recently upgrade our magento system from 2.4.3-p1 to 2.4.7-p3. This was a massive system upgrade. However after the upgrade process, we are noticing indexer_update_all_views indexer is failing with error
[2025-01-27T07:23:05.296231+00:00] report.ERROR: Cron Job indexer_update_all_views has an error: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘hhdjar4f2w7cu.catalog_product_attribute_cl__tmp679734593c6017_33601652’ doesn’t exist, query was: SELECT MAX(id) as max, COUNT() as cnt FROM (SELECT catalog_product_attribute_cl__tmp679734593c6017_33601652. FROM catalog_product_attribute_cl__tmp679734593c6017_33601652 WHERE (catalog_product_attribute_cl__tmp679734593c6017_33601652.id > ‘2’) ORDER BY catalog_product_attribute_cl__tmp679734593c6017_33601652.id ASC
I have checked the catalog_product_attribute_cl, it exist with data. I have tried to reset and reindex but the error keeps happening.
As part of the upgrade process we had switched from elasticsearch to opensearch. In our system configuration when i test connection for opensearch it says successfull.
