|
1
by brian
clean slate |
1 |
source include/have_binlog_format_mixed_or_statement.inc; |
2 |
source include/have_debug.inc; |
|
3 |
source include/master-slave.inc; |
|
4 |
||
5 |
# We do this little stunt to make sure that the slave has started
|
|
6 |
# before we stop it again.
|
|
7 |
connection master; |
|
8 |
CREATE TABLE t1 (a INT, b INT); |
|
9 |
INSERT INTO t1 VALUES (1,10); |
|
10 |
sync_slave_with_master; |
|
11 |
source include/show_slave_status.inc; |
|
12 |
||
13 |
# Now we feed it a load data infile, which should make it stop with a
|
|
14 |
# fatal error.
|
|
15 |
connection master; |
|
16 |
LOAD DATA INFILE '../std_data_ln/rpl_loaddata.dat' INTO TABLE t1; |
|
17 |
||
18 |
connection slave; |
|
19 |
wait_for_slave_to_stop; |
|
20 |
source include/show_slave_status.inc; |
|
21 |
||
22 |
connection slave; |
|
23 |
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; |
|
24 |
START SLAVE; |
|
25 |
||
26 |
connection master; |
|
27 |
DROP TABLE t1; |
|
28 |
sync_slave_with_master; |
|
29 |