~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_rotate_logs.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
drop table if exists t1, t2, t3, t4;
2
 
drop table if exists t1, t2, t3, t4;
3
1
start slave;
4
2
Got one of the listed errors
5
3
start slave;
14
12
insert into temp_table values ("testing temporary tables");
15
13
create table t1 (s text);
16
14
insert into t1 values('Could not break slave'),('Tried hard');
17
 
Master_Log_File master-bin.000001
18
 
Relay_Master_Log_File   master-bin.000001
19
 
Checking that both slave threads are running.
 
15
Master_Log_File = 'master-bin.000001'
 
16
Relay_Master_Log_File = 'master-bin.000001'
 
17
include/check_slave_is_running.inc
20
18
select * from t1;
21
19
s
22
20
Could not break slave
38
36
insert into t2 values(1234);
39
37
set insert_id=1234;
40
38
insert into t2 values(NULL);
41
 
set global sql_slave_skip_counter=1;
42
 
start slave;
 
39
call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .1234. for key .PRIMARY.. on query.* Error_code: 1062");
 
40
include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
43
41
purge master logs to 'master-bin.000002';
44
42
show master logs;
45
43
Log_name        master-bin.000002
57
55
Log_name        File_size
58
56
master-bin.000003       #
59
57
insert into t2 values (65);
60
 
Master_Log_File master-bin.000003
61
 
Relay_Master_Log_File   master-bin.000003
62
 
Checking that both slave threads are running.
 
58
Master_Log_File = 'master-bin.000003'
 
59
Relay_Master_Log_File = 'master-bin.000003'
 
60
include/check_slave_is_running.inc
63
61
select * from t2;
64
62
m
65
63
34
85
83
select * from t4;
86
84
a
87
85
testing temporary tables part 2
88
 
Master_Log_File master-bin.000005
89
 
Relay_Master_Log_File   master-bin.000005
90
 
Checking that both slave threads are running.
 
86
Master_Log_File = 'master-bin.000005'
 
87
Relay_Master_Log_File = 'master-bin.000005'
 
88
include/check_slave_is_running.inc
91
89
lock tables t3 read;
92
90
select count(*) from t3 where n >= 4;
93
91
count(*)
102
100
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
103
101
purge master logs before now();
104
102
End of 5.0 tests
 
103
include/stop_slave.inc
 
104
CHANGE MASTER TO MASTER_HOST = '';