· 8 years ago · Dec 06, 2017, 10:48 AM
1Catalog Search indexer process unknown error:
2SQLSTATE[HY000]: General error: 1813 Tablespace for table '`mydb`.`catalogsearch_fulltext_scope1_tmp`' exists. Please DISCARD the tablespace before IMPORT., query was: CREATE TABLE IF NOT EXISTS `catalogsearch_fulltext_scope1_tmp` (
3 `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
4 `attribute_id` int UNSIGNED NOT NULL COMMENT 'Attribute_id' ,
5 `data_index` longtext NULL COMMENT 'Data index' ,
6 PRIMARY KEY (`entity_id`, `attribute_id`),
7 FULLTEXT `FTI_FULLTEXT_DATA_INDEX` (`data_index`)
8) COMMENT='catalogsearch_fulltext_scope1_tmp' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci
9
10innodb_version | 5.6.36-82.0 |
11| protocol_version | 10 |
12| slave_type_conversions | |
13| tls_version | TLSv1.1,TLSv1.2 |
14| version | 5.6.36-82.0 |
15| version_comment | Percona Server (GPL), Release 82.0, Revision 58e846a |
16| version_compile_machine | x86_64 |
17| version_compile_os | Linux