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

Spider: Could not remove temporary table on DROP when mysql.spider_tables is missing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
    • Fix Version/s: N/A
    • Labels:
      None

      Description

      INSTALL PLUGIN spider SONAME 'ha_spider.so';
      SELECT SLEEP (5);  # Avoid MDEV-28218
      DROP TABLE IF EXISTS mysql.spider_tables;
      CREATE TEMPORARY TABLE t (c INT) ENGINE=Spider;
      DROP TABLE t;
      

      Leads to:

      10.9.0 5be92887c2caacb45af87b1131db952ce627e83a (Debug)

      10.9.0-dbg>CREATE TEMPORARY TABLE t (c INT) ENGINE=Spider;
      Query OK, 0 rows affected, 4 warnings (0.003 sec)
       
      10.9.0-dbg>DROP TABLE t;
      ERROR 1146 (42S02): Table 'mysql.spider_tables' doesn't exist
      

      (The warnings are 4x Error 1429 Unable to connect to foreign data source: localhost)

      However, in the error log we see:

      10.9.0 5be92887c2caacb45af87b1131db952ce627e83a (Debug)

      2022-04-02 16:25:38 0 [Note] /test/MD160322-mariadb-10.9.0-linux-x86_64-dbg/bin/mysqld: ready for connections.
      Version: '10.9.0-MariaDB-debug'  socket: '/test/MD160322-mariadb-10.9.0-linux-x86_64-dbg/socket.sock'  port: 10908  MariaDB Server
      2022-04-02 16:25:43 4 [Warning] Could not remove temporary table: '/test/MD160322-mariadb-10.9.0-linux-x86_64-dbg/data/#sql-temptable-3544ff-4-0', error: 2
      

      Confirmed present in 10.4-10.9 and likely present in 10.2, 10.3 also.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nayuta-yanagisawa Nayuta Yanagisawa
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.