cataloginventory_stock_status_replica error when re-indexing

[Dhickling]

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

[Damian Culotta]

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.

[mariamgh]

how did you fix this please?