Stopping the indexer process, it's an easy task. When Magento starts indexing it updates the status in the table
working. If script stopped working due to error or server problem, the status remains the same
working and won’t bring the process back to pending automatically.
One solution is login to your database via phpmyadmin.
Run the below program. Don’t forget to fix the error before running query.
UPDATE `index_process` SET `status` = 'pending' WHERE `status` = 'working'
If you face any problems or need our professional services, please email us at [email protected]