Magento 2 Catalog Product Flat Data not reindexing

Question

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

Answer 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

Answer 2

In your database, try running the below commnand

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

Then reindex again