I have 60 million products in my magento 2 store. I have started indexer:reindex so it will struck on catalog_category_product it shows processing in this and on schedule status it shows suspended in this what's the issue in this ?

enter image description here

I have reset the indexer for all and for this data also but on again starting it shows suspended .

Any help is appriciated.

  • Did you resolve your issue? Commented Dec 24, 2020 at 9:14
  • 1
    process is running will update you if anything comes up.
    – Prits
    Commented Dec 24, 2020 at 9:34

1 Answer 1


You need to do the following stuff:

First You need to change the mode of indexing to Update on Save by using this command

php bin/magento indexer:set-mode realtime

After that you need to reset the indexing

php bin/magento indexer:reset

After that truncate _cl tables related to your issue occuring indexing

After that reindex the indexing

php bin/magento indexer:reindex 

Finally you need to change the mode of indexing to Update by Schedule

php bin/magento indexer:set-mode schedule

I hope it may help you

  • Thanks for your response i have 41 tables related to _cl ending which onw i have to truncate or all of them. Or i have to just truncate catalog_category_product_cl this table. Will you please help me with this .
    – Prits
    Commented Dec 24, 2020 at 6:15
  • just truncate catalog_category_product_cl Commented Dec 24, 2020 at 6:21
  • One more question firstly i have to run indexer:reindex then make it to Update by Schedule or make it Update by Schedule then reindex it. Because i have read that if my product is more then i have to make it update on Schedule. will you please clear this.
    – Prits
    Commented Dec 24, 2020 at 6:41
  • No, follow the instruction. First update on save, then rest, then truncate, then reindex, then last make update on schedule on your requried indexes Commented Dec 24, 2020 at 6:43
  • i have follow your instruction and run indexer:reindex it is running from 6 hr and it is still showing processing on catalog_category_product. As, i have 60 million product so do you have any idea about what's the time to get it completed or if any occurs where would i look into.
    – Prits
    Commented Dec 24, 2020 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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