Description:
tfl_name: rpl.rpl_row_mysqlbinlog 'row'
tfl_tst_type: rpl_binlog_row
psh_tree: bzr_mysql-6.0-bugteam
psh_order: 40
tfl_bld_platform: vm-win2003-32-a
tfl_text: rpl.rpl_row_mysqlbinlog 'row' [ fail ]
=== SHOW MASTER STATUS ===
---- 1. ----
File slave-bin.000001
Position 3471067
Binlog_Do_DB
Binlog_Ignore_DB
==========================
=== SHOW SLAVE STATUS ===
---- 1. ----
Slave_IO_State Waiting for master to send event
Master_Host 127.0.0.1
Master_User root
Master_Port 11010
Connect_Retry 1
Master_Log_File master-bin.000002
Read_Master_Log_Pos 692322
Relay_Log_File slave-relay-bin.000005
Relay_Log_Pos 254
Relay_Master_Log_File master-bin.000002
Slave_IO_Running Yes
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 1146
Last_Error Error 'Table 'test.t2' doesn't exist' on opening tables
Skip_Counter 0
Exec_Master_Log_Pos 107
Relay_Log_Space 692669
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 0
Last_IO_Error
Last_SQL_Errno 1146
Last_SQL_Error Error 'Table 'test.t2' doesn't exist' on opening tables
=========================
mysqltest: At line 235: could not sync with master ('select master_pos_wait('master-bin.000002', 692322)' returned NULL)
The result from queries just before the failure was:
< snip >
word
Aarhus
Aarhus
Aarhus
Aarhus
Aarhus
SELECT * FROM t2 ORDER BY id LIMIT 5;
id
1
2
3
4
5
SELECT c1, c3, c4, c5 FROM t3 ORDER BY c1 LIMIT 5;
c1 c3 c4 c5
1 2006-02-22 00:00:00 Tested in Texas 2.2
2 2006-02-22 00:00:00 Tested in Texas 4.4
3 2006-02-22 00:00:00 Tested in Texas 6.6
4 2006-02-22 00:00:00 Tested in Texas 8.8
5 2006-02-22 00:00:00 Tested in Texas 11
More results from queries before failure can be found in e:\var-rpl_binlog_row-101\log\rpl_row_mysqlbinlog.log
Stopping All Servers
Restoring snapshot of databases
*************************** 223. row ***************************
tfl_name: rpl.rpl_slave_status 'stmt'
tfl_tst_type: ps_stm_threadpool
psh_tree: bzr_mysql-6.0-bugteam
psh_order: 43
tfl_bld_platform: sles10-ia64-a-2
tfl_text: rpl.rpl_slave_status 'stmt' [ fail ]
--- /data0/pushbuild/pb2-3/pb/bzr_mysql-6.0-bugteam/43/mysql-6.0.6-alpha-pb43/mysql-test/suite/rpl/r/rpl_slave_status.result 2008-07-07 12:09:05.000000000 +0300
+++ /data0/pushbuild/pb2-3/pb/bzr_mysql-6.0-bugteam/43/mysql-6.0.6-alpha-pb43/mysql-test/suite/rpl/r/rpl_slave_status.reject 2008-07-07 14:31:37.000000000 +0300
@@ -12,25 +12,43 @@
stop slave;
change master to master_user='rpl',master_password='rpl';
start slave;
-==== Do replication as new user ====
-[on master]
-create table t1 (n int);
-insert into t1 values (1);
-[on slave]
-select * from t1;
-n
-1
-==== Delete new replication user ====
-[on master]
-drop user rpl@127.0.0.1;
-flush privileges;
-[on slave]
-==== Restart slave without privileges =====
-stop slave;
-start slave;
-==== Verify that Slave_IO_Running = No ====
-Slave_IO_Running = No (should be No)
-==== Cleanup (Note that slave IO thread is not running) ====
-drop table t1;
-[on master]
-drop table t1;
+"Failed while waiting for slave to start"
+SHOW SLAVE STATUS;
+Slave_IO_State #
+Master_Host 127.0.0.1
+Master_User rpl
+Master_Port MASTER_PORT
+Connect_Retry 1
+Master_Log_File master-bin.000001
+Read_Master_Log_Pos 316
+Relay_Log_File #
+Relay_Log_Pos #
+Relay_Master_Log_File master-bin.000001
+Slave_IO_Running No
+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
+Exec_Master_Log_Pos 316
+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 2013
+Last_IO_Error error reconnecting to master 'rpl@127.0.0.1:MASTER_PORT' - retry-time: 1 retries: 10
+Last_SQL_Errno 0
+Last_SQL_Error
mysqltest: In included file "./include/wait_for_slave_to_start.inc": Result content mismatch
Warnings from just before the error:
Note 1051 Unknown table 't1'
Note 1051 Unknown table 't2'
Note 1051 Unknown table 't3'
Note 1051 Unknown table 't4'
Note 1051 Unknown table 't5'
Note 1051 Unknown table 't6'
Note 1051 Unknown table 't7'
Note 1051 Unknown table 't8'
How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=vm-win20...
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-bugteam&order=40