[MDEV-5559] mysql.spider_tables corrupted by CREATE TABLE statement Created: 2014-01-24  Updated: 2014-06-11  Resolved: 2014-06-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.7
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Ian Gilfillan Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: spider
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.

 Comments   
Comment by Sergey Vojtovich [ 2014-06-11 ]

Fixed in 10.0.12.

revno: 4236
 
revision-id: kentokushiba@gmail.com-20140608105211-gkkkon05dni2c3in
 
parent: psergey@askmonty.org-20140607214505-8y182z967i8jp7vw
 
committer: Kentoku SHIBA <kentokushiba@gmail.com>
 
branch nick: spider
 
timestamp: Sun 2014-06-08 19:52:11 +0900
 
message:
 
  merge Spider 3.2.4

Generated at Thu Feb 08 07:05:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.