# Test clone error cases with concurrent DDL --source include/have_debug_sync.inc --source include/count_sessions.inc --disable_query_log call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash"); call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash."); --enable_query_log --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new --let $CLONE_DATADIR2 = $MYSQL_TMP_DIR/data_new2 --let $MYSQLD_DATADIR= `select @@datadir;` --replace_result $CLONE_PLUGIN CLONE_PLUGIN --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN' --echo # 1. CLONE blocked by DDL at beginning --connect (con1,localhost,root,,) --echo # In connection CON1 SET DEBUG_SYNC = 'fil_ibd_created_space SIGNAL start_clone WAIT_FOR resume_ddl_1'; --send CREATE TABLE t1(col1 int) --connection default --echo # In connection DEFAULT --let $CON_ID= `SELECT CONNECTION_ID()` SET DEBUG_SYNC = 'now WAIT_FOR start_clone'; SET DEBUG_SYNC = 'clone_begin_wait_ddl SIGNAL start_ddl_1 WAIT_FOR resume_clone_1'; SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_2 WAIT_FOR resume_clone_2'; --source ../include/clone_command_send.inc --connect (con2,localhost,root,,) --echo # In connection CON2 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_1'; SET DEBUG_SYNC = 'clone_notify_ddl_before_state_block SIGNAL resume_ddl_1'; --send CREATE TABLE t2(col1 int) --connection con1 --echo # In connection CON1 --echo # Reap CREATE TABLE t1 --reap SET DEBUG_SYNC= 'now SIGNAL resume_clone_1'; --connection con2 --echo # In connection CON2 --echo # Reap CREATE TABLE t2 --reap --echo # Disconnect CON2 --disconnect con2 --connection con1 --echo # In connection CON1 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_2'; --echo # 1A. TOO MANY CLONE IN PROGRESS --let $CLONE_DATADIR = $CLONE_DATADIR2 --let $clone_err = ER_CLONE_TOO_MANY_CONCURRENT_CLONES --source ../include/clone_command.inc --let $clone_err = 0 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new --echo # 2. ALTER INSTANCE while clone in progress --error ER_CLONE_IN_PROGRESS ALTER INSTANCE DISABLE INNODB REDO_LOG; INSERT INTO t1 values(10), (20), (30); SELECT * FROM t1 ORDER BY col1; --echo # 3. ALTER DISCARD while clone in progress --error ER_CLONE_IN_PROGRESS ALTER TABLE t1 DISCARD TABLESPACE; --echo # 4. ALTER IMPORT while clone in progress --error ER_CLONE_IN_PROGRESS ALTER TABLE t1 IMPORT TABLESPACE; --echo # 5. KILL CLONE command while in progress --replace_result $CON_ID CON_ID --eval KILL QUERY $CON_ID SET DEBUG_SYNC= 'now SIGNAL resume_clone_2'; connection default; --echo # In connection DEFAULT --error ER_QUERY_INTERRUPTED --reap --force-rmdir $CLONE_DATADIR SET DEBUG_SYNC = 'RESET'; DROP TABLE t2; --echo # 6. Force clone to abort by DDL SET GLOBAL DEBUG = '+d,clone_ddl_error_abort'; SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone'; --source ../include/clone_command_send.inc --connection con1 --echo # In connection CON1 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl'; SET DEBUG_SYNC = 'clone_notify_ddl_before_state_block SIGNAL resume_clone'; CREATE TABLE t2(col1 int); INSERT INTO t2 VALUES(10), (20), (30); SELECT * FROM t2 ORDER BY col1; connection default; --echo # In connection DEFAULT --error ER_CLONE_DDL_IN_PROGRESS --reap SET GLOBAL DEBUG = '-d,clone_ddl_error_abort'; --force-rmdir $CLONE_DATADIR SET DEBUG_SYNC = 'RESET'; --echo #Cleanup DROP TABLE t1; DROP TABLE t2; connection default; --echo # In connection DEFAULT disconnect con1; SET DEBUG_SYNC = 'RESET'; --echo # Attempt to uninstall clone if there --error 0, ER_PLUGIN_CANNOT_BE_UNINSTALLED UNINSTALL PLUGIN clone; --echo # Restart server --source include/wait_until_count_sessions.inc --source include/restart_mysqld.inc --echo # Uninstall clone if there --error 0, ER_SP_DOES_NOT_EXIST UNINSTALL PLUGIN clone;