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

rpl.rpl_fragment_row_event_main fails: Binlog_checkpoint listed after CREATE TABLE in binlog events (result content mismatch)

    XMLWordPrintable

Details

    Description

      rpl.rpl_fragment_row_event_main fails on 12.3 with a result content mismatch: a Binlog_checkpoint event is listed after the CREATE TABLE events in the include/show_binlog_events.inc output instead of before them.

      Build Run Info

      Branch Builder name Date Commit Variant
      12.3 aarch64-rhel-8 2026-10-06T17:28:05Z fffe55f39cef9e077112f5e9abde3d8dd11ba492 row

      Failure text

      rpl.rpl_fragment_row_event_main 'row'    w6 [ fail ]
              Test ended at 2026-10-06 15:33:15
       
      CURRENT_TEST: rpl.rpl_fragment_row_event_main
      --- /home/buildbot/aarch64-rhel-8/build/mysql-test/suite/rpl/r/rpl_fragment_row_event_main.result	2026-10-06 15:01:09.000000000 +0000
      +++ /home/buildbot/aarch64-rhel-8/build/mysql-test/suite/rpl/r/rpl_fragment_row_event_main.reject	2026-10-06 15:33:14.187442966 +0000
      @@ -1715,9 +1715,9 @@
       connection server_1;
       include/show_binlog_events.inc
       Log_name	Pos	Event_type	Server_id	End_log_pos	Info
      -master-bin.000027	#	Binlog_checkpoint	#	#	master-bin.000027
       master-bin.000027	#	Gtid	#	#	GTID #-#-#
       master-bin.000027	#	Query	#	#	use `test`; create table t1 (a int, b longblob) engine=innodb
      +master-bin.000027	#	Binlog_checkpoint	#	#	master-bin.000027
       master-bin.000027	#	Gtid	#	#	BEGIN GTID #-#-#
       master-bin.000027	#	Annotate_rows	#	#	insert into t1 values (1, repeat("a", 1024))
       master-bin.000027	#	Table_map	#	#	table_id: # (test.t1)
      @@ -1737,9 +1737,9 @@
       connection server_1;
       include/show_binlog_events.inc
       Log_name	Pos	Event_type	Server_id	End_log_pos	Info
      -master-bin.000027	#	Binlog_checkpoint	#	#	master-bin.000027
       master-bin.000027	#	Gtid	#	#	GTID #-#-#
       master-bin.000027	#	Query	#	#	use `test`; create table t1 (a int, b longblob) engine=innodb
      +master-bin.000027	#	Binlog_checkpoint	#	#	master-bin.000027
       master-bin.000027	#	Gtid	#	#	BEGIN GTID #-#-#
       master-bin.000027	#	Annotate_rows	#	#	insert into t1 values (1, repeat("a", 1024))
       master-bin.000027	#	Table_map	#	#	table_id: # (test.t1)
       
      Result content mismatch
       
       - saving '/home/buildbot/aarch64-rhel-8/build/mysql-test/var/6/log/rpl.rpl_fragment_row_event_main-row/' to '/home/buildbot/aarch64-rhel-8/build/mysql-test/var/log/rpl.rpl_fragment_row_event_main-row/'
       
      Retrying test rpl.rpl_fragment_row_event_main, attempt(2/3)...

      The failure text is identical in the other six matching runs between 2026-10-02 and 2026-10-09, apart from worker id, timestamps and paths: refs/pull/5617/head (aarch64-ubuntu-2404), bb-serg-MDEV-25848-mvi (aarch64-centos-stream9), refs/pull/5826/head (aarch64-debian-sid), refs/pull/5566/head (amd64-ubuntu-2604), bb-main-MDEV-14992-MDEV-39092 (aarch64-fedora-43), refs/pull/5278/head (aarch64-macos).

      Analysis

      Seven distinct builders are affected: six aarch64 builders and amd64-ubuntu-2604. Multiple builders show the identical diff, which points at the test rather than at a single builder. include/show_events.inc skips the first three events of the binlog by position, so the expected result starts with the second Binlog_checkpoint event, the one naming the current binlog (master-bin.000027). In the failing runs this event is logged after the CREATE TABLE events, at the two places where the test lists the start of that binlog. The test does not set $skip_checkpoint_events, so the position of this event is part of the expected result. The same ordering variance failed binlog.binlog_checkpoint in MDEV-29607, which was fixed in the test case.

      Created via the mtr-failure-bug skill.

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              susil.behera Susil Behera
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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