Unable to create FULLTEXT index after previous attempt was aborted on MySql

Question

I have an InnoDB table containing about 5 million records. yesterday I tried to create a FULLTEXT index in one of my columns, but unfortunately the connection was interrupted after a few minutes in the process, so the index was not created.

The problem is that when I try to create the above index again using this command:

CREATE FULLTEXT INDEX TEXT_FULL ON MY_BIG_TABLE(TEXT_COLUMN);

it raises the following error:

ERROR 1050 (42S01): Table 'my_db/#sql-ib131' already exists

at first I thought it was a temporary table called "# sql-ib131" that MySql created to complete my previous index query, and so I tried to delete it using:

drop table `#sql-ib131`;

but MySql returns the following:

ERROR 1051 (42S02): Unknown table 'my_db.#sql-ib131'

(I also tried resetting "sql-ib131" and "my_db / # sql-ib131", but no luck.

: :

SHOW INDEX FROM MY_BIG_TABLE;

FULLTEXT.

?

, Chikko.

Answer 1

, , InnoDB . , .

: http://bugs.mysql.com/bug.php?id=71819

InnoDB . InnoDB, . , mysqld mysqld.

, InnoDB ( , #sql-ibXXX), , .

- , , , InnoDB .

, mysqld.

---

, , - VIEW, , .

mysql> CREATE VIEW test.V AS SELECT * FROM test.Foo;

mysql> DROP TABLE test.V;
ERROR 1051 (42S02): Unknown table 'test.V'

mysql> CREATE TABLE test.V (i INT);
ERROR 1050 (42S01): Table 'V' already exists

, , InnoDB ALTER TABLE .