binlog_auto_increment_bug33029.test 1.85 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
# BUG#33029 5.0 to 5.1 replication fails on dup key when inserting
# using a trig in SP

# For all 5.0 up to 5.0.58 exclusive, and 5.1 up to 5.1.12 exclusive,
# if one statement in a SP generated AUTO_INCREMENT value by the top
# statement, all statements after it would be considered generated
# AUTO_INCREMENT value by the top statement, and a erroneous INSERT_ID
# value might be associated with these statement, which could cause
# duplicate entry error and stop the slave.

# Test if the slave can replicate from such a buggy master

# The bug33029-slave-relay-bin.000001 file is the
# slave-replay-bin.000003 file generated by run the
# rpl_auto_increment_bug33029.test with clean up statements at the end
# of the test case removed on a buggy 5.0 server

unknown's avatar
unknown committed
18 19
source include/have_log_bin.inc;

20 21 22 23
# Need to restore this at the end; CHANGE MASTER modifies it (see the
# manual for CHANGE MASTER).
SET @old_relay_log_purge= @@global.relay_log_purge;

unknown's avatar
unknown committed
24
let $MYSQLD_DATADIR= `select @@datadir`;
25

unknown's avatar
unknown committed
26 27 28
copy_file $MYSQL_TEST_DIR/std_data/bug33029-slave-relay-bin.000001 $MYSQLD_DATADIR/slave-relay-bin.000001;

write_file $MYSQLD_DATADIR/slave-relay-bin.index;
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
slave-relay-bin.000001
EOF

change master to
  MASTER_HOST='dummy.localdomain',
  RELAY_LOG_FILE='slave-relay-bin.000001',
  RELAY_LOG_POS=4;

start slave sql_thread;
disable_result_log;
select MASTER_POS_WAIT('master-bin.000001', 3776);
enable_result_log;

echo # Result on slave;
SELECT * FROM t1;
SELECT * FROM t2;
unknown's avatar
unknown committed
45 46 47 48 49 50 51 52 53

# clean up
disable_warnings;
DROP TABLE IF EXISTS t1, t2;
DROP PROCEDURE IF EXISTS p1;
DROP PROCEDURE IF EXISTS p2;
DROP FUNCTION IF EXISTS f1;
DROP TRIGGER IF EXISTS tr1;
enable_warnings;
54 55

stop slave sql_thread;
56
reset slave;
57
source include/wait_for_slave_sql_to_stop.inc;
58 59
remove_file $MYSQLD_DATADIR/slave-relay-bin.000001;
remove_file $MYSQLD_DATADIR/slave-relay-bin.index;
60

61
SET @@global.relay_log_purge= @old_relay_log_purge;