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'
In case you're using MariaDB, you should check Magento's recommendation: here
Reindexing on MariaDB 10.4 and 10.6 takes more time compared to previous MariaDB or MySQL versions. To speed up reindexing, we recommend setting these MariaDB configuration parameters:
optimizer_switch='rowid_filter=off'
optimizer_use_condition_selectivity = 1
Access to your database and set configuration:
set global optimizer_switch='rowid_filter=off';
set global optimizer_use_condition_selectivity = 1;
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
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
reindexingafterreset?