Magento Asked on November 30, 2021
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'
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
Answered by Ylgen Guxholli on November 30, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP