Description:
rpl.rpl_stm_000001 'mix' [ fail ]
--- /Users/henry/pb/bzr_mysql-6.0-bugteam/94/mysql-6.0.7-alpha-pb94/mysql-test/suite/rpl/r/rpl_stm_000001.result Mon Aug 11 17:19:11 2008
+++ /Users/henry/pb/bzr_mysql-6.0-bugteam/94/mysql-6.0.7-alpha-pb94/mysql-test/suite/rpl/r/rpl_stm_000001.reject Tue Aug 12 04:25:46 2008
@@ -51,32 +51,43 @@
kill @id;
drop table t2;
Got one of the listed errors
-set global sql_slave_skip_counter=1;
-start slave;
-select count(*) from t1;
-count(*)
-5000
-drop table t1;
-create table t1 (n int);
-insert into t1 values(3456);
-insert into mysql.user (Host, User, Password)
-VALUES ("10.10.10.%", "blafasel2", password("blafasel2"));
-Warnings:
-Warning 1364 Field 'ssl_cipher' doesn't have a default value
-Warning 1364 Field 'x509_issuer' doesn't have a default value
-Warning 1364 Field 'x509_subject' doesn't have a default value
-select select_priv,user from mysql.user where user = _binary'blafasel2';
-select_priv user
-N blafasel2
-update mysql.user set Select_priv = "Y" where User= _binary"blafasel2";
-select select_priv,user from mysql.user where user = _binary'blafasel2';
-select_priv user
-Y blafasel2
-select n from t1;
-n
-3456
-select select_priv,user from mysql.user where user = _binary'blafasel2';
-select_priv user
-Y blafasel2
-drop table t1;
-delete from mysql.user where user="blafasel2";
+"Failed while waiting for slave SQL thread to stop"
+SHOW SLAVE STATUS;
+Slave_IO_State Waiting for master to send event
+Master_Host 127.0.0.1
+Master_User root
+Master_Port 10070
+Connect_Retry 1
+Master_Log_File master-bin.000001
+Read_Master_Log_Pos 449594
+Relay_Log_File slave-relay-bin.000003
+Relay_Log_Pos 411519
+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
+Exec_Master_Log_Pos 411372
+Relay_Log_Space 449897
+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 71
+Master_SSL_Verify_Server_Cert No
+Last_IO_Errno 1045
+Last_IO_Error error connecting to master 'root@127.0.0.1:10070' - retry-time: 1 retries: 10
+Last_SQL_Errno 0
+Last_SQL_Error
How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
Description: rpl.rpl_stm_000001 'mix' [ fail ] --- /Users/henry/pb/bzr_mysql-6.0-bugteam/94/mysql-6.0.7-alpha-pb94/mysql-test/suite/rpl/r/rpl_stm_000001.result Mon Aug 11 17:19:11 2008 +++ /Users/henry/pb/bzr_mysql-6.0-bugteam/94/mysql-6.0.7-alpha-pb94/mysql-test/suite/rpl/r/rpl_stm_000001.reject Tue Aug 12 04:25:46 2008 @@ -51,32 +51,43 @@ kill @id; drop table t2; Got one of the listed errors -set global sql_slave_skip_counter=1; -start slave; -select count(*) from t1; -count(*) -5000 -drop table t1; -create table t1 (n int); -insert into t1 values(3456); -insert into mysql.user (Host, User, Password) -VALUES ("10.10.10.%", "blafasel2", password("blafasel2")); -Warnings: -Warning 1364 Field 'ssl_cipher' doesn't have a default value -Warning 1364 Field 'x509_issuer' doesn't have a default value -Warning 1364 Field 'x509_subject' doesn't have a default value -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -N blafasel2 -update mysql.user set Select_priv = "Y" where User= _binary"blafasel2"; -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -Y blafasel2 -select n from t1; -n -3456 -select select_priv,user from mysql.user where user = _binary'blafasel2'; -select_priv user -Y blafasel2 -drop table t1; -delete from mysql.user where user="blafasel2"; +"Failed while waiting for slave SQL thread to stop" +SHOW SLAVE STATUS; +Slave_IO_State Waiting for master to send event +Master_Host 127.0.0.1 +Master_User root +Master_Port 10070 +Connect_Retry 1 +Master_Log_File master-bin.000001 +Read_Master_Log_Pos 449594 +Relay_Log_File slave-relay-bin.000003 +Relay_Log_Pos 411519 +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 +Exec_Master_Log_Pos 411372 +Relay_Log_Space 449897 +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 71 +Master_SSL_Verify_Server_Cert No +Last_IO_Errno 1045 +Last_IO_Error error connecting to master 'root@127.0.0.1:10070' - retry-time: 1 retries: 10 +Last_SQL_Errno 0 +Last_SQL_Error How to repeat: https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...