[MDEV-16640] binlog_encryption.binlog_row_annotate failed in buldbot with wrong result Created: 2018-06-30  Updated: 2018-06-30  Resolved: 2018-06-30

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/5173

10.2 352c7e0dfaa0f121c5b35e1d9fafb9ec

 
binlog_encryption.binlog_row_annotate 'cmpr' w3 [ fail ]
 
        Test ended at 2018-06-17 17:11:24
 
 
 
CURRENT_TEST: binlog_encryption.binlog_row_annotate
 
--- /usr/share/mysql-test/suite/binlog_encryption/binlog_row_annotate.result	2018-06-17 16:50:10.000000000 +0300
 
+++ /dev/shm/var/3/log/binlog_row_annotate.reject	2018-06-18 00:11:24.200770491 +0300
 
@@ -108,8 +108,7 @@
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1 ddl
 
-/*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
 
 /*!100001 SET @@session.gtid_domain_id=0*//*!*/;
 
 /*!100001 SET @@session.server_id=1*//*!*/;
 
 /*!100001 SET @@session.gtid_seq_no=1*//*!*/;
 
@@ -117,7 +116,7 @@
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
 SET TIMESTAMP=1000000000/*!*/;
 
 SET @@session.pseudo_thread_id=#/*!*/;
 
-SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/;
 
+SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
 
 SET @@session.sql_mode=0/*!*/;
 
 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
 
 /*!\C latin1 *//*!*/;
 
@@ -127,7 +126,7 @@
 
 CREATE DATABASE test1
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
 
 /*!100001 SET @@session.gtid_seq_no=2*//*!*/;
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
@@ -135,7 +134,7 @@
 
 CREATE DATABASE test2
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
 
 /*!100001 SET @@session.gtid_seq_no=3*//*!*/;
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
@@ -149,10 +148,10 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test1`.`t1`
 
 ### SET
 
@@ -175,10 +174,10 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test2`.`t2`
 
 ### SET
 
@@ -201,10 +200,10 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test3`.`t3`
 
 ### SET
 
@@ -227,15 +226,15 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
+# at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> DELETE test1.t1, test2.t2
 
 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
 
 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
-# at #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
 
 ### DELETE FROM `test1`.`t1`
 
@@ -268,10 +267,10 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test2`.`t2`
 
 ### SET
 
@@ -294,12 +293,12 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> DELETE xtest1.xt1, test2.t2
 
 #Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
 
 #Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
 
 ### DELETE FROM `test2`.`t2`
 
 ### WHERE
 
@@ -340,8 +339,7 @@
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1 ddl
 
-/*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
 
 /*!100001 SET @@session.gtid_domain_id=0*//*!*/;
 
 /*!100001 SET @@session.server_id=1*//*!*/;
 
 /*!100001 SET @@session.gtid_seq_no=1*//*!*/;
 
@@ -349,7 +347,7 @@
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
 SET TIMESTAMP=1000000000/*!*/;
 
 SET @@session.pseudo_thread_id=#/*!*/;
 
-SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/;
 
+SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
 
 SET @@session.sql_mode=0/*!*/;
 
 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
 
 /*!\C latin1 *//*!*/;
 
@@ -359,11 +357,11 @@
 
 CREATE DATABASE test1
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
 
 /*!100001 SET @@session.gtid_seq_no=2*//*!*/;
 
 # at #
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
 
 /*!100001 SET @@session.gtid_seq_no=3*//*!*/;
 
 # at #
 
 # at #
 
@@ -373,10 +371,10 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test1`.`t1`
 
 ### SET
 
@@ -425,14 +423,14 @@
 
 /*!*/;
 
 # at #
 
 # at #
 
+# at #
 
+# at #
 
+# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
 
 #Q> DELETE test1.t1, test2.t2
 
 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
 
 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
 
 #010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
-# at #
 
-# at #
 
-# at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
 
 ### DELETE FROM `test1`.`t1`
 
 ### WHERE
 
@@ -499,8 +497,7 @@
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1 ddl
 
-/*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
 
 /*!100001 SET @@session.gtid_domain_id=0*//*!*/;
 
 /*!100001 SET @@session.server_id=1*//*!*/;
 
 /*!100001 SET @@session.gtid_seq_no=1*//*!*/;
 
@@ -508,7 +505,7 @@
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
 SET TIMESTAMP=1000000000/*!*/;
 
 SET @@session.pseudo_thread_id=#/*!*/;
 
-SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/;
 
+SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
 
 SET @@session.sql_mode=0/*!*/;
 
 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
 
 /*!\C latin1 *//*!*/;
 
@@ -518,7 +515,7 @@
 
 CREATE DATABASE test1
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
 
 /*!100001 SET @@session.gtid_seq_no=2*//*!*/;
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
@@ -526,7 +523,7 @@
 
 CREATE DATABASE test2
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3 ddl
 
+#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
 
 /*!100001 SET @@session.gtid_seq_no=3*//*!*/;
 
 # at #
 
 #010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
 
@@ -539,8 +536,8 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test1`.`t1`
 
 ### SET
 
@@ -562,8 +559,8 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test2`.`t2`
 
 ### SET
 
@@ -585,8 +582,8 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test3`.`t3`
 
 ### SET
 
@@ -608,11 +605,11 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 # at #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
 
 ### DELETE FROM `test1`.`t1`
 
@@ -644,8 +641,8 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
 
 ### INSERT INTO `test2`.`t2`
 
 ### SET
 
@@ -667,8 +664,8 @@
 
 BEGIN
 
 /*!*/;
 
 # at #
 
-#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 # at #
 
+#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
 
 #010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
 
 ### DELETE FROM `test2`.`t2`
 
 ### WHERE
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2018-06-30 ]

It was an experimental test run with a client/server version mix.

Generated at Thu Feb 08 08:30:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.