[MDEV-29037] Cluster SST does not work when table defined with "DATA DIRECTORY" and wsrep_sst_method=rsync Created: 2022-07-05  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.6.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Edward Stoever Assignee: Julius Goryavsky
Resolution: Incomplete Votes: 0
Labels: 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.


Generated at Thu Feb 08 10:05:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.