For some reason my Product EAV index never finishes... Well I have left for over two days and it still says Processing... I have 42,000 products in my catalog and 92 attributes. Is this normal? How can I verify what it is doing? My server is fairly meaty..

I have done a

php bin/magento indexer:reset 

followed by a reindex to no avail.

Any help greatly appreciated.




I think one is to set change in the database the state of the processing indexes because till there are processing indexes no other index gets updated and neither the command line works.

You can use command below in database

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex

Hope it helps!

| improve this answer | |
  • Thanks I will try that - however, should this process take a long time? If the other indexes process in under 2 minutes each would the EAV index be significantly longer? – hydev Oct 11 '18 at 8:22
  • No it wont take much time – surbhi agr Oct 25 '18 at 12:05

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.