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

Cluster SST does not work when table defined with "DATA DIRECTORY" and wsrep_sst_method=rsync

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.6.8
    • N/A
    • Galera SST
    • None

    Description

      CREATE TABLE `tab1` (
        `col1` varchar(100) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DATA DIRECTORY='/opt/mysql/'
      

      When wsrep_sst_method=mariabackup and a table is defined with DATA DIRECTORY, an SST completes and table data is available.
      When wsrep_sst_method=rsync and a table is defined with DATA DIRECTORY, an SST completes but the table cannot be queried:

      MariaDB [testdd]> show create table tab1;
      ERROR 1030 (HY000): Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
      

      Tested on 10.6.8-4-MariaDB-enterprise.

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            edward Edward Stoever
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.