MariaDB 10.1 + Spider => crash server

Description

Tables spider lost raper ? (I guess)

then =>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 # mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4 Server version: 10.1.11-MariaDB-1~jessie marispider_tablesadb.org binary distribution Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT table_schema, -> sum( data_length ) as "data", -> sum( index_length ) as "index", -> sum( data_free ) as "data_free" , -> count(1) as "tables", -> sum(TABLE_ROWS) as "rows", -> DEFAULT_CHARACTER_SET_NAME, -> DEFAULT_COLLATION_NAME -> FROM information_schema.TABLES a -> INNER JOIN information_schema.SCHEMATA b ON a.table_schema = b.SCHEMA_NAME -> GROUP BY table_schema; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [(none)]> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused") ERROR: Can't connect to the server

i reconnect :

1 DROP TABLE backend.sbtest;

I try previous query and it worked fine this time.

table was created as fallow :

1 2 3 4 5 6 7 8 9 10 11 CREATE TABLE `sbtest` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k` (`k`) ) ENGINE=SPIDER DEFAULT CHARSET=latin1 COMMENT='wrapper "mysql", table "sbtest"' /*!50100 PARTITION BY KEY (`id`) (PARTITION pt1 COMMENT = 'srv "backend1"' ENGINE = SPIDER, PARTITION pt2 COMMENT = 'srv "backend2"' ENGINE = SPIDER) */

backend1 = backend2 (same params, just different databases)

after reboot mysql, it seem that backend2 don't answer anymore and worked fine for backend1.

PS : all of these backend are locate on same MySQL server.

Environment

Debian 8.*

Status

Assignee

Unassigned

Reporter

Aurélien LEQUOY

Labels

External issue ID

None

External issue ID

None

Components

Affects versions

10.1.11

Priority

Critical