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

InnoDB: MySQL is trying to drop database…open handles to table …`#sql-ib1148`

    XMLWordPrintable

Details

    Description

      Immediately after the push of MDEV-16678 into 10.5, we got the following failure on one platform:

      10.5 adb117cf6901a0e0da7577267be1209359892207

      		 
      innodb.foreign_key 'innodb'              w1 [ fail ]  Found warnings/errors in server log file!
      		 
              Test ended at 2019-12-10 21:04:58
      		 
      line
      		 
      2019-12-10 21:04:53 3 [Warning] InnoDB: MySQL is trying to drop database `best`.`` though there are still open handles to table `best`.`#sql-ib1148`.
      		 
      ^ Found warnings in /dev/shm/var/1/log/mysqld.1.err

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3140/steps/mtr/logs/stdio

      I am unable to repeat the failure. I believe that this could have been caused by the second commit of MDEV-16678.

      I believe that this would be best addressed by MDEV-8069 where the to-be-dropped tables would be moved into a separate directory.

      Attachments

        Issue Links

          is blocked by

          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-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22955 innodb.innodb-alter fails in buildbot with extra warning

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

          Task - A task that needs to be done. MDEV-16678 Use MDL for innodb background threads instead of dict_operation_lock

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

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.