Debian Codegraph @

mysql-test/suite/mariabackup/alter_copy_race.result

raw
1 # xtrabackup backup
2 CREATE TABLE t1(i int) ENGINE=InnoDB;
3 INSERT into t1 values(1);
4 connect con2, localhost, root,,;
5 connection con2;
6 set lock_wait_timeout=1;
7 SET debug_sync='copy_data_between_tables_before_reset_backup_lock SIGNAL go WAIT_FOR after_backup_stage_block_ddl';
8 SET debug_sync='alter_table_after_temp_table_drop SIGNAL temp_table_dropped';
9 SET debug_sync='now WAIT_FOR after_backup_stage_start';ALTER TABLE test.t1 FORCE, algorithm=COPY;|
10 connection default;
11 connection con2;
12 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
13 SET debug_sync='RESET';
14 disconnect con2;
15 connection default;
16 # xtrabackup prepare
17 # shutdown server
18 # remove datadir
19 # xtrabackup move back
20 # restart
21 SELECT * FROM t1;
22 i
23 1
24 DROP TABLE t1;
25 #
26 # MDEV-38041 MariaBackup fails during rollback of
27 # inplace FTS alter table
28 #
29 CREATE TABLE t1(f1 int, f2 char(100), fulltext(f2)) ENGINE=InnoDB;
30 INSERT into t1 values(1, "MariaDB"), (1, "MySQL");
31 connect con2, localhost, root,,;
32 set lock_wait_timeout=1;
33 SET debug_sync='copy_data_between_tables_before_reset_backup_lock SIGNAL go WAIT_FOR after_backup_stage_block_ddl';
34 SET debug_sync='alter_table_after_temp_table_drop SIGNAL temp_table_dropped';
35 SET debug_sync='now WAIT_FOR after_backup_stage_start';ALTER TABLE test.t1 ADD PRIMARY KEY(f1), algorithm=COPY;|
36 connection default;
37 connection con2;
38 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
39 SET debug_sync='RESET';
40 disconnect con2;
41 connection default;
42 DROP TABLE t1;