Ever faced an issue of the Customer Grid Indexer not working, when reindexing via CLI?!
Me too!!!
Sometimes, while running a command in Magento 2, “indexer re-index required” error is faced.
This is due to an issue in Magento 2 table. The table might have been corrupted in the database where it existed but something was missing.
The error says:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | 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 |
Method To Fix Indexer ReIndex Required Error in Magento 2:
Go to C:\xampp\mysql\data\mag232
Locate customer_grid_flat.ibd table on the customer grid.
Rename it to customer_grid_flat.ibd.old
That’s it.
Once the issue is solved, you can run the reindex command without any issue.
Any doubt on the topic can be mentioned in the Comments section below. I’d be happy to help.
Do share the solution with the Magento community via social media.
Thanks.
(based on 7 Reviews)
