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

Server hangs on DROP DATABASE after failing LOCK TABLES on Spider table

    XMLWordPrintable

    Details

      Description

      --disable_query_log
      --disable_result_log
      --source ../../t/test_init.inc
      --enable_result_log
      --enable_query_log
       
      --connection child2_1
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      eval CREATE TABLE tbl_a (
          a INT
      ) $CHILD2_1_ENGINE $CHILD2_1_CHARSET;
       
      --connection master_1
      CREATE DATABASE auto_test_local;
      USE auto_test_local;
      eval CREATE TABLE tbl_a (
          a INT
      ) $MASTER_1_ENGINE $MASTER_1_CHARSET COMMENT='table "tbl_a", srv "s_2_1"';
      eval CREATE TABLE tbl_b (
          a INT
      ) $MASTER_1_ENGINE $MASTER_1_CHARSET;
       
      LOCK TABLES tbl_a WRITE;
      --error 1429
      LOCK TABLES tbl_b READ, tbl_a READ;
       
      --connection master_1
      DROP DATABASE IF EXISTS auto_test_local;
       
      --connection child2_1
      DROP DATABASE IF EXISTS auto_test_remote;
       
      --disable_query_log
      --disable_result_log
      --source ../t/test_deinit.inc
      --enable_query_log
      --enable_result_log
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nayuta-yanagisawa Nayuta Yanagisawa
              Reporter:
              nayuta-yanagisawa Nayuta Yanagisawa
              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.