I have imported large product qty with custom magmi port for magento2:

MariaDB [magento2]> select count(*) from catalog_product_entity;
| count(*) |
|  9974308 |
1 row in set (2.45 sec)

Only one store view in this magento instance and lots of categories created (about 100k products in each category) which admin backend shows.

But after reindexing I saw that only 500 records are returned but block collection from each category, and then I realized that catalog_category_product_index was built incorrectly...

MariaDB [magento2]> select distinct count(product_id) from catalog_category_product_index;
| count(product_id) |
|            105179 |

How to debug and resolve this issue ?

1 Answer 1


Yes, it's known issue https://github.com/magento/magento2/issues/8018. It have long description of problem

  • any change to get partial indexing working ? on isRangingNeeded returning false on 9mln of products still getting The table 'catalog_category_product_index_tmp' is full even when i tuned maximum temporary table size...
    – Ilja
    Commented Feb 8, 2017 at 21:25

Your Answer

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

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