Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.7
-
None
-
None
-
Ubuntu Linux 12.04
Description
mysql.spider_tables can be consistently corrupted as follows:
CREATE TABLE s ENGINE=SPIDER CONNECTION 'host "10.0.0.5", user "x", password "x"';
|
Lost connection to MySQL server during query
|
When subsequently creating a valid table, mysql.spider_tables is corrupted
CREATE TABLE s(id INT NOT NULL AUTO_INCREMENT, code VARCHAR(10), PRIMARY KEY(id)) ENGINE=SPIDER CONNECTION 'host "10.0.0.5", user "x", password "x"';
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 3
|
Current database: test
|
ERROR 145 (HY000): Table './mysql/spider_tables' is marked as crashed and should be repaired
|
I have managed to corrupt mysql.spider_tables in numerous other ways with the CREATE TABLE statement as well - this is just one easily repeatable example.