← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_log_pos.result
1
 
stop slave;
2
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3
 
reset master;
4
 
reset slave;
5
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
 
start slave;
 
1
include/master-slave.inc
 
2
[connection master]
7
3
call mtr.add_suppression ("Slave I/O: Got fatal error 1236 from master when reading data from binary");
8
4
show master status;
9
5
File    Position        Binlog_Do_DB    Binlog_Ignore_DB
10
6
master-bin.000001       #       <Binlog_Do_DB>  <Binlog_Ignore_DB>
11
7
include/stop_slave.inc
12
 
change master to master_log_pos=75;
13
 
SHOW SLAVE STATUS;
14
 
Slave_IO_State  #
15
 
Master_Host     127.0.0.1
16
 
Master_User     root
17
 
Master_Port     MASTER_PORT
18
 
Connect_Retry   1
19
 
Master_Log_File master-bin.000001
20
 
Read_Master_Log_Pos     #
21
 
Relay_Log_File  #
22
 
Relay_Log_Pos   #
23
 
Relay_Master_Log_File   master-bin.000001
24
 
Slave_IO_Running        No
25
 
Slave_SQL_Running       No
26
 
Replicate_Do_DB 
27
 
Replicate_Ignore_DB     
28
 
Replicate_Do_Table      
29
 
Replicate_Ignore_Table  #
30
 
Replicate_Wild_Do_Table 
31
 
Replicate_Wild_Ignore_Table     
32
 
Last_Errno      0
33
 
Last_Error      
34
 
Skip_Counter    0
35
 
Exec_Master_Log_Pos     #
36
 
Relay_Log_Space #
37
 
Until_Condition None
38
 
Until_Log_File  
39
 
Until_Log_Pos   0
40
 
Master_SSL_Allowed      No
41
 
Master_SSL_CA_File      
42
 
Master_SSL_CA_Path      
43
 
Master_SSL_Cert 
44
 
Master_SSL_Cipher       
45
 
Master_SSL_Key  
46
 
Seconds_Behind_Master   #
47
 
Master_SSL_Verify_Server_Cert   No
48
 
Last_IO_Errno   #
49
 
Last_IO_Error   #
50
 
Last_SQL_Errno  0
51
 
Last_SQL_Error  
 
8
change master to master_log_pos=MASTER_LOG_POS;
 
9
Read_Master_Log_Pos = '75'
52
10
start slave;
53
 
include/stop_slave.inc
54
 
SHOW SLAVE STATUS;
55
 
Slave_IO_State  #
56
 
Master_Host     127.0.0.1
57
 
Master_User     root
58
 
Master_Port     MASTER_PORT
59
 
Connect_Retry   1
60
 
Master_Log_File master-bin.000001
61
 
Read_Master_Log_Pos     75
62
 
Relay_Log_File  #
63
 
Relay_Log_Pos   #
64
 
Relay_Master_Log_File   master-bin.000001
65
 
Slave_IO_Running        No
66
 
Slave_SQL_Running       No
67
 
Replicate_Do_DB 
68
 
Replicate_Ignore_DB     
69
 
Replicate_Do_Table      
70
 
Replicate_Ignore_Table  #
71
 
Replicate_Wild_Do_Table 
72
 
Replicate_Wild_Ignore_Table     
73
 
Last_Errno      0
74
 
Last_Error      
75
 
Skip_Counter    0
76
 
Exec_Master_Log_Pos     75
77
 
Relay_Log_Space #
78
 
Until_Condition None
79
 
Until_Log_File  
80
 
Until_Log_Pos   0
81
 
Master_SSL_Allowed      No
82
 
Master_SSL_CA_File      
83
 
Master_SSL_CA_Path      
84
 
Master_SSL_Cert 
85
 
Master_SSL_Cipher       
86
 
Master_SSL_Key  
87
 
Seconds_Behind_Master   #
88
 
Master_SSL_Verify_Server_Cert   No
89
 
Last_IO_Errno   #
90
 
Last_IO_Error   #
91
 
Last_SQL_Errno  0
92
 
Last_SQL_Error  
 
11
include/wait_for_slave_io_error.inc [errno=1236]
 
12
Last_IO_Error = 'Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master''
 
13
include/stop_slave_sql.inc
93
14
show master status;
94
15
File    Position        Binlog_Do_DB    Binlog_Ignore_DB
95
16
master-bin.000001       #       <Binlog_Do_DB>  <Binlog_Ignore_DB>
97
18
drop table if exists t1;
98
19
create table t1 (n int);
99
20
insert into t1 values (1),(2),(3);
100
 
change master to master_log_pos=4;
 
21
change master to master_log_pos=MASTER_LOG_POS;
101
22
start slave;
102
23
select * from t1 ORDER BY n;
103
24
n
106
27
3
107
28
drop table t1;
108
29
End of 5.0 tests
 
30
include/rpl_end.inc