I am getting this strange error while reindex, and I cannot find any solution on google or on stackoverflow.
Stock index exception: SQLSTATE[42S01]: Base table or view already
exists: 1050 Table ‘./mydb/cataloginventory_stock_status_outdated’
already exists, query was: RENAME TABLE cataloginventory_stock_status
TO
cataloginventory_stock_status_outdated,cataloginventory_stock_status_replica
TO
cataloginventory_stock_status,cataloginventory_stock_status_outdated
TO cataloginventory_stock_status_replica
already checked in /var/lib/mysql/mydb/
and there is no cataloginventory_stock_status_outdated
table
I am getting the same error for catalog_category_product_index_store1_outdated
Any help please.