|
1
by brian
clean slate |
1 |
# Bug#12691: Exec_master_log_pos corrupted with SQL_SLAVE_SKIP_COUNTER |
2 |
# Date: 01/31/2008 |
|
3 |
# Added: Serge Kozlov <skozlov@mysql.com> |
|
4 |
||
5 |
--source include/master-slave.inc |
|
6 |
--connection master |
|
7 |
--source include/have_binlog_format_mixed_or_statement.inc |
|
8 |
||
9 |
--echo |
|
10 |
--echo **** On Master **** |
|
11 |
CREATE TABLE t1 (b CHAR(10)); |
|
12 |
--echo |
|
13 |
--echo **** On Slave **** |
|
14 |
--sync_slave_with_master |
|
15 |
STOP SLAVE; |
|
16 |
--source include/wait_for_slave_to_stop.inc |
|
17 |
||
18 |
--connection master |
|
19 |
||
20 |
--echo |
|
21 |
--echo **** On Master **** |
|
|
319.1.1
by Grant Limberg
renamed all instances of MYSQL_ to DRIZZLE_ |
22 |
--exec cp $DRIZZLE_TEST_DIR/suite/bugs/data/rpl_bug12691.dat $MYSQLTEST_VARDIR/tmp/ |
|
1
by brian
clean slate |
23 |
--echo LOAD DATA INFILE FILENAME |
24 |
--disable_query_log |
|
25 |
--eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/rpl_bug12691.dat' INTO TABLE t1 FIELDS TERMINATED BY '|' |
|
26 |
--enable_query_log |
|
27 |
--remove_file $MYSQLTEST_VARDIR/tmp/rpl_bug12691.dat |
|
28 |
||
29 |
SELECT COUNT(*) FROM t1; |
|
30 |
||
31 |
--replace_column 2 # 5 # |
|
32 |
--replace_regex /Server ver: .+/Server ver: #/ /table_id: [0-9]+/table_id: #/ /COMMIT.+xid=[0-9]+.+/#/ /file_id=[0-9]+/file_id=#/ /block_len=[0-9]+/block_len=#/ /'.+'/FILENAME/ |
|
33 |
SHOW BINLOG EVENTS; |
|
34 |
||
35 |
--save_master_pos |
|
36 |
||
37 |
--connection slave |
|
38 |
--echo |
|
39 |
--echo **** On Slave **** |
|
40 |
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; |
|
41 |
START SLAVE; |
|
42 |
--source include/wait_for_slave_to_start.inc |
|
43 |
--sync_with_master |
|
44 |
||
45 |
SELECT COUNT(*) FROM t1; |
|
46 |
||
47 |
# Clean up |
|
48 |
--connection master |
|
49 |
--echo |
|
50 |
--echo **** On Master **** |
|
51 |
DROP TABLE t1; |
|
52 |
--sync_slave_with_master
|
|
53 |