how to fix error indexer Reindex required??

[kasumo]

I have run commands indexer:status  and commands indexer:reindex and here is the result:

C:\xampp\htdocs\magento>php bin/magento indexer:status
Design Config Grid: Reindex required
Customer Grid: Reindex required
Category Products: Ready
Product Categories: Ready
Product Price: Ready
Product EAV: Ready
Catalog Search: Reindex required
Stock: Ready
Catalog Rule Product: Ready
Catalog Product Rule: Ready

C:\xampp\htdocs\magento>php bin/magento indexer:reindex
Design Config Grid indexer process unknown error:
SQLSTATE[HY000]: General error: 1813 Tablespace '`magento`.`design_config_grid_flat`' exists., query was: CREATE TABLE IF NOT EXISTS `design_config_grid_flat` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
`store_website_id` int NULL COMMENT 'Store_website_id' ,
`store_group_id` int NULL COMMENT 'Store_group_id' ,
`store_id` int NULL COMMENT 'Store_id' ,
`theme_theme_id` varchar(255) NULL COMMENT 'Theme_theme_id' ,
PRIMARY KEY (`entity_id`),
INDEX `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
INDEX `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
INDEX `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
FULLTEXT `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) COMMENT='design_config_grid_flat' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Customer Grid indexer process unknown error:
SQLSTATE[HY000]: General error: 1813 Tablespace '`magento`.`customer_grid_flat`' exists., query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
`name` text NULL COMMENT 'Name' ,
`email` varchar(255) NULL COMMENT 'Email' ,
`group_id` int NULL COMMENT 'Group_id' ,
`created_at` timestamp NULL default NULL COMMENT 'Created_at' ,
`website_id` int NULL COMMENT 'Website_id' ,
`confirmation` varchar(255) NULL COMMENT 'Confirmation' ,
`created_in` text NULL COMMENT 'Created_in' ,
`dob` date NULL COMMENT 'Dob' ,
`gender` int NULL COMMENT 'Gender' ,
`taxvat` varchar(255) NULL COMMENT 'Taxvat' ,
`lock_expires` timestamp NULL default NULL COMMENT 'Lock_expires' ,
`shipping_full` text NULL COMMENT 'Shipping_full' ,
`billing_full` text NULL COMMENT 'Billing_full' ,
`billing_firstname` varchar(255) NULL COMMENT 'Billing_firstname' ,
`billing_lastname` varchar(255) NULL COMMENT 'Billing_lastname' ,
`billing_telephone` varchar(255) NULL COMMENT 'Billing_telephone' ,
`billing_postcode` varchar(255) NULL COMMENT 'Billing_postcode' ,
`billing_country_id` varchar(255) NULL COMMENT 'Billing_country_id' ,
`billing_region` varchar(255) NULL COMMENT 'Billing_region' ,
`billing_street` varchar(255) NULL COMMENT 'Billing_street' ,
`billing_city` varchar(255) NULL COMMENT 'Billing_city' ,
`billing_fax` varchar(255) NULL COMMENT 'Billing_fax' ,
`billing_vat_id` varchar(255) NULL COMMENT 'Billing_vat_id' ,
`billing_company` varchar(255) NULL COMMENT 'Billing_company' ,
PRIMARY KEY (`entity_id`),
INDEX `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
INDEX `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
INDEX `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
INDEX `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
INDEX `CUSTOMER_GRID_FLAT_DOB` (`dob`),
INDEX `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
INDEX `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
FULLTEXT `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`, `email`, `created_in`, `taxvat`, `shipping_full`, `billing_full`, `billing_firstname`, `billing_lastname`, `billing_telephone`, `billing_postcode`, `billing_region`, `billing_city`, `billing_fax`, `billing_company`)
) COMMENT='customer_grid_flat' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Category Products index has been rebuilt successfully in 00:00:03
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:12
Product EAV index has been rebuilt successfully in 00:00:07
Catalog Search indexer process unknown error:
SQLSTATE[HY000]: General error: 1813 Tablespace '`magento`.`catalogsearch_fulltext_scope1`' exists., query was: CREATE TABLE IF NOT EXISTS `catalogsearch_fulltext_scope1` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
`attribute_id` int UNSIGNED NOT NULL COMMENT 'Attribute_id' ,
`data_index` longtext NULL COMMENT 'Data index' ,
PRIMARY KEY (`entity_id`, `attribute_id`),
FULLTEXT `FTI_FULLTEXT_DATA_INDEX` (`data_index`)
) COMMENT='catalogsearch_fulltext_scope1' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Stock index has been rebuilt successfully in 00:00:02
Catalog Rule Product index has been rebuilt successfully in 00:00:07
Catalog Product Rule index has been rebuilt successfully in 00:00:00

I copied and ran the above three query commands in phpMyAdmin but the table error already exists 

Can someone help me solve this problem? 

[Tom Robertshaw]

This seems similar to this issue https://magento.stackexchange.com/questions/151779/sqlstate42s02-base-table-or-view-not-found-1146-t... where the person needed to recreate the table. There was some corruption on the database where the table already existed but there was something missing. 

There isn't a clear solution from this post though. Perhaps you could try deleting the table and recreating it?

[rexaccuweb03d6]

 Hello kasumo,

Sometimes, while executing a command in Magento 2, an "indexer re-index required" error is faced. It occurs due to an issue in the table of Magento 2. The table might be corrupted in the database it exists, but something was missing.

You must run the command below command to check the status of the indexer,

php bin/magento indexer:status

Design Config Grid: Reindex required

Customer Grid: Reindex required

Category Products: Ready

Product Categories: Ready

Product Price: Ready

Product EAV: Ready

Catalog Search: Reindex required

Stock: Ready Catalog Rule Product: Ready

Catalog Product Rule: Ready

• Now, In order to fix the "indexer re-index required" error, you can follow the steps below,
• Firstly, navigate to C:\xampp\mysql\data\mag232
• Then, locate the customer_grid_flat.ibd table on the customer grid.
• Lastly, rename it to customer_grid_flat.ibd.old.

Once the issue gets resolved, you can run the below command without facing any issues:

php bin/magento indexer:reindex

I hope the above solution helps you to fix the "indexer Reindex required" error.

----------------------------
Regards,
Rex M

AccuWeb Hosting | Magento Hosting