Reindex stuck at processing even after resetting in Magento 2

Question

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

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'

Hunter · Answer

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

Ylgen Guxholli · Answer

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

Reindex stuck at processing even after resetting in Magento 2

2 Answers

Add your own answers!

Ask a Question