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

rpl tests sometimes failing on freebsd builders

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
    • N/A
    • CI
    • None

    Description

      10.6 2fa3ada07202bfd8764cff0bf2e5bbf8

      rpl.rpl_xa 'innodb,mix'                  w2 [ fail ]
              Test ended at 2022-06-28 18:58:40
       
      CURRENT_TEST: rpl.rpl_xa
      mysqltest: In included file "./include/sync_with_master_gtid.inc": 
      included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.inc at line 350:
      included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.test at line 4:
      At line 48: Failed to sync with master
       
      The result from queries just before the failure was:
      < snip >
      connection master;
      xa recover;
      formatID	gtrid_length	bqual_length	data
      1	11	0	skip_binlog
      set @@session.sql_log_bin = OFF;
      xa rollback 'skip_binlog';
      set @@session.sql_log_bin = ON;
      include/save_master_gtid.inc
      *** Zero must be in the list:
      connection master;
      xa recover;
      formatID	gtrid_length	bqual_length	data
      *** At the end of skip_log_binb section gtid list has 0 more:
      flush logs;
      show binlog events in 'master-bin.000007' limit 1,1;
      Log_name	Pos	Event_type	Server_id	End_log_pos	Info
      master-bin.000007	#	Gtid_list	1	#	[0-1-25]
      connection slave;
      include/sync_with_master_gtid.inc
      Timeout in master_gtid_wait('0-1-25', 120), current slave GTID position is: 0-1-11.
      

      The replica error log shows:

      2022-06-28 18:56:39 7 [ERROR] Error reading packet from server: bogus data in log event; the first event 'master-bin.000001' at 4, the last event read from 'master-bin.000002' at 343, the last byte read from 'master-bin.000002' at 362. (server_errno=1236)
      2022-06-28 18:56:39 7 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'bogus data in log event; the first event 'master-bin.000001' at 4, the last event read from 'master-bin.000002' at 343, the last byte read from 'master-bin.000002' at 362.', Internal MariaDB error code: 1236
      2022-06-28 18:56:39 7 [Note] Slave I/O thread exiting, read up to log 'master-bin.000002', position 343, master 127.0.0.1:16020
      

      Test always seems to be retry-pass.
      Also seen on 10.7, 10.10 bb branches.
      Var dir: https://drive.google.com/drive/folders/1FGUV55ChN3Wpc4qG7XeFw4nDnaWzzAJj

      rpl.rpl_xa_gtid_pos_auto_engine failures seem similar (replica error log has same messages):

      10.6 2fa3ada07202bfd8764cff0bf2e5bbf8

      rpl.rpl_xa_gtid_pos_auto_engine 'innodb,mix' w2 [ fail ]
              Test ended at 2022-06-28 19:00:47
       
      CURRENT_TEST: rpl.rpl_xa_gtid_pos_auto_engine
      mysqltest: In included file "./include/sync_with_master_gtid.inc": 
      included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.inc at line 350:
      included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa_gtid_pos_auto_engine.test at line 16:
      At line 48: Failed to sync with master
       
      The result from queries just before the failure was:
      < snip >
      connection master;
      xa recover;
      formatID	gtrid_length	bqual_length	data
      1	11	0	skip_binlog
      set @@session.sql_log_bin = OFF;
      xa rollback 'skip_binlog';
      set @@session.sql_log_bin = ON;
      include/save_master_gtid.inc
      *** Zero must be in the list:
      connection master;
      xa recover;
      formatID	gtrid_length	bqual_length	data
      *** At the end of skip_log_binb section gtid list has 0 more:
      flush logs;
      show binlog events in 'master-bin.000007' limit 1,1;
      Log_name	Pos	Event_type	Server_id	End_log_pos	Info
      master-bin.000007	#	Gtid_list	1	#	[0-1-25]
      connection slave;
      include/sync_with_master_gtid.inc
      Timeout in master_gtid_wait('0-1-25', 120), current slave GTID position is: 0-1-11.
      

      Attachments

        Activity

          People

            knielsen Kristian Nielsen
            angelique.sklavounos Angelique Sklavounos (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.