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

            Kentoku Kentoku Shiba (Inactive)
            Pierre Pierre Mavro
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.