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 '19 at 12:11
  • try running command with sudo – surbhi agr Jun 19 '19 at 12:13
  • What's the right commando with sudo? – user1250934 Jun 19 '19 at 12:14
  • sudo php bin/magento indexer:reindex – surbhi agr Jun 19 '19 at 12:14
  • same error still showing – user1250934 Jun 19 '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 '19 at 12:18
  • bin/magento indexer:status and check catalog_product_flat status – Rk Rathod Jun 19 '19 at 12:32
  • result: Product Flat Data: Reindex required – user1250934 Jun 19 '19 at 12:34
  • try to indexer:reindex – Rk Rathod Jun 19 '19 at 12:38
  • I already did multiple times, without a result – user1250934 Jun 19 '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.