Início / dba / Perguntas / 295086
Accepted
NeilWang
Asked: 2021-07-01 15:48:46 +0800 CST

tabela de índice auxiliar corrompida?

  • 772

O log de erros do MySQL é mantido lançando erros como este:

2021-06-30T23:29:32.795948Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_1` in the cache. Attempting to load the tablespace with space id 5161
2021-06-30T23:29:32.798119Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_2` in the cache. Attempting to load the tablespace with space id 5162
2021-06-30T23:29:32.799672Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_3` in the cache. Attempting to load the tablespace with space id 5163
2021-06-30T23:29:32.801289Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_4` in the cache. Attempting to load the tablespace with space id 5164
2021-06-30T23:29:32.802702Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_5` in the cache. Attempting to load the tablespace with space id 5165
2021-06-30T23:29:32.804163Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_00000000000030de_INDEX_6` in the cache. Attempting to load the tablespace with space id 5166
2021-06-30T23:29:32.805517Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_BEING_DELETED` in the cache. Attempting to load the tablespace with space id 5156
2021-06-30T23:29:32.807103Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_BEING_DELETED_CACHE` in the cache. Attempting to load the tablespace with space id 5157
2021-06-30T23:29:32.808975Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_CONFIG` in the cache. Attempting to load the tablespace with space id 5158
2021-06-30T23:29:32.810041Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_DELETED` in the cache. Attempting to load the tablespace with space id 5159
2021-06-30T23:29:32.811121Z 3018 [ERROR] InnoDB: Failed to find tablespace for table `my_db`.`FTS_00000000000022f5_DELETED_CACHE` in the cache. Attempting to load the tablespace with space id 5160

Os arquivos existem

# ll FTS*
-rwxr-xr-x. 1 mysql mysql 13631488 Nov  9  2018 FTS_00000000000022f5_00000000000030de_INDEX_1.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_00000000000030de_INDEX_2.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_00000000000030de_INDEX_3.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_00000000000030de_INDEX_4.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_00000000000030de_INDEX_5.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_00000000000030de_INDEX_6.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_BEING_DELETED_CACHE.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_BEING_DELETED.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Nov  9  2018 FTS_00000000000022f5_CONFIG.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_DELETED_CACHE.ibd
-rwxr-xr-x. 1 mysql mysql    98304 Oct 19  2018 FTS_00000000000022f5_DELETED.ibd

Então, acredito que o índice ou o tablespace está corrompido. Como corrigi-lo?

mysql mysql-5.7

1 respostas

  1. Best Answer

    Bem, o problema foi corrigido depois de descartar todas as tabelas relevantes.

    Em primeiro lugar, procure o esquema de informações para descobrir as informações relevantes:

    SELECT table_id, name, space from INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE 'f0Gno';
SELECT * from INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE name LIKE 'DB_NAME/%';

    Então, você descobrirá que está relacionado ao FULLINDEX:

    select * from information_schema.statistics where table_schema='DB_NAME' and index_type='FULLTEXT';

    Por fim, elimine o índice:

    alter table DB_NAME.TABLE_NAME drop index '_keywords';

    Se você quiser recriar o índice:

    create fulltext index _keywords on DB_NAME.TABLE_NAME(KEY1,KEY2...);

    Você pode encontrar o nome da chave desc a tabela.

    • 0

relate perguntas