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