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

INSERT fails to return an error after transaction abort

    XMLWordPrintable

Details

    Description

      Under Repeatable Read isolation level, if two transactions concurrently execute and deadlock happend, the transaction that reported deadlock still executes remaining statements by transaction.

      /* init */ CREATE TABLE t(c1 INT PRIMARY KEY, c2 INT UNIQUE);
      /* init */ INSERT INTO t(c1) VALUES (8);
      /* t1 */ BEGIN;
      /* t1 */ UPDATE t SET c1=5, c2=7 WHERE -19;
      /* t2 */ BEGIN;
      /* t2 */ DELETE FROM t WHERE -15; -- blocked
      /* t1 */ UPDATE t SET c1=3 WHERE 0.5;
      /* t2 */ DELETE FROM t WHERE -15; -- deadlock
      /* t2 */ ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
      /* t1 */ COMMIT;
      /* t2 */ INSERT IGNORE INTO t(c1) VALUES (2);
      /* t2 */ SELECT * FROM t FOR UPDATE; -- [(2, NULL), (3, 7)]
      /* t2 */ ROLLBACK;
      /* t2 */ SELECT * FROM t FOR UPDATE; -- [(3, 7)]
      

      Due to the application of autocommit, the ROLLBACK statement should have no effect after deadlock in t2. The last select should return [(2, NULL), (3, 7)].

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              John Jove John Jove
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3h
                  3h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.