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

CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

    XMLWordPrintable

Details

    Description

      A table is allowed to be dropped despite being in use:

       
      		 
      --connection crash_me
      		 
      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
      		 
      xa start '1'; insert into t1 set pk=1; xa end '1'; xa prepare '1';
      		 
       
      		 
      # KILL server_process & restart
      		 
      xa recover; # =>
      		 
      +----------+--------------+--------------+------+
      		 
      | formatID | gtrid_length | bqual_length | data |
      		 
      +----------+--------------+--------------+------+
      		 
      |        1 |            1 |            0 | 1    |
      		 
      +----------+--------------+--------------+------+
      		 
      1 row in set (0.00 sec)
      		 
       
      		 
      --connection default
      		 
      --error 0
      		 
      DROP TABLE t1;

      Notice that use cases of survived prepared user XA have involved MDEV-742 disconnected prepared so instead of the crash a simple --diconnect would leave the trx prepared and offended by the following DROP.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21175 Remove dict_table_t::n_foreign_key_checks_running from InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21283 InnoDB: MySQL is trying to drop database…open handles to table …`#sql-ib1148`

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22733 XA PREPARE breaks MDL in pseudo_slave_mode=1

          • Major - Major loss of function.
          • Stalled
          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25506 Atomic DDL: .frm file is removed and orphan InnoDB tablespace is left behind upon crash recovery

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-742 LP:803649 - Xa recovery failed on client disconnection

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23223 If you cancel CTAS Query on MariaDB Server, it will not be canceled and Rollback will be executed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23484 Rollback unnecessarily acquires dict_operation_lock for every row

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25921 Implement CREATE TABLE...SELECT in one transaction

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21820 create table ... select is metadata locking information_schema

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-23234 move MDL from THD to st_transaction

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24225 Long semaphore wait in dict0dict.cc line 943 and semaphore wait >600 sec kill

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              9 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.