[MDEV-42200] main.mysqlbinlog_stmt_compressed depends on previous tests - Jira

XML

Word

Printable

Details

Type: Technical task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11, 11.4, 11.8, 12.3, 13.2
Fix Version/s: 10.11, 11.4, 11.8, 12.3, 13.2
Component/s: Tests, MTR
Labels:
None

Description

main.mysqlbinlog_stmt_compressed implicitly relies on being run on a freshly started server.

It runs mysqlbinlog on the current binlog file from the start, and if that file still holds the previous test's events, it causes a mismatch.
Additionally, the result file hard-codes thread_id=5 / pseudo_thread_id=5, the first connection after startup. On a reused server we get a different value.

It didn't cause failures before, because due to MDEV-42198 the test was getting duplicate options --log-bin=master-bin --log-bin=master-bin, which made its set of options unique, so the server was restarted bfore the test. With MDEV-42198 fix, the test can be included into chains of tests, which can cause failures.

perl ./mtr compat/oracle.binlog_stm_sp_package main.mysqlbinlog_stmt_compressed --noreorder

compat/oracle.binlog_stm_sp_package      [ pass ]     82

main.mysqlbinlog_stmt_compressed         [ fail ]

        Test ended at 2026-11-11 21:05:01

CURRENT_TEST: main.mysqlbinlog_stmt_compressed

--- /share8t/bld/bb-10.11-elenst/mysql-test/main/mysqlbinlog_stmt_compressed.result	2026-11-11 19:42:04.116667631 +0200

+++ /share8t/bld/bb-10.11-elenst/mysql-test/main/mysqlbinlog_stmt_compressed.reject	2026-11-11 21:05:00.860821803 +0200

@@ -29,7 +29,7 @@

 /*M!100001 SET @@session.server_id=1*//*!*/;

 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 use `test`/*!*/;

 SET TIMESTAMP=X/*!*/;

 SET @@session.pseudo_thread_id=5/*!*/;

@@ -40,25 +40,262 @@

 SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=#/*!*/;

 SET @@session.lc_time_names=0/*!*/;

 SET @@session.collation_database=DEFAULT/*!*/;

-CREATE TABLE t1 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 TINYINT, f4 MEDIUMINT, f5 BIGINT, f6 INT, f7 INT, f8 char(1))

+CREATE DEFINER="root"@"localhost" PACKAGE "p1" AS

+PROCEDURE p1;

+FUNCTION f1 RETURN INT;

+END

 /*!*/;

 # at <pos>

 #<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-2 ddl

 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

-CREATE TABLE t2 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 INT, f4 INT, f5 MEDIUMINT, f6 INT, f7 INT, f8 char(1))

+CREATE DEFINER="root"@"localhost" PACKAGE IF NOT EXISTS "p1" AS

+PROCEDURE p1;

+FUNCTION f1 RETURN INT;

+END

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-3

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-3 ddl

 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1" AS

+PROCEDURE p1 AS

+BEGIN

+NULL;

+END;

+FUNCTION f1 RETURN INT AS

+BEGIN

+RETURN 10;

+END;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-4 ddl

+/*M!100001 SET @@session.gtid_seq_no=4*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE BODY p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-5 ddl

+/*M!100001 SET @@session.gtid_seq_no=5*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-6 ddl

+/*M!100001 SET @@session.gtid_seq_no=6*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE IF EXISTS p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-7 ddl

+/*M!100001 SET @@session.gtid_seq_no=7*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE "p1"    COMMENT 'package-p1-comment'

+ AS

+PROCEDURE p1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-8 ddl

+/*M!100001 SET @@session.gtid_seq_no=8*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1"    COMMENT 'package-body-p1-comment'

+ AS

+PROCEDURE p1 AS

+BEGIN

+NULL;

+END;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-9 ddl

+/*M!100001 SET @@session.gtid_seq_no=9*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-10 ddl

+/*M!100001 SET @@session.gtid_seq_no=10*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="xxx"@"localhost" PACKAGE "p1" AS

+PROCEDURE p1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-11 ddl

+/*M!100001 SET @@session.gtid_seq_no=11*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="xxx"@"localhost" PACKAGE BODY "p1" AS

+PROCEDURE p1 AS

+BEGIN

+NULL;

+END;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-12 ddl

+/*M!100001 SET @@session.gtid_seq_no=12*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-13 ddl

+/*M!100001 SET @@session.gtid_seq_no=13*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="xxx"@"localhost" PACKAGE "p1"    SQL SECURITY INVOKER

+ AS

+PROCEDURE p1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-14 ddl

+/*M!100001 SET @@session.gtid_seq_no=14*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="xxx"@"localhost" PACKAGE BODY "p1"    SQL SECURITY INVOKER

+ AS

+PROCEDURE p1 AS

+BEGIN

+NULL;

+END;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-15 ddl

+/*M!100001 SET @@session.gtid_seq_no=15*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-16 ddl

+/*M!100001 SET @@session.gtid_seq_no=16*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DATABASE test2

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-17 ddl

+/*M!100001 SET @@session.gtid_seq_no=17*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+use `test`/*!*/;

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE "test2"."test2"    COMMENT 'package-test2-comment'

+ AS

+FUNCTION f1 RETURN INT;

+PROCEDURE p1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-18 ddl

+/*M!100001 SET @@session.gtid_seq_no=18*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE BODY "test2"."test2"    COMMENT 'package-body-test2-comment'

+ AS

+FUNCTION f1 RETURN INT AS BEGIN RETURN 10; END;

+PROCEDURE p1 AS BEGIN SELECT f1(); END;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-19 ddl

+/*M!100001 SET @@session.gtid_seq_no=19*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE BODY test2.test2

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-20 ddl

+/*M!100001 SET @@session.gtid_seq_no=20*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE test2.test2

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-21 ddl

+/*M!100001 SET @@session.gtid_seq_no=21*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP DATABASE test2

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-22 ddl

+/*M!100001 SET @@session.gtid_seq_no=22*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+use `test`/*!*/;

+SET TIMESTAMP=X/*!*/;

+CREATE TABLE t1 (a INT)

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-23 ddl

+/*M!100001 SET @@session.gtid_seq_no=23*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE "p1" AS

+PROCEDURE p1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-24 ddl

+/*M!100001 SET @@session.gtid_seq_no=24*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1" AS

+a INT:=0;

+PROCEDURE p1 AS

+BEGIN

+INSERT INTO t1 VALUES (a);

+a:=a+1;

+END;

+BEGIN

+a:=10;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-25

+/*M!100001 SET @@session.gtid_seq_no=25*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

-INSERT INTO t1 VALUES (10, 1, 2, 3, 4, 5, 6, 7, "")

+INSERT INTO t1 VALUES ( NAME_CONST('a',10))

 /*!*/;

 # at <pos>

 #<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

@@ -66,14 +303,14 @@

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-4

-/*M!100001 SET @@session.gtid_seq_no=4*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-26

+/*M!100001 SET @@session.gtid_seq_no=26*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

-INSERT INTO t1 VALUES (11, 1, 2, 3, 4, 5, 6, 7, NULL)

+INSERT INTO t1 VALUES ( NAME_CONST('a',11))

 /*!*/;

 # at <pos>

 #<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

@@ -81,14 +318,34 @@

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-5

-/*M!100001 SET @@session.gtid_seq_no=5*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-27 ddl

+/*M!100001 SET @@session.gtid_seq_no=27*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE DEFINER="root"@"localhost" FUNCTION "dummy"() RETURN int(11)

+AS

+BEGIN

+RETURN 1;

+END

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-28

+/*M!100001 SET @@session.gtid_seq_no=28*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP FUNCTION dummy

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-29

+/*M!100001 SET @@session.gtid_seq_no=29*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

-INSERT INTO t1 VALUES (12, 1, 2, 3, NULL, 5, 6, 7, "A")

+INSERT INTO t1 VALUES ( NAME_CONST('a',10))

 /*!*/;

 # at <pos>

 #<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

@@ -96,14 +353,14 @@

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-6

-/*M!100001 SET @@session.gtid_seq_no=6*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-30

+/*M!100001 SET @@session.gtid_seq_no=30*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

-INSERT INTO t1 VALUES (13, 1, 2, 3, 0, 5, 6, 7, "A")

+INSERT INTO t1 VALUES ( NAME_CONST('a',11))

 /*!*/;

 # at <pos>

 #<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

@@ -111,62 +368,155 @@

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-7

-/*M!100001 SET @@session.gtid_seq_no=7*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-31 ddl

+/*M!100001 SET @@session.gtid_seq_no=31*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP PACKAGE p1

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-32 ddl

+/*M!100001 SET @@session.gtid_seq_no=32*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+DROP TABLE "t1" /* generated by server */

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-33 ddl

+/*M!100001 SET @@session.gtid_seq_no=33*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+SET @@session.sql_mode=#/*!*/;

+CREATE TABLE t1 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 TINYINT, f4 MEDIUMINT, f5 BIGINT, f6 INT, f7 INT, f8 char(1))

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-34 ddl

+/*M!100001 SET @@session.gtid_seq_no=34*//*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+CREATE TABLE t2 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 INT, f4 INT, f5 MEDIUMINT, f6 INT, f7 INT, f8 char(1))

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-35

+/*M!100001 SET @@session.gtid_seq_no=35*//*!*/;

+START TRANSACTION

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+INSERT INTO t1 VALUES (10, 1, 2, 3, 4, 5, 6, 7, "")

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+COMMIT

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-36

+/*M!100001 SET @@session.gtid_seq_no=36*//*!*/;

+START TRANSACTION

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+INSERT INTO t1 VALUES (11, 1, 2, 3, 4, 5, 6, 7, NULL)

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+COMMIT

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-37

+/*M!100001 SET @@session.gtid_seq_no=37*//*!*/;

+START TRANSACTION

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+INSERT INTO t1 VALUES (12, 1, 2, 3, NULL, 5, 6, 7, "A")

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+COMMIT

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-38

+/*M!100001 SET @@session.gtid_seq_no=38*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+INSERT INTO t1 VALUES (13, 1, 2, 3, 0, 5, 6, 7, "A")

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

+SET TIMESTAMP=X/*!*/;

+COMMIT

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-39

+/*M!100001 SET @@session.gtid_seq_no=39*//*!*/;

+START TRANSACTION

+/*!*/;

+# at <pos>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 INSERT INTO t2 SELECT * FROM t1

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-8

-/*M!100001 SET @@session.gtid_seq_no=8*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-40

+/*M!100001 SET @@session.gtid_seq_no=40*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 UPDATE t2 SET f4=5 WHERE f4>0 or f4 is NULL

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-9

-/*M!100001 SET @@session.gtid_seq_no=9*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-41

+/*M!100001 SET @@session.gtid_seq_no=41*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 DELETE FROM t1

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 COMMIT

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-10

-/*M!100001 SET @@session.gtid_seq_no=10*//*!*/;

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	GTID 0-1-42

+/*M!100001 SET @@session.gtid_seq_no=42*//*!*/;

 START TRANSACTION

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query_compressed	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 DELETE FROM t2

 /*!*/;

 # at <pos>

-#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=5	exec_time=x	error_code=0	xid=<xid>

+#<date> server id 1  end_log_pos <pos> CRC32 XXX 	Query	thread_id=10	exec_time=x	error_code=0	xid=<xid>

 SET TIMESTAMP=X/*!*/;

 COMMIT

 /*!*/;

Result length mismatch

 - saving '/share8t/bld/bb-10.11-elenst/mysql-test/var/log/main.mysqlbinlog_stmt_compressed/' to '/share8t/bld/bb-10.11-elenst/mysql-test/var/log/main.mysqlbinlog_stmt_compressed/'

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.082 of 2 seconds executing testcases

Failure: Failed 1/2 tests, 50.00% were successful.

Failing test(s): main.mysqlbinlog_stmt_compressed

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, MariaDB's bug tracker is found at

https://jira.mariadb.org

mysql-test-run: *** ERROR: there were failing test cases

Attachments

Activity

People

Assignee:: Elena Stepanova

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 28 minutes ago

Updated:: 28 minutes ago

Git Integration

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