Debian Codegraph @

mysql-test/suite/group_replication/include/gr_binlog_events_assert_error.inc

raw
1 # ==== Purpose ====
2 #
3 # This script which is part of gr_binlog_events_verifications verifies
4 # that events obeys following GR requirements:
5 # - tables having no primary keys
6 # - tables using non-innodb storage engine
7 # - tables with foreign key with cascade clause
8 #
9 # ==== Usage ====
10 #
11 # --let $slave_sql_errno= NUMBER
12 # --let $slave_sql_error= TEXT
13 # --let $gr_test_name= NAME
14 # [--let $rpl_mysqlbinlog= 1]
15 # [--let $rpl_slave_connection_name= <connection_name>]
16 # [--let $rpl_server_port= <server_port>]
17 # [--let $rpl_start_binlog_pos= NUMBER]
18 # --let $rpl_curr_gtid= UUID:ID
19 # --let $rpl_error_log= FILE
20 # --let $slave_sql_error= TEXT
21 # [--let $rpl_gr_grep_primary_error= [0|1]]
22 # [--let $rpl_gr_grep_innodb_error= [0|1]]
23 # [--let $rpl_gr_grep_foreign_cascade_error= [0|1]]
24 # [--let $rpl_gr_grep_primary_error_message= TEXT]
25 # [--let $rpl_gr_grep_innodb_error_message= TEXT]
26 # [--let =$rpl_gr_grep_foreign_cascade_error_message= TEXT]
27 # --source ../extra/gr_binlog_events_assert_error.test
28 #
29 #
30 # Parameters:
31 #
32 # $slave_sql_errno
33 # The expected SQL error number.
34 #
35 # $slave_sql_error
36 # The expected SQL error message.
37 #
38 # $gr_test_name
39 # The current test name getting executed.
40 #
41 # $rpl_mysqlbinlog
42 # If not set the binlog events are applied through asynchronous
43 # replication otherwise through mysqlbinlog.
44 #
45 # $rpl_slave_connection_name
46 # The server connection name to which the binlog events are to
47 # be applied.
48 #
49 # $rpl_server_port
50 # The server port number to which the binlog events are to
51 # be applied. This variable is only required when $rpl_mysqlbinlog=1
52 # i.e. when binlog events are to be applied using mysqlbinlog
53 # utility.
54 #
55 # $rpl_start_binlog_pos
56 # The server port number to which the binlog events are to
57 # be applied. This variable is only required when $rpl_mysqlbinlog=1
58 # i.e. when binlog events are to be applied using mysqlbinlog
59 # utility.
60 #
61 # $rpl_curr_gtid
62 # The current gtid for which error message has been logged in error log.
63 #
64 # $rpl_error_log
65 # The error log file to search.
66 #
67 # $rpl_gr_grep_primary_error_message
68 # The error message which is written to error log when table
69 # doesn't have primary key.
70 #
71 # $rpl_gr_grep_innodb_error_message
72 # The error message which is written to error log when table
73 # is of non-innodb storage engine.
74 #
75 # $rpl_gr_grep_foreign_cascade_error_message
76 # The error message which is written to error log when table
77 # has foreign key cascade clause.
78 #
79 # $rpl_gr_grep_primary_error
80 # If set will search for $rpl_gr_grep_primary_error_message in error log.
81 #
82 # $rpl_gr_grep_innodb_error
83 # If set will search for $rpl_gr_grep_innodb_error_message in error log.
84 #
85 # $rpl_gr_grep_foreign_cascade_error
86 # If set will search for $rpl_gr_grep_foreign_cascade_error_message in
87 # error log.
88 #
89 ################################################################################
90
91 if (!$gr_test_name)
92 {
93 --die ERROR IN TEST: You must set $gr_test_name before sourcing gr_binlog_events_assert_error.inc
94 }
95
96 if (!$slave_sql_errno)
97 {
98 --die ERROR IN TEST: You must set $slave_sql_errno before sourcing gr_binlog_events_assert_error.inc
99 }
100
101 if (!$slave_sql_error)
102 {
103 --die ERROR IN TEST: You must set $slave_sql_error before sourcing gr_binlog_events_assert_error.inc
104 }
105
106 if (!$rpl_error_log)
107 {
108 --die ERROR IN TEST: You must set $rpl_error_log before sourcing gr_binlog_events_assert_error.inc
109 }
110
111 if (`SELECT "$rpl_gr_grep_primary_error" = "0" and "$rpl_gr_grep_innodb_error" = "0" and "$rpl_gr_grep_foreign_cascade_error" = "0"`)
112 {
113 --die ERROR IN TEST: You must set either of rpl_gr_grep_primary_error or rpl_gr_grep_innodb_error or rpl_gr_grep_foreign_cascade_error before sourcing gr_binlog_events_assert_error.inc
114 }
115
116 # wait for slave channel to error out
117 if (!$rpl_mysqlbinlog)
118 {
119 --let $rpl_connection_name= $rpl_slave_connection_name
120 --source include/rpl_connection.inc
121
122 --let $rpl_skip_gtid= $rpl_curr_gtid
123 --source include/wait_for_slave_sql_error_and_restart.inc
124 }
125
126 # apply binlog events using mysqlbinlog and expect error
127 if ($rpl_mysqlbinlog)
128 {
129 # Save mysqlbinlog output in a file
130 --let $_rpl_server_datadir= `SELECT @@DATADIR`
131 --let $_rpl_server_binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
132
133 --exec $MYSQL_BINLOG --start-position=$rpl_start_binlog_pos --force-if-open $_rpl_server_datadir/$_rpl_server_binlog_file > $rpl_out_binlog
134
135 # save binlog position
136 --let $rpl_start_binlog_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
137
138 # Execute mysqlbinlog output of server2 on server1. Expect error.
139 --let $rpl_connection_name= $rpl_slave_connection_name
140 --source include/rpl_connection.inc
141
142 if (!$rpl_server_port)
143 {
144 --let $rpl_server_port= `SELECT @@PORT`
145 }
146
147 --let $_rpl_server_connection_args= --user=root --host=127.0.0.1 --port=$rpl_server_port
148 --error 1
149 --exec $MYSQL $_rpl_server_connection_args -e "source $rpl_out_binlog"
150 }
151
152 # assert primary key error message in error log
153 if ($rpl_gr_grep_primary_error)
154 {
155 --let $grep_file= $rpl_error_log
156 --let $grep_pattern=.* \[ERROR\].*$rpl_gr_grep_primary_error_message.*
157 --let $grep_output= boolean
158 --source include/grep_pattern.inc
159
160 --let $rpl_gr_grep_primary_error= 0
161 }
162
163 # assert non-innodb table found error message in error log
164 if ($rpl_gr_grep_innodb_error)
165 {
166 --let $grep_file= $rpl_error_log
167 --let $grep_pattern=.* \[ERROR\].*$rpl_gr_grep_innodb_error_message.*
168 --let $grep_output= boolean
169 --source include/grep_pattern.inc
170
171 --let $rpl_gr_grep_innodb_error= 0
172 }
173
174 # assert foreign key with cascade clause found error message in error log
175 if ($rpl_gr_grep_foreign_cascade_error)
176 {
177 --let $grep_file= $rpl_error_log
178 --let $grep_pattern=.* \[ERROR\].*$rpl_gr_grep_foreign_cascade_error_message.*
179 --let $grep_output= boolean
180 --source include/grep_pattern.inc
181
182 --let $rpl_gr_grep_foreign_cascade_error= 0
183 }
184
185 # assert for events applied through asynchronous replication
186 # as events applied through mysqlbinlog won't have these errors
187 if (!$rpl_mysqlbinlog)
188 {
189 --let $_tmp_assert_select = `SELECT REPLACE('$slave_sql_error', '.*:.*', $rpl_curr_gtid)`
190
191 --let $grep_file= $rpl_error_log
192 --let $grep_pattern=.* \[ERROR\].*$_tmp_assert_select.*
193 --let $grep_output= print_count
194 --source include/grep_pattern.inc
195 }