Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_gtid_bgc_ticket_manager.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4 --let $option_name = replica_parallel_type
5 --let $option_value = 'LOGICAL_CLOCK'
6 --source include/only_with_option.inc
7 --let $option_name = replica_parallel_workers
8 --let $option_operator = !=
9 --let $option_value = 0
10 --source include/only_with_option.inc
11 --let $option_name = binlog_order_commits
12 --let $option_value = 1
13 --source include/only_with_option.inc
14 --let $rpl_skip_start_slave = 1
15 --source include/master-slave.inc
16
17 --source include/rpl_connection_slave.inc
18 let $sysvars_to_save = [
19 "GLOBAL.replica_preserve_commit_order",
20 "GLOBAL.replica_parallel_workers"
21 ];
22 --source include/save_sysvars.inc
23 SET @@GLOBAL.replica_preserve_commit_order = 0;
24 SET @@GLOBAL.replica_parallel_workers = 4;
25 --source include/start_slave.inc
26
27 --source include/rpl_connection_master.inc
28 CREATE TABLE t (
29 c1 INT NOT NULL PRIMARY KEY,
30 c2 INT
31 );
32 INSERT INTO t VALUES (0, 0);
33
34 --let $debug_point = set_commit_parent_100
35 --source include/add_debug_point.inc
36
37 --source include/sync_slave_sql_with_master.inc
38
39 --let $save_binlog_position_in_sql = 1
40 --source include/save_binlog_position.inc
41
42 --source include/rpl_connection_master.inc
43 --let $gtid_uuid = 435aeb3e-cc91-11ec-a715-6ba04eb9487e
44 --let $auxiliary_connection = slave
45
46 --connect(con1,localhost,root,,)
47 --let $statement_connection = con1
48 --let $timestamp = 1
49 --let $statement = SET gtid_next = "$gtid_uuid:1"; INSERT INTO t VALUES (1, 1)
50 --let $sync_point = before_assign_session_to_bgc_ticket
51 --source include/execute_to_conditional_timestamp_sync_point.inc
52
53 --connect(con2,localhost,root,,)
54 --let $statement_connection = con2
55 --let $timestamp = 2
56 --let $statement = SET gtid_next = "$gtid_uuid:2"; INSERT INTO t VALUES (2, 2)
57 --let $sync_point = before_wait_on_ticket
58 --source include/execute_to_conditional_timestamp_sync_point.inc
59
60 --connect(con3,localhost,root,,)
61 --let $statement_connection = con3
62 --let $timestamp = 3
63 --let $statement = SET gtid_next = "$gtid_uuid:3"; INSERT INTO t VALUES (3, 3)
64 --let $sync_point = before_wait_on_ticket
65 --source include/execute_to_conditional_timestamp_sync_point.inc
66
67 --source include/rpl_connection_master.inc
68 --let $statement_connection = con1
69 --let $timestamp = 1
70 --let $sync_point = before_assign_session_to_bgc_ticket
71 --let $to_sync_point = inside_wait_on_ticket
72 --source include/execute_from_conditional_timestamp_sync_point.inc
73 --let $to_sync_point =
74
75 --let $statement_connection = con1
76 --let $timestamp = 1
77 --let $sync_point = inside_wait_on_ticket
78 --source include/execute_from_conditional_timestamp_sync_point.inc
79
80 --source include/rpl_connection_master.inc
81 --let $statement_connection = con2
82 --let $timestamp = 2
83 --let $sync_point = before_wait_on_ticket
84 --source include/execute_from_conditional_timestamp_sync_point.inc
85
86 --source include/rpl_connection_master.inc
87 --let $statement_connection = con3
88 --let $timestamp = 3
89 --let $sync_point = before_wait_on_ticket
90 --source include/execute_from_conditional_timestamp_sync_point.inc
91
92 --disconnect con1
93 --disconnect con2
94 --disconnect con3
95
96 --source include/rpl_connection_master.inc
97 --let $debug_point = set_commit_parent_100
98 --source include/remove_debug_point.inc
99
100 --source include/sync_slave_sql_with_master.inc
101 --let $wait_condition = SELECT COUNT(1) = 3 FROM t WHERE c1 > 0;
102 --source include/wait_condition.inc
103
104 --let $events_for_1 = Gtid/.*GTID_NEXT= '$gtid_uuid:1' # !Begin # !Insert # !Commit
105 --let $events_for_2 = Gtid/.*GTID_NEXT= '$gtid_uuid:2' # !Begin # !Insert # !Commit
106 --let $events_for_3 = Gtid/.*GTID_NEXT= '$gtid_uuid:3' # !Begin # !Insert # !Commit
107
108 --let $event_sequence = $events_for_2 # $events_for_3 # $events_for_1
109 --source include/assert_binlog_events.inc
110
111 --source include/stop_slave.inc
112 --source include/restore_sysvars.inc
113 --source include/start_slave.inc
114
115 --source include/rpl_connection_master.inc
116 DROP TABLE t;
117 --source include/rpl_end.inc