Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.7
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Environment: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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Fixed in 10.0.12.