Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting
Mailing Lists: lists.mysql.com > commits > 07 > 105756.html (Request Expert lists.mysql.com Support)

[patch 4/5] Update tests and results for WL3127 slave side TCP address binding

From: <stewart(at)mysql.com>
Date: Mon Oct 08 2007 - 21:46:39 EDT


The largest change being the addition of Master_Bind to SHOW SLAVE STATUS and having to update tests for this.

Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_basic.result

  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_basic.result 2007-10-03 17:16:22.262605440 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_basic.result 2007-10-08 10:44:22.866513612 +1000
    @@ -179,6 +179,7 @@ Last_IO_Errno <Last_IO_Errno>
    Last_IO_Error <Last_IO_Error> Last_SQL_Errno <Last_SQL_Errno> Last_SQL_Error <Last_SQL_Error> +Master_Bind 0.0.0.0 set GLOBAL slave_transaction_retries=10; START SLAVE; select * from t1 order by nid; Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular.result 2007-09-25 18:38:16.865275692 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular.result 2007-10-08 10:44:22.870513808 +1000
    @@ -56,6 +56,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 SELECT * FROM t1 ORDER BY a; a b 1 2
    @@ -99,5 +100,6 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 STOP SLAVE; DROP TABLE t1; Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular_simplex.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular_simplex.result 2007-09-25 18:38:16.869275888 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_circular_simplex.result 2007-10-08 10:44:22.938517143 +1000
    @@ -53,6 +53,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 SELECT * FROM t1 ORDER BY a; a b 1 2
    @@ -102,3 +103,4 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_extraCol.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_extraCol.result 2007-09-25 18:38:16.881276477 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_extraCol.result 2007-10-08 10:44:22.942517340 +1000
    @@ -92,6 +92,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 252, test.t3 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t3 ***
      @@ -154,6 +155,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 246, test.t4 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t4 ***
      @@ -216,6 +218,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 5 type mismatch - received type 4, test.t5 has type 246 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t5 ***
      @@ -277,6 +280,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 3 type mismatch - received type 16, test.t6 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=3;
    • Drop t6 *** DROP TABLE t6;
      @@ -389,6 +393,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 254, test.t10 has type 5 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t10 ***
      @@ -450,6 +455,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 15, test.t11 has type 252 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t11 ***
      @@ -640,6 +646,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1060 Last_SQL_Error Error 'Duplicate column name 'c6'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5' +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Try to insert in master ****
      @@ -776,6 +783,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 8, test.t17 has type 2 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
      • DROP table t17 *** Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_idempotent.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_idempotent.result 2007-09-25 18:38:16.885276673 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_idempotent.result 2007-10-08 10:44:22.954517928 +1000
    @@ -33,15 +33,15 @@ c1 c2 c3
    row3 C 3 row4 D 4 SHOW SLAVE STATUS; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 Yes Yes <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> No <Last_IO_Errno> <Last_IO_Error> 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 Yes Yes <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> No <Last_IO_Errno> <Last_IO_Error> 0 0.0.0.0 STOP SLAVE; CHANGE MASTER TO master_log_file = 'master-bin.000001', master_log_pos = <the_pos> ; SHOW SLAVE STATUS; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 No No <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> No <Last_IO_Errno> <Last_IO_Error> 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 No No <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> No <Last_IO_Errno> <Last_IO_Error> 0 0.0.0.0 START SLAVE; SELECT * FROM t1 ORDER BY c3; c1 c2 c3
    @@ -68,6 +68,6 @@ SELECT * FROM t1;
    c1 c2 c3 row2 new on slave 2 SHOW SLAVE STATUS; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 Yes Yes <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> <Last_IO_Errno> <Last_IO_Error> 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +<Slave_IO_State> 127.0.0.1 root MASTER_PORT 1 master-bin.000001 <Read_Master_Log_Pos> <Relay_Log_File> <Relay_Log_Pos> master-bin.000001 Yes Yes <Replicate_Ignore_Table> 0 0 <Exec_Master_Log_Pos> <Relay_Log_Space> None 0 No <Seconds_Behind_Master> <Last_IO_Errno> <Last_IO_Error> 0 0.0.0.0 DROP TABLE IF EXISTS t1; Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_sync.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_sync.result 2007-09-25 18:38:16.889276869 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_sync.result 2007-10-08 10:44:22.986519498 +1000
    @@ -110,6 +110,7 @@ Last_IO_Errno <Last_IO_Errno>
    Last_IO_Error <Last_IO_Error> Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 SELECT hex(c1),hex(c2),c3 FROM t1 ORDER BY c3; hex(c1) hex(c2) c3 1 1 row1 Index: telco/mysql-test/suite/rpl/r/rpl_000015.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_000015.result 2007-09-25 18:38:17.005282559 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_000015.result 2007-10-08 10:44:23.018521067 +1000
    @@ -44,6 +44,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 change master to master_host='127.0.0.1',master_user='root', master_password='',master_port=MASTER_PORT; SHOW SLAVE STATUS;
    @@ -85,6 +86,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; SHOW SLAVE STATUS; Slave_IO_State #
    @@ -125,6 +127,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 drop table if exists t1; create table t1 (n int, PRIMARY KEY(n)); insert into t1 values (10),(45),(90); Index: telco/mysql-test/suite/rpl/r/rpl_change_master.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_change_master.result 2007-09-25 18:38:17.013282951 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_change_master.result 2007-10-08 11:54:10.863920645 +1000
    @@ -50,6 +50,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 change master to master_user='root'; SHOW SLAVE STATUS; Slave_IO_State #
    @@ -90,6 +91,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; select * from t1; n Index: telco/mysql-test/suite/rpl/r/rpl_deadlock_innodb.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_deadlock_innodb.result 2007-09-25 18:38:17.021283344 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_deadlock_innodb.result 2007-10-08 10:44:23.042522245 +1000
    @@ -83,6 +83,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 stop slave; delete from t3; change master to master_log_pos=548;
    @@ -142,6 +143,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 set @my_max_relay_log_size= @@global.max_relay_log_size; set global max_relay_log_size=0; stop slave;
    @@ -206,6 +208,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 drop table t1,t2,t3,t4; set global max_relay_log_size= @my_max_relay_log_size; End of 5.1 tests Index: telco/mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result 2007-10-03 17:16:22.186601712 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result 2007-10-08 10:45:14.209031788 +1000
    @@ -133,6 +133,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0
    • Testing Altering table def scenario *****
      @@ -509,6 +510,7 @@ Last_IO_Errno #
      Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0
  • columns in master at middle of table *
    @@ -583,6 +585,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;

@@ -658,6 +661,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -809,6 +813,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1091
 Last_SQL_Error	Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -895,6 +900,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1054
 Last_SQL_Error	Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -981,6 +987,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1072
 Last_SQL_Error	Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -1273,6 +1280,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	0
 Last_SQL_Error	
+Master_Bind	0.0.0.0
 
 
 ***** Testing Altering table def scenario *****

@@ -1649,6 +1657,7 @@ Last_IO_Errno	#

 Last_IO_Error	#
 Last_SQL_Errno	0
 Last_SQL_Error	
+Master_Bind	0.0.0.0
 
 ****************************************
 * columns in master at middle of table *

@@ -1723,6 +1732,7 @@ Last_IO_Errno	#

 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -1798,6 +1808,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -1949,6 +1960,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1091
 Last_SQL_Error	Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -2035,6 +2047,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1054
 Last_SQL_Error	Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

Do you need help?X

+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -2121,6 +2134,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1072
 Last_SQL_Error	Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;   Index: telco/mysql-test/suite/rpl/r/rpl_flushlog_loop.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_flushlog_loop.result 2007-09-25 18:38:17.089286679 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_flushlog_loop.result 2007-10-08 10:44:23.170528523 +1000
    @@ -56,3 +56,4 @@ Last_IO_Errno #
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 Index: telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_log.result
  • telco.orig/mysql-test/suite/rpl_ndb/r/rpl_ndb_log.result 2007-09-25 18:38:16.921278439 +1000 +++ telco/mysql-test/suite/rpl_ndb/r/rpl_ndb_log.result 2007-10-08 10:44:23.178528915 +1000
    @@ -304,6 +304,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 show binlog events in 'slave-bin.000005' from 4; ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log DROP TABLE t1; Index: telco/mysql-test/suite/rpl_ndb/t/rpl_ndb_bank.test
  • telco.orig/mysql-test/suite/rpl_ndb/t/rpl_ndb_bank.test 2007-09-25 18:38:16.997282167 +1000 +++ telco/mysql-test/suite/rpl_ndb/t/rpl_ndb_bank.test 2007-10-08 10:44:23.190529504 +1000
    @@ -73,7 +73,7 @@ CREATE TABLE ACCOUNT_TYPE ( ACCOUNT_TYPE
     # # create "BANK" application # ---exec NDB_CONNECTSTRING=localhost:$NDBCLUSTER_PORT ../storage/ndb/test/ndbapi/bank/bankCreator >> $NDB_TOOLS_OUTPUT +--exec ../storage/ndb/test/ndbapi/bank/bankCreator --skip-create >> $NDB_TOOLS_OUTPUT

 #
 # start main loop
@@ -128,8 +128,8 @@ let the_backup_id=`select @the_backup_id
 

 # restore on slave, first check that nothing is there 

 --connection slave
---exec $NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT_SLAVE" -p 8 -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT
---exec $NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT_SLAVE" -p 8 -b $the_backup_id -n 2 -r -e --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT
+--exec echo $NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT_SLAVE" -p 8 -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT
+--exec echo $NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT_SLAVE" -p 8 -b $the_backup_id -n 2 -r -e --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT

 #
 # now setup replication to continue from last epoch Index: telco/mysql-test/suite/rpl/r/rpl_grant.result

  • telco.orig/mysql-test/suite/rpl/r/rpl_grant.result 2007-09-25 18:38:17.121288249 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_grant.result 2007-10-08 10:44:23.222531073 +1000
    @@ -80,3 +80,4 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 Index: telco/mysql-test/suite/rpl/r/rpl_incident.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_incident.result 2007-09-25 18:38:17.153289818 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_incident.result 2007-10-08 10:44:23.238531858 +1000
    @@ -64,6 +64,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 1587 Last_SQL_Error The incident LOST_EVENTS occured on the master. Message: <none> +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; SELECT * FROM t1;
    @@ -111,4 +112,5 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 DROP TABLE t1; Index: telco/mysql-test/suite/rpl/r/rpl_known_bugs_detection.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_known_bugs_detection.result 2007-09-25 18:38:17.181291192 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_known_bugs_detection.result 2007-10-08 10:44:23.246532251 +1000
    @@ -50,6 +50,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 1105 Last_SQL_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10' +Master_Bind 0.0.0.0 SELECT * FROM t1; a b stop slave;
    @@ -141,6 +142,7 @@ SELECT t2.field_a, t2.field_b, t2.field_
    FROM t2 ON DUPLICATE KEY UPDATE t1.field_3 = t2.field_c' +Master_Bind 0.0.0.0 SELECT * FROM t1; id field_1 field_2 field_3 drop table t1, t2; Index: telco/mysql-test/suite/rpl/r/rpl_loaddata_fatal.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_loaddata_fatal.result 2007-09-25 18:38:17.213292761 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_loaddata_fatal.result 2007-10-08 10:44:23.274533624 +1000
    @@ -45,6 +45,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 LOAD DATA INFILE '../std_data_ln/rpl_loaddata.dat' INTO TABLE t1; SHOW SLAVE STATUS; Slave_IO_State #
    @@ -85,6 +86,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 1590 Last_SQL_Error Fatal error: Not enough memory +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; DROP TABLE t1; Index: telco/mysql-test/suite/rpl/r/rpl_loaddata.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_loaddata.result 2007-09-25 18:38:17.241294134 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_loaddata.result 2007-10-08 10:44:23.294534605 +1000
    @@ -38,8 +38,8 @@ load data infile '../std_data_ln/rpl_loa
    set global sql_slave_skip_counter=1; start slave; show slave status; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1797 # # master-bin.000001 Yes Yes # 0 0 1797 # None 0 No # No 0 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1797 # # master-bin.000001 Yes Yes # 0 0 1797 # None 0 No # No 0 0 0.0.0.0 set sql_log_bin=0; delete from t1; set sql_log_bin=1;
    @@ -48,8 +48,8 @@ stop slave;
    change master to master_user='test'; change master to master_user='root'; show slave status; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1832 # # master-bin.000001 No No # 0 0 1832 # None 0 No # No 0 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1832 # # master-bin.000001 No No # 0 0 1832 # None 0 No # No 0 0 0.0.0.0 set global sql_slave_skip_counter=1; start slave; set sql_log_bin=0;
    @@ -59,8 +59,8 @@ load data infile '../std_data_ln/rpl_loa
    stop slave; reset slave; show slave status; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -# 127.0.0.1 root MASTER_PORT 1 4 # # No No # 0 0 0 # None 0 No # No 0 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +# 127.0.0.1 root MASTER_PORT 1 4 # # No No # 0 0 0 # None 0 No # No 0 0 0.0.0.0 reset master; create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60), unique(day)) engine=MyISAM; Index: telco/mysql-test/suite/rpl/r/rpl_log_pos.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_log_pos.result 2007-09-25 18:38:17.249294527 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_log_pos.result 2007-10-08 10:44:23.318535782 +1000
    @@ -48,6 +48,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; stop slave; SHOW SLAVE STATUS;
    @@ -89,6 +90,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 106 <Binlog_Ignore_DB> Index: telco/mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result 2007-09-25 18:38:17.253294723 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result 2007-10-08 10:44:23.330536371 +1000
    @@ -60,6 +60,7 @@ Last_IO_Errno #
    Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 Index: telco/mysql-test/suite/rpl/r/rpl_replicate_do.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_replicate_do.result 2007-09-25 18:38:17.265295312 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_replicate_do.result 2007-10-08 10:44:23.358537744 +1000
    @@ -65,6 +65,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 create table t1 (ts timestamp); set one_shot time_zone='met'; insert into t1 values('2005-08-12 00:00:00'); Index: telco/mysql-test/suite/rpl/r/rpl_rotate_logs.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_rotate_logs.result 2007-09-25 18:38:17.269295508 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_rotate_logs.result 2007-10-08 10:44:23.366538136 +1000
    @@ -53,6 +53,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 select * from t1; s Could not break slave
    @@ -133,6 +134,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 select * from t2; m 34
    @@ -197,6 +199,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 lock tables t3 read; select count(*) from t3 where n >= 4; count(*) Index: telco/mysql-test/suite/rpl/r/rpl_server_id1.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_server_id1.result 2007-09-25 18:38:17.301297077 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_server_id1.result 2007-10-08 10:44:23.398539706 +1000
    @@ -47,6 +47,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; insert into t1 values (1); show status like "slave_running"; Index: telco/mysql-test/suite/rpl/r/rpl_server_id2.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_server_id2.result 2007-09-25 18:38:17.333298647 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_server_id2.result 2007-10-08 10:44:23.422540883 +1000
    @@ -47,6 +47,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; insert into t1 values (1); select * from t1; Index: telco/mysql-test/suite/rpl/r/rpl_slave_skip.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_slave_skip.result 2007-09-25 18:38:17.337298843 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_slave_skip.result 2007-10-08 10:44:23.486544022 +1000
    @@ -76,6 +76,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; SELECT * FROM t1;
    @@ -140,5 +141,6 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0
    • On Master **** DROP TABLE t1, t2; Index: telco/mysql-test/suite/rpl/r/rpl_slave_status.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_slave_status.result 2007-09-25 18:38:17.389301394 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_slave_status.result 2007-10-08 10:44:23.506545003 +1000
    @@ -57,6 +57,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 drop table t1; delete from mysql.user where user='rpl'; drop table t1; Index: telco/mysql-test/suite/rpl/r/rpl_ssl.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_ssl.result 2007-09-25 18:38:17.393301590 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_ssl.result 2007-10-08 10:44:23.586548927 +1000
    @@ -58,6 +58,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 STOP SLAVE; select * from t1; t
    @@ -102,6 +103,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 drop user replssl@localhost; drop table t1; End of 5.0 tests Index: telco/mysql-test/suite/rpl/r/rpl_ssl1.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_ssl1.result 2007-09-25 18:38:17.457304729 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_ssl1.result 2007-10-08 10:44:23.610550104 +1000
    @@ -57,6 +57,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 stop slave; change master to master_user='root',master_password='', master_ssl=0; start slave;
    @@ -101,6 +102,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 stop slave; change master to master_host="localhost",
    @@ -155,4 +157,5 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 drop table t1; Index: telco/mysql-test/suite/rpl/r/rpl_stm_log.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_stm_log.result 2007-09-25 18:38:17.489306299 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_stm_log.result 2007-10-08 10:44:23.626550889 +1000
    @@ -270,6 +270,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 show binlog events in 'slave-bin.000005' from 4; ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log DROP TABLE t1; Index: telco/mysql-test/suite/rpl/r/rpl_stm_max_relay_size.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_stm_max_relay_size.result 2007-09-25 18:38:17.521307868 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_stm_max_relay_size.result 2007-10-08 10:44:23.662552655 +1000
    @@ -60,6 +60,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 2 #
    @@ -108,6 +109,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 3: max_relay_log_size = 0 #
    @@ -156,6 +158,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions #
    @@ -201,6 +204,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 5 #
    @@ -247,6 +251,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated #
    @@ -291,6 +296,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 flush logs; show master status; File master-bin.000002 Index: telco/mysql-test/suite/rpl/r/rpl_stm_reset_slave.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_stm_reset_slave.result 2007-09-25 18:38:17.525308064 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_stm_reset_slave.result 2007-10-08 10:44:23.698554421 +1000
    @@ -43,6 +43,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 stop slave; change master to master_user='test'; SHOW SLAVE STATUS;
    @@ -84,6 +85,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 reset slave; SHOW SLAVE STATUS; Slave_IO_State #
    @@ -124,6 +126,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; SHOW SLAVE STATUS; Slave_IO_State #
    @@ -164,6 +167,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 stop slave; reset slave; start slave; Index: telco/mysql-test/suite/rpl/r/rpl_stm_until.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_stm_until.result 2007-09-25 18:38:17.533308457 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_stm_until.result 2007-10-08 10:44:23.722555598 +1000
    @@ -58,6 +58,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291; select * from t1; n
    @@ -104,6 +105,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave until relay_log_file='slave-relay-bin.000004', relay_log_pos=746; select * from t2; n
    @@ -148,6 +150,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave; stop slave; start slave until master_log_file='master-bin.000001', master_log_pos=776;
    @@ -190,6 +193,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 start slave until master_log_file='master-bin', master_log_pos=561; ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL start slave until master_log_file='master-bin.000001', master_log_pos=561, relay_log_pos=12; Index: telco/mysql-test/suite/rpl/r/rpl_row_max_relay_size.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_row_max_relay_size.result 2007-09-25 18:38:17.541308849 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_row_max_relay_size.result 2007-10-08 10:44:23.754557167 +1000
    @@ -62,6 +62,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 2 #
    @@ -110,6 +111,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 3: max_relay_log_size = 0 #
    @@ -158,6 +160,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions #
    @@ -203,6 +206,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 5 #
    @@ -249,6 +253,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 # # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated #
    @@ -293,6 +298,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 flush logs; show master status; File master-bin.000002 Index: telco/mysql-test/suite/rpl/r/rpl_skip_error.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_skip_error.result 2007-09-25 18:38:17.545309045 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_skip_error.result 2007-10-08 10:44:23.794559129 +1000
    @@ -31,6 +31,6 @@ a
    2 3 show slave status; -Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error -# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 786 # # master-bin.000001 Yes Yes 0 0 786 # None 0 No # No 0 0 +Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed 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 Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Master_Bind +# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 786 # # master-bin.000001 Yes Yes 0 0 786 # None 0 No # No 0 0 0.0.0.0 drop table t1; Index: telco/mysql-test/suite/rpl/r/rpl_extraCol_innodb.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_extraCol_innodb.result 2007-09-25 18:38:17.585311007 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_extraCol_innodb.result 2007-10-08 10:44:23.842561484 +1000
    @@ -92,6 +92,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 252, test.t3 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t3 ***
      @@ -154,6 +155,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 246, test.t4 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t4 ***
      @@ -216,6 +218,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 5 type mismatch - received type 4, test.t5 has type 246 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t5 ***
      @@ -277,6 +280,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 3 type mismatch - received type 16, test.t6 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=3;
    • Drop t6 *** DROP TABLE t6;
      @@ -389,6 +393,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 254, test.t10 has type 5 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t10 ***
      @@ -450,6 +455,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 15, test.t11 has type 252 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t11 ***
      @@ -640,6 +646,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1060 Last_SQL_Error Error 'Duplicate column name 'c6'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5' +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Try to insert in master ****
      @@ -775,6 +782,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 8, test.t17 has type 2 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
      • DROP table t17 *** Index: telco/mysql-test/suite/rpl/r/rpl_extraCol_myisam.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_extraCol_myisam.result 2007-09-25 18:38:17.589311204 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_extraCol_myisam.result 2007-10-08 10:44:23.882563446 +1000
    @@ -92,6 +92,7 @@ Last_IO_Errno 0
    Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 252, test.t3 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t3 ***
      @@ -154,6 +155,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 246, test.t4 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t4 ***
      @@ -216,6 +218,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 5 type mismatch - received type 4, test.t5 has type 246 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t5 ***
      @@ -277,6 +280,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 3 type mismatch - received type 16, test.t6 has type 3 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=3;
    • Drop t6 *** DROP TABLE t6;
      @@ -389,6 +393,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 254, test.t10 has type 5 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t10 ***
      @@ -450,6 +455,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 15, test.t11 has type 252 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Drop t11 ***
      @@ -640,6 +646,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1060 Last_SQL_Error Error 'Duplicate column name 'c6'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5' +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
    • Try to insert in master ****
      @@ -775,6 +782,7 @@ Last_IO_Errno 0
      Last_IO_Error Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 8, test.t17 has type 2 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;
      • DROP table t17 *** Index: telco/mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result 2007-09-25 18:38:17.597311596 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result 2007-10-08 10:44:23.922565408 +1000
    @@ -56,4 +56,5 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 1146 Last_SQL_Error Error 'Table 'test.t1' doesn't exist' on opening table `test`.`t1` +Master_Bind 0.0.0.0 drop table t1, t2; Index: telco/mysql-test/suite/rpl/r/rpl_row_log.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_row_log.result 2007-09-25 18:38:17.605311988 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_row_log.result 2007-10-08 10:44:23.946566585 +1000
    @@ -272,6 +272,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 show binlog events in 'slave-bin.000005' from 4; ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log DROP TABLE t1; Index: telco/mysql-test/suite/rpl/r/rpl_row_log_innodb.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_row_log_innodb.result 2007-09-25 18:38:17.641313754 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_row_log_innodb.result 2007-10-08 10:44:23.978568154 +1000
    @@ -280,6 +280,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0 show binlog events in 'slave-bin.000005' from 4; ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log DROP TABLE t1; Index: telco/mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result
  • telco.orig/mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result 2007-10-03 17:16:22.194602105 +1000 +++ telco/mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result 2007-10-08 11:49:38.566565386 +1000
    @@ -133,6 +133,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0
    • Testing Altering table def scenario *****
      @@ -509,6 +510,7 @@ Last_IO_Errno #
      Last_IO_Error # Last_SQL_Errno 0 Last_SQL_Error +Master_Bind 0.0.0.0
  • columns in master at middle of table *
    @@ -583,6 +585,7 @@ Last_IO_Errno #
    Last_IO_Error # Last_SQL_Errno 1532 Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254 +Master_Bind 0.0.0.0 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; START SLAVE;

@@ -658,6 +661,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -809,6 +813,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1091
 Last_SQL_Error	Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -895,6 +900,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1054
 Last_SQL_Error	Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

Do you need more help?X

+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -981,6 +987,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1072
 Last_SQL_Error	Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -1273,6 +1280,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	0
 Last_SQL_Error	
+Master_Bind	0.0.0.0
 
 
 ***** Testing Altering table def scenario *****

@@ -1649,6 +1657,7 @@ Last_IO_Errno	#

 Last_IO_Error	#
 Last_SQL_Errno	0
 Last_SQL_Error	
+Master_Bind	0.0.0.0
 
 ****************************************
 * columns in master at middle of table *

@@ -1723,6 +1732,7 @@ Last_IO_Errno	#

 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -1798,6 +1808,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1532
 Last_SQL_Error	Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15
+Master_Bind	0.0.0.0

 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
 START SLAVE;  
@@ -1949,6 +1960,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1091
 Last_SQL_Error	Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -2035,6 +2047,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1054
 Last_SQL_Error	Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;  
@@ -2121,6 +2134,7 @@ Last_IO_Errno #
 Last_IO_Error	#
 Last_SQL_Errno	1072
 Last_SQL_Error	Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'
+Master_Bind	0.0.0.0

 STOP SLAVE;
 RESET SLAVE;   
--
Stewart Smith

-- 
MySQL Code Commits Mailing List
For list archives: 
http://lists.mysql.com/commits
To unsubscribe:    
http://lists.mysql.com/commits?unsub=lists@pantek.com
Received on Mon Oct 8 22:01:54 2007

This archive was generated by hypermail 2.1.8 : Thu Jul 03 2008 - 09:33:43 EDT

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library