Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_last_conflict_epoch_var.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 Setup circular replication
7 SLAVE_SERVER_ID: 3
8 Warnings:
9 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
10 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
11 Warnings:
12 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
13 MASTER_SERVER_ID: 1
14 Setup ndb_replication and t1 exceptions table
15 Populate ndb_replication table as necessary
16 create table test.t1 (
17 a int primary key,
18 b int,
19 c varchar(2000)) engine=ndb;
20 insert into test.t1 values (1,1,repeat("B", 1000));
21 Stopping Primary -> Secondary replication
22 stop slave;
23 Warnings:
24 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
25 Stopping Secondary -> Primary replication
26 stop slave;
27 Warnings:
28 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
29 Making change on Primary
30 update test.t1 set b=2 where a=1;
31 Making conflicting change on Secondary
32 begin;
33 update test.t1 set b=3 where a=1;
34 insert into test.t1 values (2,2,repeat("A", 1000));
35 commit;
36 Capturing session epoch from Master
37 Show that last_conflict_epoch is 0
38 Variable_name Value
39 Ndb_conflict_last_conflict_epoch 0
40 Restart Secondary->Primary replication
41 Warnings:
42 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
43 Check that max_replicated_epoch is
44 still < the saved session epoch
45 Max replicated epoch should be < committed epoch
46 @max_replicated_epoch < @master_session_epoch
47 1
48 Some invariants :
49 @conflict_detected_epoch != 0
50 1
51 @conflict_detected_epoch > @max_replicated_epoch
52 1
53 Primary has detected the problem, but Secondary
54 is unaware as the slave is offline.
55 Now bring it back
56 Warnings:
57 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
58 Now sync up
59 Now lets check that the max replicated epoch
60 on the Primary is == the last_conflict_epoch
61 @max_replicated_epoch = @conflict_detected_epoch
62 1
63 Cleanup
64 Warnings:
65 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
66 include/rpl_end.inc