Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28970

Some tests that show binlog events will fail if run after a test with binlogging on

    XMLWordPrintable

Details

    Description

      Some tests that call --source include/show_binlog_events.inc will fail if run after a test with binary logging. For example:

      ./mtr binlog.binlog_empty_xa_prepared --repeat 2
      

      binlog.binlog_empty_xa_prepared 'innodb,mix' [ pass ]   1963
      binlog.binlog_empty_xa_prepared 'innodb,mix' [ 2 fail ]
              Test ended at 2022-06-28 09:15:03
       
      CURRENT_TEST: binlog.binlog_empty_xa_prepared
      --- /home/parallels/dev/build-test/build1/mysql-test/suite/binlog/r/binlog_empty_xa_prepared.result	2022-06-13 09:20:12.000000000 +0100
      +++ /home/parallels/dev/build-test/build1/mysql-test/suite/binlog/r/binlog_empty_xa_prepared.reject	2022-06-28 09:15:03.124868610 +0100
      @@ -20,6 +20,31 @@
       include/show_binlog_events.inc
       Log_name	Pos	Event_type	Server_id	End_log_pos	Info
       master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	Annotate_rows	#	#	INSERT INTO t1 VALUES (1)
      +master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
      +master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
      +master-bin.000001	#	Xid	#	#	COMMIT /* XID */
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; CREATE SEQUENCE s ENGINE=InnoDB
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	Annotate_rows	#	#	SELECT NEXT VALUE FOR s
      +master-bin.000001	#	Table_map	#	#	table_id: # (test.s)
      +master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
      +master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	XA START X'32',X'',1 GTID #-#-#
      +master-bin.000001	#	Query	#	#	XA END X'32',X'',1
      +master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'32',X'',1
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	XA ROLLBACK X'32',X'',1
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; DROP SEQUENCE `s` /* generated by server */
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t1` /* generated by server */
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_1`,`seq_1`
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
       master-bin.000001	#	Query	#	#	use `test`; CREATE TEMPORARY SEQUENCE seq_1
       master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
       master-bin.000001	#	Query	#	#	use `test`; CREATE TEMPORARY TABLE tmp_1(c INT)
       
      mysqltest: Result length mismatch
      

      Tests with this problem include:
      binlog.binlog_empty_xa_prepared
      binlog.binlog_stm_binlog.test
      binlog.binlog_stm_datetime_ranges_mdev15289.test
      binlog.binlog_stm_do_db.test
      binlog.innodb_autoinc_lock_mode_binlog.test
      main.mysql_upgrade_view
      main.stat_tables_rbr
      maria.rollback.test
      plugins.test_sql_service.test

      Attachments

        Issue Links

          Activity

            People

              angelique.sklavounos Angelique Sklavounos (Inactive)
              angelique.sklavounos Angelique Sklavounos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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