magento2: Error while reindexing price

So I recently had this issue with 2.3.4-p2. I dug a little bit further and I think there is nothing wrong with table names per-say. In Magento\ConfigurableProduct\Model\ResourceModel\Product\Indexer\Price\Configurable there is a method called executeByDimensions. This method calls Magento\Catalog\Model\Indexer\Product\Price\TableMaintainer createMainTmpTable method. This method creates a TEMPORARY table with the suffix “_temp” which is supposed to be exactly as the “_tmp”. This is intentional. The issue happens when the MySQL session is halted for some reason and the temporary table disappears. So there is probably room for improvement here but if you run into that issue I guess you should focus more on the MySQL settings and make sure there are no long-running queries into that TEMPORARY table.

This is true and it helped me a lot. I used it as a starting point for debugging. In my case I discovered an enabled module in my repository with the following code:

    public function __construct(ObjectManagerFactory $objectManagerFactory, \Magento\Framework\App\State $appState){
        (...)
        $this->objectManager = $objectManagerFactory->create($params);
        (...)
    }

This basically created a new instance of the object manager which was the reason why a different MySQL connection was used which in turn caused the error with the missing table.

So I recently had this issue with 2.3.4-p2. I dug a little bit further and I think there is nothing wrong with table names per-say. In Magento\ConfigurableProduct\Model\ResourceModel\Product\Indexer\Price\Configurable there is a method called executeByDimensions. This method calls Magento\Catalog\Model\Indexer\Product\Price\TableMaintainer createMainTmpTable method. This method creates a TEMPORARY table with the suffix “_temp” which is supposed to be exactly as the “_tmp”. This is intentional. The issue happens when the MySQL session is halted for some reason and the temporary table disappears. So there is probably room for improvement here but if you run into that issue I guess you should focus more on the MySQL settings and make sure there are no long-running queries into that TEMPORARY table.

Here is a patch file, you can use if you’re interested:

diff --git a/vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/CustomOptionPriceModifier.php b/vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/CustomOptionPriceModifier.php
index 646cd0d4..9bdb2a66 100644
--- a/vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/CustomOptionPriceModifier.php
+++ b/vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/CustomOptionPriceModifier.php
@@ -138,7 +138,7 @@ class CustomOptionPriceModifier implements PriceModifierInterface
         $select = $this->getConnection()
             ->select()
             ->from(
-                ['i' => $priceTable->getTableName()],
+                ['i' => $this->getTable('catalog_product_index_price_tmp')],
                 ['entity_id']
             )->join(
                 ['e' => $this->getTable('catalog_product_entity')],

I’m struggling to understand this whole post. Where is fix to this issue? I can see labels saying fixed in 2.3, however version 2.3 hasn’t yet been released! I need this fix on my website asap or at least walk around solution to it. I cannot add any products to my website as they won’t appear unless indexed.

Hi, I think the error is because of getIdxTable function in vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/DefaultPrice.php. It is returning table name as “catalog_product_index_price_temp” while it should be “catalog_product_index_price_tmp”

public function getIdxTable($table = null) { return $this->tableStrategy->getTableName(‘catalog_product_index_price’); }