Magento – Index Management – Process taking a long time

enterprise-1.14indexerreindex

I have an issue with my Index Management job stuck in "Processing". I have read about it and found out that I can check if the reindex process is running by checking in MySQL, which I did. It is showing that the process is "working".
I can also do a SHOW FULL PROCESSLIST command and see if there are any inserts or delete commands against the catalog_product_index_eav table, which I have done and there is indeed a process running for the last 2 days…
So it appears that the process is still running but it has been like this for 2 days… However, I am doing random:
SELECT COUNT(entity_id) AS total FROM catalog_product_index_eav;
statements on the database and the number is not changing.

My questions are:

  • Is it normal for this process to take so long? We have roughly 10,000
    products in the store.
  • Can I stop this process, as it's preventing me from doing any other reindex job… and if so, would this have a negative affect?
  • What would happen if I delete the files in /var/locks while the process is running? I guess it would allow 2 index processes to run at the same time?

Thanks

Best Answer

Would suggest to stop the indexing and restart it. Go to project root directory from Command Line / Terminal and then enter below commands.

You can reset the indexing process by command

php bin/magento indexer:reset

After that reindex again,

php bin/magento indexer:reindex
Related Topic