Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL), 11.6(EOL)
Description
DROP DATABASE test; |
CREATE DATABASE test; |
USE test; |
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE TABLE t1 (c INT) ENGINE=Spider; |
CREATE TABLE t2 (c INT) ENGINE=Spider; |
RENAME TABLE t2 TO doesnotexist.t; |
Leads to:
11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug) |
11.2.5-dbg>RENAME TABLE t2 TO doesnotexist.t;
|
ERROR 1049 (42000): Unknown database 'doesnotexist'
|
In the client. However, in the error log we see:
11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug) |
2024-07-29 10:11:18 4 [ERROR] mariadbd: Can't find record in 'spider_tables'
|
2024-07-29 10:11:18 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 2 of type 'rename table'
|
Removing either the DROP/CREATE/USE test db, or the t1 table creation changes the output to:
11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug) |
2024-07-29 10:14:54 4 [ERROR] mariadbd: Can't find record in 'spider_tables'
|
2024-07-29 10:14:54 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 1 of type 'rename table'
|
Attachments
Issue Links
- relates to
-
MDEV-31111 ERRORS: Invalid default value for 'check_time', DDL_LOG: Got error 1062 ... for entry 1 of type 'rename table', 1146: Table 'mysql.spider_table_sts' doesn't exist, ER_TABLE_EXISTS_ERROR and Got error 12524 'unknown' from SPIDER on RENAME/DROP TABLE
- Closed