5

We have currently some process indexing in running.

How I can stop this?

We tried already some things like:

mysql restart, didn't worked as we could not do it mysql kill -9, didn't worked, but we could kill it, but the index process still running

I tried to find some lock files, but I didn't found any.

Any clue, what else we can check?

We are using Magento 1.9.1

  • do you mean it is showing running state in index management? – Akhilesh Patel Oct 30 '15 at 4:19
5

Stopping the indexing process is an easy task. When Magento starts indexing, it updates the status in the table index_process to working. If the script stops working due to some error or server problem, the status will remain the same as working and it won’t bring the process back to pending automatically.

One solution is to login into your database via phpmyadmin (or any other tools) and run the below program. Don’t forget to fix the error before running query.

UPDATE `index_process` SET `status` = 'pending' WHERE `status` = 'working';
4

Perhaps the Magento has created the locks in the db during the indexing and it hasn't released them after that. Try to get the list of the process by:

SHOW FULL PROCESSLIST;

Then try to kill them by process id like this:

KILL 341;

Use the actual process ids instead of the 341. I hope it helps you!

2

Go to "var/locks" from root of your magento then delete all files in it. It contains all index process files. But first take a backup 'locks' directory.

  • I do not have var/locks – Simon Vetterli Oct 31 '15 at 8:19
  • In your version of Magento there is no var/locks folder. You have to use Abhinav Singh's solution. I mean using the database query UPDATE index_process SET status = 'pending' WHERE status = 'working'; – Rinto George Aug 30 '17 at 6:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.