Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.6.8
-
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.