cancel
Showing results for 
Search instead for 
Did you mean: 

Indexer stuck in processing

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Indexer stuck in processing

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

5 REPLIES 5

Re: Indexer stuck in processing

Hi @Loginname,

 

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

Re: Indexer stuck in processing

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

Re: Indexer stuck in processing

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

Re: Indexer stuck in processing

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.

Re: Indexer stuck in processing

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 >>

Magento development: https://bootsgrid.com/services/magento-development/

Support : https://bootsgrid.com/contact-us/

Best regards,
B.pavalaraj
Bootsgrid Technologies
https://www.bootsgrid.com