← Back to branch summary

~percona-dev/percona-write-error/trunk

« back to all changes in this revision

Viewing changes to 12013.test

  • Committer: Oleg Tsarev
  • Date: 2010-10-19 22:08:44 UTC
  • Revision ID: oleg.tsarev@percona.com-20101019220844-c7sr9h91ibut0zto
last version

Show diffs side-by-side

added added

removed removed

Lines of Context:
12013.test
 
1
--source include/have_innodb.inc
1
2
exec echo "0" > /storage/project/percona/error.cfg;
2
3
set global max_binlog_size=4096;
3
4
 
4
 
source include/master-slave.inc;
 
5
--source include/master-slave.inc
 
6
connection slave;
 
7
STOP SLAVE;
 
8
-- source include/wait_for_slave_to_stop.inc
5
9
 
6
10
connection master;
7
11
drop table if exists t;
8
 
create table t(k INT PRIMARY KEY);
9
 
let $i=43;
 
12
create table t(k INT PRIMARY KEY) engine=InnoDB;
 
13
let $i=42;
10
14
while($i)
11
15
{
12
16
        let $query=insert into t value($i);
13
17
        eval $query;
14
18
        dec $i;
15
19
}
16
 
exec echo "100" > /storage/project/percona/error.cfg;
17
 
let $i=43;
18
 
let $k=86;
 
20
exec echo "5" > /storage/project/percona/error.cfg;
 
21
let $i=42;
 
22
let $k=100;
19
23
while($i)
20
24
{
21
25
        let $query=insert into t value($k);
23
27
        dec $i;
24
28
        dec $k;
25
29
}
26
 
sync_slave_with_master;
27
 
sync_slave_with_master;
28
 
connection master;
29
30
select "master",count(*) from t;
30
 
connection slave;
31
 
select "slave",count(*) from t;
32
 
connection master;
33
31
drop table t;
34
 
sync_slave_with_master;
 
 
b'\\ No newline at end of file'
 
32
 
 
33
echo "complete";
 
 
b'\\ No newline at end of file'