diff options
author | sasha@mysql.sashanet.com <> | 2001-04-10 20:56:54 -0600 |
---|---|---|
committer | sasha@mysql.sashanet.com <> | 2001-04-10 20:56:54 -0600 |
commit | 102c1945eb20afcfc727ab9cec981f4b5204ed8c (patch) | |
tree | c052d8d91d91bacc775ebdfd8e299c23e4a6e100 /mysql-test/t/rpl000001.test | |
parent | 54b9d367f9fd32e1c57b0abd53c6299fdafad81f (diff) | |
download | mariadb-git-102c1945eb20afcfc727ab9cec981f4b5204ed8c.tar.gz |
do not log the drop internal temporary tables into the binary log
mark killed partially completed updates with an error code in binlog
stop replication if the master reports a possible partial/killed update
test partially killed update
Diffstat (limited to 'mysql-test/t/rpl000001.test')
-rw-r--r-- | mysql-test/t/rpl000001.test | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/t/rpl000001.test b/mysql-test/t/rpl000001.test index c7b1f817e81..c2a6b2aaec9 100644 --- a/mysql-test/t/rpl000001.test +++ b/mysql-test/t/rpl000001.test @@ -20,4 +20,46 @@ drop table t1; save_master_pos; connection slave; sync_with_master; +#test handling of aborted connection in the middle of update +connection master; +drop table if exists t1,t2; +create table t1(n int); +let $1=30000; +while ($1) +{ + eval insert into t1 values($1); + dec $1; +} +create table t2(id int); +insert into t2 values(connection_id()); +save_master_pos; +send update t1 set n = n + 1; +connection master1; +select (@id := id) - id from t2; +sleep 0.1; +kill @id; +drop table t2; +connection master; +--error 1053; +reap; +connection slave; +sync_with_master ; +show slave status; +set sql_slave_skip_counter=1; +slave start; +select count(*) from t1; +connection master1; +drop table t1; +create table t1 (n int); +insert into t1 values(3456); +save_master_pos; +connection slave; +sync_with_master; +select n from t1; +connection master1; +drop table t1; +save_master_pos; +connection slave; +sync_with_master; + |