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

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
    • N/A
    • Storage Engine - Spider
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27575 Spider: UBSAN member access within null pointer of type 'struct st_plugin_int and SIGSEGV in intern_plugin_lock on SHUTDOWN when setting Spider as default storage engine (temporary or global)

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28225 Disallow user to create Spider temporary table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28218 Spider: thread hang/deadlock as result of INSTALL PLUGIN and DROP TABLE

          • Major - Major loss of function.
          • Closed

          Activity

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              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.