97 lines
3.1 KiB
Plaintext
97 lines
3.1 KiB
Plaintext
# 1. PLUGIN not loaded - clone local
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
ERROR HY000: Plugin 'clone' is not loaded
|
|
# 1A. PLUGIN not installed - Uninstall plugin
|
|
UNINSTALL PLUGIN clone;
|
|
ERROR 42000: PLUGIN clone does not exist
|
|
INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
|
|
# 1B. PLUGIN already loaded - Install plugin
|
|
INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
|
|
ERROR HY000: Function 'clone' already exists
|
|
#1C. Clone data without error
|
|
SET GLOBAL clone_autotune_concurrency = OFF;
|
|
SET GLOBAL clone_max_concurrency = 8;
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
select ID, STATE, ERROR_NO from performance_schema.clone_status;
|
|
ID STATE ERROR_NO
|
|
1 Completed 0
|
|
select ID, STAGE, STATE from performance_schema.clone_progress;
|
|
ID STAGE STATE
|
|
1 DROP DATA Completed
|
|
1 FILE COPY Completed
|
|
1 PAGE COPY Completed
|
|
1 REDO COPY Completed
|
|
1 FILE SYNC Completed
|
|
1 RESTART Not Started
|
|
1 RECOVERY Not Started
|
|
# 2A. Incorrect PATH - Relative path
|
|
SET GLOBAL clone_autotune_concurrency = OFF;
|
|
SET GLOBAL clone_max_concurrency = 8;
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
ERROR HY000: Incorrect path value: 'CLONE_DATADIR'
|
|
select ID, STATE, ERROR_NO from performance_schema.clone_status;
|
|
ID STATE ERROR_NO
|
|
1 Completed 0
|
|
select ID, STAGE, STATE from performance_schema.clone_progress;
|
|
ID STAGE STATE
|
|
1 DROP DATA Completed
|
|
1 FILE COPY Completed
|
|
1 PAGE COPY Completed
|
|
1 REDO COPY Completed
|
|
1 FILE SYNC Completed
|
|
1 RESTART Not Started
|
|
1 RECOVERY Not Started
|
|
# 2B. Incorrect PATH - Too long
|
|
SET GLOBAL clone_autotune_concurrency = OFF;
|
|
SET GLOBAL clone_max_concurrency = 8;
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
ERROR HY000: The path specified for DATA DIRECTORY is too long.
|
|
select ID, STATE, ERROR_NO from performance_schema.clone_status;
|
|
ID STATE ERROR_NO
|
|
1 Completed 0
|
|
select ID, STAGE, STATE from performance_schema.clone_progress;
|
|
ID STAGE STATE
|
|
1 DROP DATA Completed
|
|
1 FILE COPY Completed
|
|
1 PAGE COPY Completed
|
|
1 REDO COPY Completed
|
|
1 FILE SYNC Completed
|
|
1 RESTART Not Started
|
|
1 RECOVERY Not Started
|
|
# 2C. Incorrect PATH - Within data directory
|
|
SET GLOBAL clone_autotune_concurrency = OFF;
|
|
SET GLOBAL clone_max_concurrency = 8;
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
ERROR HY000: Path is within the current data directory 'CLONE_DATADIR'
|
|
select ID, STATE, ERROR_NO from performance_schema.clone_status;
|
|
ID STATE ERROR_NO
|
|
1 Completed 0
|
|
select ID, STAGE, STATE from performance_schema.clone_progress;
|
|
ID STAGE STATE
|
|
1 DROP DATA Completed
|
|
1 FILE COPY Completed
|
|
1 PAGE COPY Completed
|
|
1 REDO COPY Completed
|
|
1 FILE SYNC Completed
|
|
1 RESTART Not Started
|
|
1 RECOVERY Not Started
|
|
# 2D. Incorrect PATH - data directory exists
|
|
SET GLOBAL clone_autotune_concurrency = OFF;
|
|
SET GLOBAL clone_max_concurrency = 8;
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
ERROR HY000: Can't create database 'CLONE_DATADIR'; database exists
|
|
select ID, STATE, ERROR_NO from performance_schema.clone_status;
|
|
ID STATE ERROR_NO
|
|
1 Completed 0
|
|
select ID, STAGE, STATE from performance_schema.clone_progress;
|
|
ID STAGE STATE
|
|
1 DROP DATA Completed
|
|
1 FILE COPY Completed
|
|
1 PAGE COPY Completed
|
|
1 REDO COPY Completed
|
|
1 FILE SYNC Completed
|
|
1 RESTART Not Started
|
|
1 RECOVERY Not Started
|
|
#Cleanup
|
|
UNINSTALL PLUGIN clone;
|