TransWikia.com

Reindex stuck at processing even after resetting in Magento 2

Magento Asked on November 30, 2021

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'

2 Answers

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 

Answered by Hunter on November 30, 2021

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

Answered by Ylgen Guxholli on November 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP