最近在測(cè)試MySQL中間件Tspider時(shí)發(fā)現(xiàn)一些問題,但因?yàn)閟pider引擎使用者少,網(wǎng)上關(guān)于spider引擎的問題解答非常少,所以做個(gè)整理積累:

create table db.tb ENGINE=SPIDER DEFAULT CHARSET=gbk PARTITION BY KEY (id) PARTITIONS 2 (PARTITION pt0 COMMENT = 'database "db", table "tb ", server "test_1"' ENGINE = SPIDER,PARTITION pt2  COMMENT = 'database "db", table "tb ", server "test_2"' ENGINE = SPIDER);   
ERROR 1488 (HY000): Field in list of fields for partition function not found in table   

其實(shí)原因很簡單:
就是comment里的指定遠(yuǎn)端連接的庫表時(shí)表名多了個(gè)空格,"tb "-->"tb"就行了,o(╯□╰)o

mysql> create table test.test(id int primary key,num int) ENGINE=SPIDER DEFAULT CHARSET=gbk PARTITION BY LIST (crc32(id)%4) (PARTITION pt0 VALUES IN (0) COMMENT = 'database "test", table "test", server "remote_1"' ENGINE = SPIDER, PARTITION pt1 VALUES IN (1) COMMENT = 'database "test", table "test", server "remote_2"' ENGINE = SPIDER,PARTITION pt2 VALUES IN (2) COMMENT = 'database "test", table "test", server "remote_3"' ENGINE = SPIDER,PARTITION pt3 VALUES IN (3) COMMENT = 'database "test", table "test", server "remote_4"' ENGINE = SPIDER);   
ERROR 1477 (HY000): The foreign server name you are trying to reference does not exist. Data source error:  test_1   

乍一看莫名其妙--創(chuàng)建語句沒使用test_1這個(gè)遠(yuǎn)端server呀,其實(shí)報(bào)錯(cuò)與這條建表語句沒關(guān)系;是mysql.servers系統(tǒng)表不包含test_1這個(gè)遠(yuǎn)端server記錄了,但又有現(xiàn)存其他表引用了test_1,解決辦法就是：更改引用了test_1的表使之引用mysql.servers里的有效遠(yuǎn)端server或者將test_1添加到mysql.servers里