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

binlog.innodb_rc_insert_before_delete hangs when run after some tests

    XMLWordPrintable

Details

    Description

      The recently added by MDEV-30010 test turns out to be unstable.
      It hangs

      binlog.binlog_xa_prepared_disconnect 'innodb,mix' [ pass ]   4497
      connect  pause_purge,localhost,root;
      START TRANSACTION WITH CONSISTENT SNAPSHOT;
      connection default;
      CREATE TABLE t_30010 (pk int PRIMARY KEY, sk INT UNIQUE) ENGINE=InnoDB;
      INSERT INTO t_30010 VALUES (10, 100);
      connect  con1,localhost,root;
      BEGIN;
      SELECT * FROM t_30010 WHERE sk = 100 FOR UPDATE;
      pk	sk
      10	100
      connect  con2,localhost,root;
      SET DEBUG_SYNC="lock_wait_suspend_thread_enter SIGNAL insert_wait_started";
      INSERT INTO t_30010 VALUES (5, 100) # trx 1;
      connect  con3,localhost,root;
      SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
      SET DEBUG_SYNC="now WAIT_FOR insert_wait_started";
      Warnings:
      Warning	1639	debug sync point wait timed out
      SET DEBUG_SYNC="lock_wait_suspend_thread_enter SIGNAL delete_started_waiting";
      BEGIN;
      UPDATE t_30010 SET sk = 200 WHERE sk = 100; # trx 2;
      connection con1;
      SET DEBUG_SYNC="now WAIT_FOR delete_started_waiting";
      Warnings:
      Warning	1639	debug sync point wait timed out
      DELETE FROM t_30010 WHERE sk=100;
      COMMIT;
      disconnect con1;
      connection con2;
      binlog.innodb_rc_insert_before_delete 'innodb,mix' [ fail ]
              Test ended at 2023-01-28 16:51:56
      
      

      when is preceded by another test like above.

      Attachments

        Activity

          People

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