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

gcol.gcol_purge contaminates further execution of innodb.gap_locks

    XMLWordPrintable

Details

    Description

      10.5 ea40c75c

      $ perl ./mtr gcol.gcol_purge innodb.gap_locks --noreorder
       
      gcol.gcol_purge 'innodb'                 [ pass ]  11825
      innodb.gap_locks 'innodb'                [ fail ]
              Test ended at 2022-05-27 23:10:05
       
      CURRENT_TEST: innodb.gap_locks
      --- /mnt8t/bld/10.5-debug-nightly/mysql-test/suite/innodb/r/gap_locks.result	2021-09-14 19:07:00.000000000 +0300
      +++ /mnt8t/bld/10.5-debug-nightly/mysql-test/suite/innodb/r/gap_locks.reject	2022-05-27 23:10:05.289693153 +0300
      @@ -8,28 +8,28 @@
       DELETE FROM t1 WHERE b='2' AND c=2;
       SHOW ENGINE INNODB STATUS;
       Type	Name	Status
      -InnoDB		2 lock struct(s), 1 row lock(s)
      +InnoDB		0 lock struct(s), 0 row lock(s)
       ROLLBACK;
       SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
       BEGIN;
       DELETE FROM t1 WHERE b='2' AND c=2;
       SHOW ENGINE INNODB STATUS;
       Type	Name	Status
      -InnoDB		2 lock struct(s), 1 row lock(s)
      +InnoDB		0 lock struct(s), 0 row lock(s)
       ROLLBACK;
       SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
       BEGIN;
       DELETE FROM t1 WHERE b='2' AND c=2;
       SHOW ENGINE INNODB STATUS;
       Type	Name	Status
      -InnoDB		1 lock struct(s), 0 row lock(s)
      +InnoDB		0 lock struct(s), 0 row lock(s)
       ROLLBACK;
       SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
       BEGIN;
       DELETE FROM t1 WHERE b='2' AND c=2;
       SHOW ENGINE INNODB STATUS;
       Type	Name	Status
      -InnoDB		1 lock struct(s), 0 row lock(s)
      +InnoDB		0 lock struct(s), 0 row lock(s)
       ROLLBACK;
       SET GLOBAL INNODB_STATUS_OUTPUT_LOCKS = @save_locks;
       DROP TABLE t1;
       
      mysqltest: Result content mismatch
      

      Attachments

        Issue Links

          Activity

            People

              vlad.lesin Vladislav Lesin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.