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

      mdev_29667.test

      --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
      

      mdev_29667.cnf

      !include include/default_mysqld.cnf
      !include ../my_1_1.cnf
      !include ../my_2_1.cnf
      

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.