Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

cataloginventory_stock_status_replica error when re-indexing

‎06-28-2018 04:38 AM
‎06-28-2018 04:38 AM

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

 

2 REPLIES 2
‎06-28-2018 09:57 PM
‎06-28-2018 09:57 PM

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.

‎10-08-2018 08:13 AM
‎10-08-2018 08:13 AM

Re: cataloginventory_stock_status_replica error when re-indexing

how did you fix this please?

0 Kudos