1

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

2 Answers 2

1

In Database Run This Query

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

And After This run indexer:reindex command

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

In your database, try running the below commnand

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

Then reindex again

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

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.