Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6463

SPIDER_COPY_TABLES doesn't work

    XMLWordPrintable

    Details

      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.

        Attachments

          Activity

            People

            Assignee:
            Kentoku Kentoku Shiba
            Reporter:
            Pierre Pierre Mavro
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration