0

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.

Improve this question
2
  • anybody have an idea about this ticket? Commented May 20, 2021 at 8:54
  • @m2dubai please check my answer below Commented May 20, 2021 at 10:51

1 Answer 1

Reset to default
0

This is how I solved the problem if someone passes from here

using terminal

cd /var/lib/mysql/dbname/

ls

search for the table with no tablename.frm and move to a safe place or delete the tablename.ibd

example (here renaming the table)

mv customer_grid_flat.ibd customer_grid_flat.ibd.old

now reindex, the tables will be regenerated

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.