cancel
Showing results for 
Search instead for 
Did you mean: 

cataloginventory_stock_status_replica error when re-indexing

cataloginventory_stock_status_replica error when re-indexing

Hi

 

I'm new to Magento 2 so if this question has been asked before i apologise in advance.

 

When re-indexing with the SSH command bin/magento indexer:reindex i get the following error:

Table "cataloginventory_stock_status_replica" does not exist

All the other re-indexing works fine. I've no idea where or how to fix it, please can you help??

 

Magento 2.2.4

PHP 7.0.30

 

Thank you

David

 

1 REPLY

Re: cataloginventory_stock_status_replica error when re-indexing

Hi @Dhickling,

 

The *_replica tables are used for indexes to avoid locks. You can read a little bit here: https://devdocs.magento.com/guides/v2.2/extension-dev-guide/indexer-batch.html#indexer-table-switchi...

 

I can't imagine why the table doesn't exists but maybe you can continue from there.

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"