Problem

During full reindex in CLI (Command Line Interface, SSH), Magento returns error message like “index is locked by another reindex process. Skipping.”

Reason

Error is possible if the previous reindex process wasn’t completed successfully. There are a few possible reasons for this issue:

• Fatal PHP error during reindexing
• Mysql Error (like timeout)
• Memory limit
• Process was unexpectedly interrupted (by a user or another process)

Solution

Proven Solution

You need reset index status and then try to run a new reindex process. For reset index status, you need run command:

bin/magento indexer:reset <index identifier>

If you don’t know the index identifier (code), you can use the command:

bin/magento indexer:info

All possible combinations for native indexes:

bin/magento indexer:reset design_config_grid;
bin/magento indexer:reset customer_grid;
bin/magento indexer:reset catalog_category_product;
bin/magento indexer:reset catalog_product_category;
bin/magento indexer:reset catalogrule_rule;
bin/magento indexer:reset catalog_product_attribute;
bin/magento indexer:reset cataloginventory_stock;
bin/magento indexer:reset catalog_product_price;
bin/magento indexer:reset catalogrule_product;
bin/magento indexer:reset catalogsearch_fulltext;