Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.12
-
Debian 7 x64 under Virtualbox
Description
The spider_copy_tables function doesn't work at all. I tried to shut off a MariaDB server, rerun it again, the status_link was equal to 3. I truncated the partition on which the server failed. Tries to changed it to 2 for maintenance purpose:
ALTER TABLE backend.sbtest
|
ENGINE=spider COMMENT='wrapper "mysql", table "sbtest"'
|
PARTITION BY KEY (id)
|
(
|
PARTITION pt1 COMMENT = 'srv "backend1 backend2_replication" mbk "2", mkd "2", msi "3306", link_status "2 0"',
|
PARTITION pt2 COMMENT = 'srv "backend2 backend1_replication" mbk "2", mkd "2", msi "3306", link_status "0 0"'
|
);
|
Then copy the Spider table using spider_copy_tables:
MariaDB [(none)]> select spider_copy_tables('backend.sbtest#P#pt2','1','0');
|
+----------------------------------------------------+
|
| spider_copy_tables('backend.sbtest#P#pt2','1','0') |
|
+----------------------------------------------------+
|
| 1 |
|
+----------------------------------------------------+
|
1 row in set (2 min 0.73 sec)
|
The return code means it's ok, however the table remains still empty. Nothings have been copied.