Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_conflict_info.inc

raw
1 --echo Conflict algorithm counter diff :
2 --disable_query_log
3 let $resmax=
4 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_max
5 FROM performance_schema.global_status
6 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_MAX"`;
7 let $resold=
8 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_old
9 FROM performance_schema.global_status
10 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_OLD"`;
11 let $resmaxdelwin=
12 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_max_del_win
13 FROM performance_schema.global_status
14 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_MAX_DEL_WIN"`;
15 let $resmaxins=
16 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_max_ins
17 FROM performance_schema.global_status
18 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_MAX_INS"`;
19 let $resmaxdelwinins=
20 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_max_del_win_ins
21 FROM performance_schema.global_status
22 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_MAX_DEL_WIN_INS"`;
23 let $resepoch=
24 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch
25 FROM performance_schema.global_status
26 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_EPOCH"`;
27 let $resepoch2=
28 `SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch2
29 FROM performance_schema.global_status
30 WHERE VARIABLE_NAME = "NDB_CONFLICT_FN_EPOCH2"`;
31 let $resdeldel=
32 `SELECT VARIABLE_VALUE-@init_ndb_epoch_delete_delete
33 FROM performance_schema.global_status
34 WHERE VARIABLE_NAME = "NDB_CONFLICT_EPOCH_DELETE_DELETE_COUNT"`;
35 if ($resmax)
36 {
37 --eval select $resmax as ndb_conflict_fn_max
38 }
39 if ($resold)
40 {
41 --eval select $resold as ndb_conflict_fn_old
42 }
43 if ($resmaxdelwin)
44 {
45 --eval select $resmaxdelwin as ndb_conflict_fn_max_del_win
46 }
47 if ($resepoch)
48 {
49 --eval select $resepoch as ndb_conflict_fn_epoch
50 }
51 if ($resepoch2)
52 {
53 --eval select $resepoch2 as ndb_conflict_fn_epoch2
54 }
55 if ($resdeldel)
56 {
57 --eval select $resdeldel as ndb_epoch_delete_delete
58 }
59 if ($resmaxins)
60 {
61 --eval select $resmaxins as ndb_conflict_fn_max_ins
62 }
63 if ($resmaxdelwinins)
64 {
65 --eval select $resmaxdelwinins as ndb_conflict_fn_max_del_win_ins
66 }
67
68
69 #SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_old AS ndb_conflict_fn_old FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_OLD";
70 #SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_max_del_win AS ndb_conflict_fn_max_del_win FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_MAX_DEL_WIN";
71 #SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch AS ndb_conflict_fn_epoch FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_EPOCH";
72 #SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch2 AS ndb_conflict_fn_epoch2 FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_EPOCH2";
73 #SELECT VARIABLE_VALUE-@init_ndb_epoch_delete_delete AS ndb_epoch_delete_delete FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_EPOCH_DELETE_DELETE_COUNT";
74 --enable_query_log
75 --echo Exception table contents
76 if (!$extended_exceptions_table)
77 {
78 --replace_column 3 # 5 # 6 #
79 --error 0,1146
80 SELECT server_id, master_server_id, master_epoch, count, a, d FROM `t1$EX` ORDER BY server_id, master_server_id, master_epoch, count;
81 --replace_column 3 # 4 #
82 --error 0,1146
83 SELECT * FROM `t1$EX` ORDER BY a, d;
84 }
85 if ($extended_exceptions_table)
86 {
87 --replace_column 3 # 5 # 6 # 7 # 8 # 9 # 10 # 11 #
88 --error 0,1146
89 SELECT ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count, a, b$old, b$new, d FROM `t1$EX` ORDER BY ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count;
90 --replace_column 3 # 4 # 8 # 9 # 10 # 11 #
91 --error 0,1146
92 SELECT * FROM `t1$EX` ORDER BY ndb$count;
93 --error 0,1146
94 SELECT ndb$op_type, ndb$cft_cause FROM `t1$EX` ORDER BY ndb$op_type, ndb$cft_cause;
95 }