Details
Major
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
