[MDEV-28219] Spider: Could not remove temporary table on DROP when mysql.spider_tables is missing Created: 2022-04-02  Updated: 2022-04-27  Resolved: 2022-04-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Roel Van de Paar Assignee: Nayuta Yanagisawa (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-27575 Spider: UBSAN member access within nu... Closed
relates to MDEV-28225 Disallow user to create Spider tempor... Closed
relates to MDEV-28218 Spider: thread hang/deadlock as resul... Closed

 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.

 Comments   
Comment by Nayuta Yanagisawa (Inactive) [ 2022-04-12 ]

One cannot create a temporary table with Spider anymore because of MDEV-28225.

Generated at Thu Feb 08 09:59:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.