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?