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

rpl.rpl_row_foreign_key_mdl timeout

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 12.3, 13.0
    • None
    • Replication, Tests, MTR
    • None

    Description

      The test times out on multiple platforms, quite sporadically, see. E.g
      BB reports
      for/at 10.11 07987cd47 x86-debian-12-fulltest-debug 2026-03-08 01:05

                           rpl.rpl_row_foreign_key_mdl 'row'        w3 [ fail ]
              Test ended at 2026-03-08 00:14:47
       
      CURRENT_TEST: rpl.rpl_row_foreign_key_mdl
      analyze: sync_with_master
      mysqltest: At line 53: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 2280, 300, '')' returned -1 indicating timeout after 300 seconds
       
      The result from queries just before the failure was:
      < snip >
      set @saved_exec_mode= @@global.slave_exec_mode;
      set @@global.debug_dbug= "+d,rows_log_event_after_open_table";
      include/stop_slave.inc
      set global slave_exec_mode='STRICT';
      include/start_slave.inc
      # INSERT on master so it is replicated to slave (where its execution will be blocked after taking locks)
      connection master;
      INSERT INTO t1 (f2) VALUES (0);
      connection slave;
      set debug_sync='now WAIT_FOR after_open_table';
      # test.t1 should always be locked with SHARED_WRITE
      # test.t2 lock type should be SHARED_WRITE only when slave_exec_mode is IDEMPOTENT. Current mode: STRICT
      connection slave;
      SET DEBUG_SYNC= 'RESET';
      set debug_sync='now SIGNAL continue_rows_ev';
      SET @@GLOBAL.debug_dbug = @saved_dbug;
      SET @@GLOBAL.slave_exec_mode = @saved_exec_mode;
      connection master;
      DROP TABLE t2;
      DROP TABLE t1;
      
      

      Interestingly no 11.8 in the BB failure list, but bb-11.8-release is there.
      I initially suspect synchronization logics fails.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.