Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11412 Ensure that table is truly dropped when using DROP TABLE
  3. MDEV-22826

Presence of Spider prevents tables from being force-deleted from other engines

    XMLWordPrintable

Details

    Description

      If Spider engine is loaded into the server (even if it's not used), tables from other engines fail to be force-deleted – DELETE works without errors, but orphan files, e.g. .MYD/.MYI or .ibd, remain on the disk.

      --let $datadir= `select @@datadir`
      		 
       
      		 
      install soname 'ha_spider';
      		 
       
      		 
      create table t1 (a int);
      		 
       
      		 
      --remove_file $datadir/test/t1.frm
      		 
       
      		 
      drop table t1;
      		 
      --echo # Files in <datadir>/test:
      		 
      --list_files $datadir/test

      bb-10.5-monty 645f37e49c

      		 
      drop table t1;
      		 
      # Files in datadir/test:
      		 
      db.opt
      		 
      t1.MYD
      		 
      t1.MYI

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            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.