Debian Codegraph @

mysql-test/suite/rpl/r/rpl_view_multi.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # Bug #25144 "replication / binlog with view breaks".
5 # Statements that used views didn't ensure that view were not modified
6 # during their execution. Indeed this led to incorrect binary log with
7 # statement based logging and as result to broken replication.
8 #
9 drop tables if exists t1, t2;
10 drop view if exists v1;
11 # Syncing slave with master
12 connection slave;
13 connect master2,127.0.0.1,root,,test,$MASTER_MYPORT,;
14 connection master;
15 create table t1 (i int);
16 create table t2 (i int);
17 create view v1 as select * from t1;
18 # First we try to concurrently execute statement that uses view
19 # and statement that drops it. We use "user" locks as means to
20 # suspend execution of first statement once it opens our view.
21 select get_lock("lock_bg25144", 1);
22 get_lock("lock_bg25144", 1)
23 1
24 connection master1;
25 insert into v1 values (get_lock("lock_bg25144", 100));
26 connection master2;
27 drop view v1;
28 connection master;
29 select release_lock("lock_bg25144");
30 release_lock("lock_bg25144")
31 1
32 connection master1;
33 select release_lock("lock_bg25144");
34 release_lock("lock_bg25144")
35 1
36 connection master2;
37 connection master;
38 # Check that insertion through view did happen.
39 select * from t1;
40 i
41 1
42 # Syncing slave with master
43 connection slave;
44 # Check that slave was able to replicate this sequence
45 # which means that we got correct binlog order.
46 select * from t1;
47 i
48 1
49 connection master;
50 # Now we will repeat the test by trying concurrently execute
51 # statement that uses a view and statement that alters it.
52 create view v1 as select * from t1;
53 select get_lock("lock_bg25144", 1);
54 get_lock("lock_bg25144", 1)
55 1
56 connection master1;
57 insert into v1 values (get_lock("lock_bg25144", 100));
58 connection master2;
59 alter view v1 as select * from t2;
60 connection master;
61 select release_lock("lock_bg25144");
62 release_lock("lock_bg25144")
63 1
64 connection master1;
65 select release_lock("lock_bg25144");
66 release_lock("lock_bg25144")
67 1
68 connection master2;
69 connection master;
70 # Second insertion should go to t1 as well.
71 select * from t1;
72 i
73 1
74 1
75 select * from t2;
76 i
77 # Syncing slave with master
78 connection slave;
79 # Now let us check that statements were logged in proper order
80 # So we have same result on slave.
81 select * from t1;
82 i
83 1
84 1
85 select * from t2;
86 i
87 connection master;
88 drop table t1, t2;
89 drop view v1;
90 # Syncing slave with master
91 connection slave;
92 include/rpl_end.inc