Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.1.11
-
Debian 8.*
Description
Tables spider lost raper ? (I guess)
then =>
# 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 :
DROP TABLE backend.sbtest;
|
I try previous query and it worked fine this time.
table was created as fallow :
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.