Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-4046

LevelDB: Multi-table DELETE locks itself and ends with ER_LOCK_WAIT_TIMEOUT

        Details

        • Type: Technical task
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          Test case:

          CREATE TABLE t1 (pk int primary key) ENGINE=LevelDB;
INSERT INTO t1 VALUES (1),(2);

CREATE TABLE t2 LIKE t1;
INSERT INTO t2 SELECT * FROM t1;

DELETE t2.* FROM t1, t2;

          Output:

          CREATE TABLE t1 (pk int primary key) ENGINE=LevelDB;
INSERT INTO t1 VALUES (1),(2);
CREATE TABLE t2 LIKE t1;
INSERT INTO t2 SELECT * FROM t1;
main.t1                                  [ fail ]
        Test ended at 2013-01-15 04:13:16

CURRENT_TEST: main.t1
mysqltest: At line 8: query 'DELETE t2.* FROM t1, t2' failed: 1205: Lock wait timeout exceeded; try restarting transaction

          revision-id: psergey@askmonty.org-20130114195003-fgp08gh4swgcf1cx
revno: 4486
branch-nick: mysql-5.6-leveldb

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Possibly both this and MDEV-4044 come from the same basic (known) problem as below, and just needs to wait till it's fixed

                create table t1 (i int primary key) engine=leveldb;
                insert into t1 values (1),(1);
                ERROR HY000: Lock wait timeout exceeded; try restarting transaction

                Show
                elenst Elena Stepanova added a comment - Possibly both this and MDEV-4044 come from the same basic (known) problem as below, and just needs to wait till it's fixed create table t1 (i int primary key) engine=leveldb; insert into t1 values (1),(1); ERROR HY000: Lock wait timeout exceeded; try restarting transaction
                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

                Fixed by fix for MDEV-4047. Added a testcase.

                Show
                psergey Sergei Petrunia added a comment - Fixed by fix for MDEV-4047 . Added a testcase.

                  People

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 15 minutes
                      15m