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
After that reindex again,