rpl_row_reset_slave.result 4.22 KB
Newer Older
unknown's avatar
unknown committed
1
stop slave;
unknown's avatar
unknown committed
2 3 4 5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
unknown's avatar
unknown committed
6
start slave;
7 8 9 10 11 12 13
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
unknown's avatar
unknown committed
14
Read_Master_Log_Pos	#
15 16 17 18 19 20 21 22 23 24 25 26 27 28
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
unknown's avatar
unknown committed
29
Exec_Master_Log_Pos	#
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
Andrei Elkin's avatar
Andrei Elkin committed
46 47
Replicate_Ignore_Server_Ids	
Master_Server_Id	1
unknown's avatar
unknown committed
48 49
stop slave;
change master to master_user='test';
50 51 52 53 54 55 56
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	test
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
unknown's avatar
unknown committed
57
Read_Master_Log_Pos	#
58 59 60 61 62 63 64 65 66 67 68 69 70 71
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	No
Slave_SQL_Running	No
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
unknown's avatar
unknown committed
72
Exec_Master_Log_Pos	#
73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
Andrei Elkin's avatar
Andrei Elkin committed
89 90
Replicate_Ignore_Server_Ids	
Master_Server_Id	1
unknown's avatar
unknown committed
91
reset slave;
92 93 94 95 96 97 98
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	
unknown's avatar
unknown committed
99
Read_Master_Log_Pos	#
100 101 102 103 104 105 106 107 108 109 110 111 112 113
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	
Slave_IO_Running	No
Slave_SQL_Running	No
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
unknown's avatar
unknown committed
114
Exec_Master_Log_Pos	#
115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
Andrei Elkin's avatar
Andrei Elkin committed
131 132
Replicate_Ignore_Server_Ids	
Master_Server_Id	1
unknown's avatar
unknown committed
133
start slave;
134 135 136 137 138 139 140
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
unknown's avatar
unknown committed
141
Read_Master_Log_Pos	#
142 143 144 145 146 147 148 149 150 151 152 153 154 155
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
unknown's avatar
unknown committed
156
Exec_Master_Log_Pos	#
157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
Andrei Elkin's avatar
Andrei Elkin committed
173 174
Replicate_Ignore_Server_Ids	
Master_Server_Id	1
175 176 177 178 179 180 181 182 183
stop slave;
reset slave;
start slave;
create temporary table t1 (a int);
stop slave;
reset slave;
start slave;
show status like 'slave_open_temp_tables';
Variable_name	Value
184
Slave_open_temp_tables	0
185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207
stop slave;
reset slave;
*** errno must be zero: 0 ***
change master to master_user='impossible_user_name';
start slave;
ONE
1
include/stop_slave.inc
change master to master_user='root';
include/start_slave.inc
*** last errno must be  zero: 0 ***
*** last error must be blank:  ***
include/stop_slave.inc
change master to master_user='impossible_user_name';
start slave;
ONE
1
include/stop_slave.inc
reset slave;
*** io  last errno must be  zero: 0  ***
*** io  last error must be blank:   ***
*** sql last errno must be  zero: 0 ***
*** sql last error must be blank:  ***