Indexer stuck in processing

[Loginname]

magento 1.9.3.6

Having 2 indexes that are constantly on Processing: Catalog_URL_Rewrites and Catalog Search Index

I'm personally also stuck on this issue, been reading around and have found ways to solve it using SSH, but I don't have SSH. I can get it, but hope I can fix it without..

Read someone recommended delte the content of \var\locks, but that folder I don't find...

Been googling this topic but so far not found the correct solution, so hope someone here can help me

Any ideas

[Damian Culotta]

Hi @Loginname,

Take a look into index_process table (into your database) to be sure what's happening with your indexes.

[Loginname]

This is what index_process table displays:

1 	catalog_product_attribute 	pending 	2017-11-22 13:05:45 	2017-11-22 13:05:55 	real_time
2 	catalog_product_price 	pending 	2017-11-22 13:05:55 	2017-11-22 13:06:02 	real_time
3 	catalog_url 	working 	2017-11-22 20:42:04 	2017-11-17 16:48:43 	real_time
4 	catalog_product_flat 	require_reindex 	2012-12-13 22:16:53 	2012-12-13 22:16:55 	real_time
5 	catalog_category_flat 	pending 	2012-12-13 18:35:06 	2012-12-13 18:35:08 	real_time
6 	catalog_category_product 	pending 	2017-11-22 13:07:21 	2017-11-22 13:07:30 	real_time
7 	catalogsearch_fulltext 	working 	2017-11-22 20:58:53 	2017-11-17 16:48:43 	real_time
8 	tag_summary 			pending 	2017-11-22 13:07:17 	2017-11-22 13:07:17 	real_time
9 	cataloginventory_stock 	pending 	2017-11-22 13:05:43 	2017-11-22 13:05:45 	real_time

[Loginname]

catalog_product_attribute 	pending 	2017-11-22 13:05:45 	2017-11-22 13:05:55 	real_time
catalog_product_price 		pending 	2017-11-22 13:05:55 	2017-11-22 13:06:02 	real_time
catalog_url 			working 	2017-11-22 20:42:04 	2017-11-17 16:48:43 	real_time
catalog_product_flat 		require_reindex 	2012-12-13 22:16:53 	2012-12-13 22:16:55 	real_time
catalog_category_flat 		pending 	2012-12-13 18:35:06 	2012-12-13 18:35:08 	real_time
catalog_category_product 	pending 	2017-11-22 13:07:21 	2017-11-22 13:07:30 	real_time
catalogsearch_fulltext 			working 	2017-11-22 20:58:53 	2017-11-17 16:48:43 	real_time
tag_summary 						pending 	2017-11-22 13:07:17 	2017-11-22 13:07:17 	real_time
cataloginventory_stock 	pending 	2017-11-22 13:05:43 	2017-11-22 13:05:45 	real_time

Here I tried to make the code easier to read

[Damian Culotta]

Hi @Loginname,

Maybe you can follow these refernces?

https://gist.github.com/tegansnyder/24a881dc6ef72a2e1c5e

I didn't tried because I haven't the issue yet.

[Paval]

Hi Loginname,

Reindex processes seem stuck on "Index Management"
Solution: log on FTP, go to docs/var/locks - delete the index.locks files, problem solved

<< Signature must be setup in the forum profile >>