0

the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like:

truncate catalog_product_flat_1, catalog_product_flat_2, catalog_product_flat_3, catalog_product_flat_4

php bin/magento indexer:reindex
php bin/magento indexer:reset 
php bin/magento indexer:reindex
php bin/magento indexer:reset catalog_product_flat

Error :-

message in shell: State for the same indexer already exists.

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

Then reindex again

Can anybody help? Thanks

0

In your database, try running the below commnand

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

Then reindex again

  • Hi, did but still same error: State for the same indexer already exists. – user1250934 Jun 19 at 12:11
  • try running command with sudo – surbhi agr Jun 19 at 12:13
  • What's the right commando with sudo? – user1250934 Jun 19 at 12:14
  • sudo php bin/magento indexer:reindex – surbhi agr Jun 19 at 12:14
  • same error still showing – user1250934 Jun 19 at 12:14
0

In Database Run This Query

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

And After This run indexer:reindex command

  • did this, but i see still the same error. – user1250934 Jun 19 at 12:18
  • bin/magento indexer:status and check catalog_product_flat status – Rk Rathod Jun 19 at 12:32
  • result: Product Flat Data: Reindex required – user1250934 Jun 19 at 12:34
  • try to indexer:reindex – Rk Rathod Jun 19 at 12:38
  • I already did multiple times, without a result – user1250934 Jun 19 at 12:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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