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

Unexpected ER_LOCK_WAIT_TIMEOUT upon locking a MERGE table

    XMLWordPrintable

Details

    Description

      connect (con1,localhost,root,,);
      SET lock_wait_timeout=1;
       
      connection default;
      CREATE TABLE t (id INT) ENGINE=MyISAM;
      CREATE TABLE t1 (id INT) ENGINE=MRG_MYISAM UNION(t);
      LOCK TABLE t1 READ;
       
      connection con1;
      --echo ### HERE: 
      LOCK TABLE t1 READ;
       
      # Cleanup
      disconnect con1;
      connection default;
      UNLOCK TABLES;
      DROP TABLE t1, t;
      

      10.0 09bc99fac

      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      SET lock_wait_timeout=1;
      CREATE TABLE t (id INT) ENGINE=MyISAM;
      CREATE TABLE t1 (id INT) ENGINE=MRG_MYISAM UNION(t);
      LOCK TABLE t1 READ;
      ### HERE: 
      LOCK TABLE t1 READ;
      CURRENT_TEST: bug.t4
      mysqltest: At line 11: query 'LOCK TABLE t1 READ' failed: 1205: Lock wait timeout exceeded; try restarting transaction
       
       - saving '/data/bld/10.0/mysql-test/var/log/bug.t4/' to '/data/bld/10.0/mysql-test/var/log/bug.t4/'
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 9 seconds executing testcases
       
      Failure: Failed 1/1 tests, 0.00% were successful.
      

      Earlier the test passed. Starting from the revision below, the 2nd LOCK TABLE (under "### HERE") fails with ER_LOCK_WAIT_TIMEOUT.

      commit 9180e8666b8e31239d2e2075b703fb8bc8effc13
      Author: Sergei Golubchik
      Date:   Thu Jul 19 01:03:14 2018 +0200
       
          MDEV-16465 Invalid (old?) table or database name or hang in ha_innobase::delete_table and log semaphore wait upon concurrent DDL with foreign keys
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            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.