Debian Codegraph @

mysql-test/suite/rpl/t/rpl_start_alter_bugs.test

raw
1 #
2 # MDEV-22985 Assertion `!(thd->rgi_slave && thd->rgi_slave->did_mark_start_commit)' failed in ha_rollback_trans#
3 #
4 #
5
6 --source include/have_log_bin.inc
7 --source include/have_innodb.inc
8 --source include/master-slave.inc
9
10 --connection master
11 set global binlog_alter_two_phase=true;
12
13 --connection slave
14 stop slave;
15 SET global slave_parallel_threads=2;
16 set global slave_parallel_mode=optimistic;
17 start slave;
18 --connection master
19
20 CREATE TABLE t1 (i int primary key) ENGINE = InnoDB;
21 --connection master1
22 ALTER TABLE t1 DROP PRIMARY KEY;
23 ALTER TABLE t1 ADD UNIQUE KEY ui (i);
24 ALTER TABLE t1 ADD PRIMARY KEY (i);
25
26 --sync_slave_with_master
27
28 #MENT 1274
29 --connection master
30 drop table t1;
31 CREATE TABLE t1 (a int)engine=innodb;
32 ALTER TABLE t1 add column b int, LOCK=EXCLUSIVE;
33 drop table t1;
34 CREATE TABLE t1 (pk int)engine=innodb;
35 --error ER_CANT_DROP_FIELD_OR_KEY
36 ALTER TABLE t1 DROP FOREIGN KEY y, LOCK=EXCLUSIVE;
37 drop table t1;
38 --sync_slave_with_master
39 --connection master
40 set global binlog_alter_two_phase=false;
41
42 --connection slave
43 --source include/stop_slave.inc
44 SET global slave_parallel_threads=0;
45 --source include/start_slave.inc
46
47 --source include/rpl_end.inc