Debian Codegraph @

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

raw
1 ##################################################
2 # Author: Jeb
3 # Date: 2007/04
4 # Purpose: To select out log name and start
5 # positions from ndb_apply_status table
6 ##################################################
7 echo select log_name, start_pos from mysql.ndb_apply_status;
8
9 if (!$source_file) {
10 die Missing value for $source_file;
11 }
12 if (!$source_start_pos) {
13 die Missing value for $source_start_pos;
14 }
15 if (!$source_end_pos) {
16 die Missing value for $source_end_pos;
17 }
18
19 let $binlog_file= `SELECT log_name FROM mysql.ndb_apply_status
20 WHERE server_id = $master_server_id`;
21 #echo binlog_file: $binlog_file;
22
23 let $binlog_start = `SELECT start_pos FROM mysql.ndb_apply_status
24 WHERE server_id = $master_server_id`;
25 #echo binlog_start: $binlog_start;
26
27 let $binlog_end = `SELECT end_pos FROM mysql.ndb_apply_status
28 WHERE server_id = $master_server_id`;
29 #echo binlog_end: $binlog_end;
30
31 if ($binlog_file != $source_file) {
32 echo Detected mismatching file;
33 echo master_server_id: $master_server_id;
34 echo source_file: $source_file;
35 echo binlog_file: $binlog_file;
36 eval SELECT log_name, start_pos, end_pos
37 FROM mysql.ndb_apply_status WHERE server_id = $master_server_id;
38 SELECT * FROM mysql.ndb_apply_status;
39 --source include/rpl_connection_master.inc
40 show binlog events;
41 die Mismatching log_name in ndb_apply_status;
42 }
43
44 if ($binlog_start != $source_start_pos) {
45 echo Detected mismatching start_pos;
46 echo master_server_id: $master_server_id;
47 echo source_start_pos: $source_start_pos;
48 echo binlog_start: $binlog_start;
49 eval SELECT log_name, start_pos, end_pos
50 FROM mysql.ndb_apply_status WHERE server_id = $master_server_id;
51 SELECT * FROM mysql.ndb_apply_status;
52 --source include/rpl_connection_master.inc
53 show binlog events;
54 die Mismatching start_pos in ndb_apply_status;
55 }
56
57 if ($binlog_end != $source_end_pos) {
58 echo Detected mismatching end_pos;
59 echo master_server_id: $master_server_id;
60 echo source_end_pos: $source_end_pos;
61 echo binlog_end: $binlog_end;
62 eval SELECT log_name, start_pos, end_pos
63 FROM mysql.ndb_apply_status WHERE server_id = $master_server_id;
64 SELECT * FROM mysql.ndb_apply_status;
65 --source include/rpl_connection_master.inc
66 show binlog events;
67 die Mismatching end_pos in ndb_apply_status;
68 }
69
70 # Reset parameters to make sure they are assigned by caller
71 let $source_file =;
72 let $source_start_pos =;
73 let $source_end_pos =;