cancel
Showing results for 
Search instead for 
Did you mean: 

how to fix error indexer Reindex required??

how to fix error indexer Reindex required??

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? Smiley Sad

Tags (2)
1 REPLY

Re: how to fix error indexer Reindex required??

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?

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!