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

binlog.binlog_stm_binlog fails sporadically in build bot

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
    • 10.4, 10.5, 10.6, 10.11
    • Tests
    • None

    Description

      This test fails sporadically.

      http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=10.4&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=^binlog.binlog_stm_binlog&fail_variant=&fail_info_short=&fail_info_full=&limit=100

      binlog.binlog_stm_binlog 'innodb,mix'    w3 [ fail ]
              Test ended at 2019-08-22 18:07:56
       
      CURRENT_TEST: binlog.binlog_stm_binlog
      --- /mnt/buildbot/build/mariadb-10.4.8/mysql-test/suite/binlog/r/binlog_stm_binlog.result	2019-08-22 07:15:21.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.4.8/mysql-test/suite/binlog/r/binlog_stm_binlog.reject	2019-08-22 18:07:55.834894345 -0400
      @@ -525,12 +525,12 @@
       master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
       master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
       master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; FLUSH TABLES
       master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
       master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
       master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
       master-bin.000001	#	Query	#	#	COMMIT
      -master-bin.000001	#	Gtid	#	#	GTID #-#-#
      -master-bin.000001	#	Query	#	#	use `test`; FLUSH TABLES
       RESET MASTER;
       insert /* before delayed */ delayed /* after delayed */ into t1 values (null),(null),(null),(null);
       insert  /*! delayed */ into t1 values (null),(null),(400),(null);
       
      mysqltest: Result content mismatch
       
       - saving '/mnt/buildbot/build/mariadb-10.4.8/mysql-test/var/3/log/binlog.binlog_stm_binlog-innodb,mix/' to '/mnt/buildbot/build/mariadb-10.4.8/mysql-test/var/log/binlog.binlog_stm_binlog-innodb,mix/'
       
      Retrying test binlog.binlog_stm_binlog, attempt(2/3)...
       
      worker[3] > Restart  - not started
      

      Error logs of more recent failures show this is known and suppressed in the test:

      2022-11-03 12:37:23 18 [ERROR]  BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Duplicate entry '2' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 461, Internal MariaDB error code: 1062
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            sujatha.sivakumar Sujatha Sivakumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.