3

My indexer:reindex process for Design config grid, Customer Grid, and Catalog Search always stuck at processing:

enter image description here

i already reset the indexer, but when i run indexer:reindex again, it stucks at processing

php bin/magento indexer:reset

and the same goes when i try to invalid the indexer from db

update indexer_state set status = 'invalid'
  • How much data you have in your system? – Sukumar Gorai Jan 28 at 7:58
  • @SukumarGorai what data? – Hunter Jan 28 at 7:58
  • Orders, customers, products etc are data. – Sukumar Gorai Jan 28 at 7:59
  • @SukumarGorai 8789 products , 2139 orders, 769 customers – Hunter Jan 28 at 8:05
  • have you tried reindexing after reset? – fmsthird Jan 28 at 8:05
0

Check if you have any cron running every minute and if it relates with those reindexes . If any of crons is related to those indexer that are running , try to increase the time of the cron for those , and test again. Are you running on a Magento 2 Enterprice or Community ?

Try to increase Schedule Ahead for option and then run php bin/magento cron:run --group=index enter image description here

0

When i inspect mysql process from SHOW PROCESSLIST; at mysql terminal, turns out there are too many lock on my magento 2 database

in order to fix this i need to stop and then start mysql again:

service mysqld stop
service mysqld start 

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.