So I know this used to be a common problem in M1.x. However, I only recently noticed this in our M2.1.3 environment.

Notice the Processing date

How can I flush/wipe the Category flat data index and rebuild from scratch?

  • If its not production then try to truncate (take a backup before doing so) the category flat table and start the indexing again. Apr 7, 2017 at 18:29
  • This is happening in a production environment. However, I can put it in maintenance mode on a slow moment, and do it then. Apr 7, 2017 at 23:01

2 Answers 2


It normally happens when the memory limit is few, so increase on your .htaccess or NGINX config.

Run this command on your MySQL:

update indexer_state set status = 'invalid' where status != 'valid';

On you terminal run:

alias mage="php -d memory_limit=-1 -f bin/magento"
mage indexer:reindex

You can also check mview_state table and set status to idle on that indexer then run it from cli with

php bin/magento indexer:reindex catalog_category_flat

If it break you should see some stack trace in the console

  • So interestingly enough, they are all idle, however they are all, also set to disable for mode. Which is odd. Apr 7, 2017 at 23:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.