Magento 2 reindexer stuck on processing status.


Run this below query on magento 2 database.

update indexer_state set status = 'invalid' where indexer_id = 'indexer_id_name'; 

//Replace indexer_id_name with stuck indexer. for example:-

update indexer_state set status = 'invalid' where indexer_id = 'customer_order_history';
And again run the indexer command.
php bin/magento indexer:reindex

Previous
Next Post »