[Commits] Rev 4300: MDEV-6469 - rpl.rpl_gtid_basic, rpl.rpl_gtid_stop_start, in lp:maria/10.0

Sergey Vojtovich svoj at mariadb.org
Tue Jul 22 13:54:46 EEST 2014


At lp:maria/10.0

------------------------------------------------------------
revno: 4300
revision-id: svoj at mariadb.org-20140722105438-2j4nv11k5xgdpi2u
parent: jplindst at mariadb.org-20140722101716-ync0gxnwu25h18lu
committer: Sergey Vojtovich <svoj at mariadb.org>
branch nick: 10.0
timestamp: Tue 2014-07-22 14:54:38 +0400
message:
  MDEV-6469 - rpl.rpl_gtid_basic, rpl.rpl_gtid_stop_start,
              rpl.rpl_gtid_crash fail on PPC64
  
  GTID order in @@gtid_binlog_pos depends on internal hash order,
  so requires to be hidden for stable test output.
=== modified file 'mysql-test/suite/rpl/r/rpl_gtid_basic.result'
--- a/mysql-test/suite/rpl/r/rpl_gtid_basic.result	2014-06-25 13:24:11 +0000
+++ b/mysql-test/suite/rpl/r/rpl_gtid_basic.result	2014-07-22 10:54:38 +0000
@@ -182,17 +182,6 @@ SET GLOBAL gtid_binlog_state = '0-1-10,1
 show binary logs;
 Log_name	File_size
 master-bin.000001	#
-include/show_binlog_events.inc
-Log_name	Pos	Event_type	Server_id	End_log_pos	Info
-master-bin.000001	#	Format_desc	#	#	SERVER_VERSION, BINLOG_VERSION
-master-bin.000001	#	Gtid_list	#	#	[1-2-20,0-1-10,0-3-30]
-master-bin.000001	#	Binlog_checkpoint	#	#	master-bin.000001
-SELECT @@GLOBAL.gtid_binlog_pos;
-@@GLOBAL.gtid_binlog_pos
-1-2-20,0-3-30
-SELECT @@GLOBAL.gtid_binlog_state;
-@@GLOBAL.gtid_binlog_state
-1-2-20,0-1-10,0-3-30
 SET GLOBAL gtid_binlog_state = @old_state;
 ERROR HY000: This operation is not allowed if any GTID has been logged to the binary log. Run RESET MASTER first to erase the log
 RESET MASTER;
@@ -252,7 +241,7 @@ SELECT * FROM t1 ORDER BY a;
 include/stop_slave.inc
 SET gtid_domain_id= 1;
 INSERT INTO t1 VALUES (3);
-SET @pos= '1-1-1,0-1-110';
+SET @pos= 'POS';
 SELECT master_gtid_wait(@pos, 0);
 master_gtid_wait(@pos, 0)
 -1

=== modified file 'mysql-test/suite/rpl/r/rpl_gtid_crash.result'
--- a/mysql-test/suite/rpl/r/rpl_gtid_crash.result	2014-02-10 14:12:17 +0000
+++ b/mysql-test/suite/rpl/r/rpl_gtid_crash.result	2014-07-22 10:54:38 +0000
@@ -46,7 +46,7 @@ master-bin.000002	#
 master-bin.000003	#
 SHOW BINLOG EVENTS IN 'master-bin.000003' LIMIT 1,1;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
-master-bin.000003	#	Gtid_list	#	#	[1-1-2,2-1-1,0-1-1]
+master-bin.000003	#	Gtid_list	#	#	#
 SET SESSION debug_dbug="+d,crash_dispatch_command_before";
 SELECT 1;
 Got one of the listed errors
@@ -58,7 +58,7 @@ master-bin.000003	#
 master-bin.000004	#
 SHOW BINLOG EVENTS IN 'master-bin.000004' LIMIT 1,1;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
-master-bin.000004	#	Gtid_list	#	#	[1-1-2,0-1-1,2-1-1]
+master-bin.000004	#	Gtid_list	#	#	#
 SELECT * FROM t1 ORDER BY a;
 a
 1

=== modified file 'mysql-test/suite/rpl/r/rpl_gtid_stop_start.result'
--- a/mysql-test/suite/rpl/r/rpl_gtid_stop_start.result	2014-02-07 19:24:39 +0000
+++ b/mysql-test/suite/rpl/r/rpl_gtid_stop_start.result	2014-07-22 10:54:38 +0000
@@ -34,10 +34,10 @@ master-bin.000003	#	Gtid_list	#	#	[0-1-3
 FLUSH LOGS;
 SHOW BINLOG EVENTS IN 'master-bin.000004' LIMIT 1,1;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
-master-bin.000004	#	Gtid_list	#	#	[1-1-1,0-1-4]
+master-bin.000004	#	Gtid_list	#	#	#
 SHOW BINLOG EVENTS IN 'master-bin.000005' LIMIT 1,1;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
-master-bin.000005	#	Gtid_list	#	#	[1-1-1,0-1-4]
+master-bin.000005	#	Gtid_list	#	#	#
 show binary logs;
 Log_name	File_size
 master-bin.000002	#

=== modified file 'mysql-test/suite/rpl/t/rpl_gtid_basic.test'
--- a/mysql-test/suite/rpl/t/rpl_gtid_basic.test	2014-06-25 13:24:11 +0000
+++ b/mysql-test/suite/rpl/t/rpl_gtid_basic.test	2014-07-22 10:54:38 +0000
@@ -175,9 +175,9 @@ SET GLOBAL gtid_binlog_state = '0-1-10,1
 --source include/show_binary_logs.inc
 --let $binlog_file= master-bin.000001
 --let $binlog_start= 4
---source include/show_binlog_events.inc
-SELECT @@GLOBAL.gtid_binlog_pos;
-SELECT @@GLOBAL.gtid_binlog_state;
+#--source include/show_binlog_events.inc
+#SELECT @@GLOBAL.gtid_binlog_pos;
+#SELECT @@GLOBAL.gtid_binlog_state;
 --error ER_BINLOG_MUST_BE_EMPTY
 SET GLOBAL gtid_binlog_state = @old_state;
 RESET MASTER;
@@ -254,6 +254,7 @@ INSERT INTO t1 VALUES (3);
 --let $pos= `SELECT @@gtid_binlog_pos`
 
 --connection s1
+--replace_result $pos POS
 eval SET @pos= '$pos';
 SELECT master_gtid_wait(@pos, 0);
 SELECT * FROM t1 WHERE a >= 3;

=== modified file 'mysql-test/suite/rpl/t/rpl_gtid_crash.test'
--- a/mysql-test/suite/rpl/t/rpl_gtid_crash.test	2014-02-10 14:12:17 +0000
+++ b/mysql-test/suite/rpl/t/rpl_gtid_crash.test	2014-07-22 10:54:38 +0000
@@ -100,7 +100,7 @@ SET gtid_domain_id= 2;
 INSERT INTO t1 VALUES (3);
 FLUSH LOGS;
 --source include/show_binary_logs.inc
---replace_column 2 # 4 # 5 #
+--replace_column 2 # 4 # 5 # 6 #
 SHOW BINLOG EVENTS IN 'master-bin.000003' LIMIT 1,1;
 
 --write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
@@ -120,7 +120,7 @@ EOF
 --source include/wait_until_connected_again.inc
 
 --source include/show_binary_logs.inc
---replace_column 2 # 4 # 5 #
+--replace_column 2 # 4 # 5 # 6 #
 SHOW BINLOG EVENTS IN 'master-bin.000004' LIMIT 1,1;
 --save_master_pos
 

=== modified file 'mysql-test/suite/rpl/t/rpl_gtid_stop_start.test'
--- a/mysql-test/suite/rpl/t/rpl_gtid_stop_start.test	2014-02-07 19:24:39 +0000
+++ b/mysql-test/suite/rpl/t/rpl_gtid_stop_start.test	2014-07-22 10:54:38 +0000
@@ -63,7 +63,7 @@ INSERT INTO t1 VALUES (4);
 --replace_column 2 # 4 # 5 #
 SHOW BINLOG EVENTS IN 'master-bin.000003' LIMIT 1,1;
 FLUSH LOGS;
---replace_column 2 # 4 # 5 #
+--replace_column 2 # 4 # 5 # 6 #
 SHOW BINLOG EVENTS IN 'master-bin.000004' LIMIT 1,1;
 
 --write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
@@ -83,7 +83,7 @@ EOF
 --enable_reconnect
 --source include/wait_until_connected_again.inc
 
---replace_column 2 # 4 # 5 #
+--replace_column 2 # 4 # 5 # 6 #
 SHOW BINLOG EVENTS IN 'master-bin.000005' LIMIT 1,1;
 --source include/show_binary_logs.inc
 



More information about the commits mailing list