[MDEV-16640] binlog_encryption.binlog_row_annotate failed in buldbot with wrong result - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 10.2(EOL)
Fix Version/s: N/A
Component/s: Tests, MTR
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

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-06-30 17:12

Updated:: 2018-06-30 17:17

Resolved:: 2018-06-30 17:17

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.