Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 11.5
Description
The bug is highly sporadic, and there are likely a number of extraneous clauses in the testcase which are not necessary to reproduce the bug. Currently repeating the testcase about 500-1000 times, using the CLI, with a fresh server start for each t/c loop, reproduces the issue.
SET sql_mode='traditional', max_heap_table_size=1048576; |
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
SET GLOBAL sql_mode=(SELECT CONCAT (@@sql_mode,',pipes_as_concat')); |
CREATE TABLE t2 (pk INT(1) NOT NULL,c_int_nokey INT(1),c_intk INT(1),cvck CHAR(1),cvc_nokey VARCHAR(1),PRIMARY KEY(pk),KEY c_intk (c_intk),KEY cvck (cvck,c_intk)) ENGINE=Spider AUTO_INCREMENT=+ 1 DEFAULT CHARSET=latin1; |
CREATE TABLE t (i1 INT NOT NULL,a INT,PRIMARY KEY(i1)) ENGINE=Spider; |
ALTER TABLE t2 ENGINE=InnoDB; |
DROP TABLE t; |
DROP TABLE t,t2,t3,t4; |
CREATE TABLE t3 (c INT,c2 CHAR(1)) ENCRYPTION="Y" ENGINE=Spider; |
RENAME TABLE t TO t2; |
Leads to:
11.1.0 2b61ff8f2221745f0a96855a0feb0825c426f993 (Debug) |
2023-04-22 15:37:10 0 [Note] /test/MD010423-mariadb-11.1.0-linux-x86_64-dbg/bin/mariadbd: ready for connections.
|
Version: '11.1.0-MariaDB-debug' socket: '/test/MD010423-mariadb-11.1.0-linux-x86_64-dbg/socket.sock' port: 10910 MariaDB Server
|
[ERROR] Invalid default value for 'check_time'
|
2023-04-22 15:37:10 4 [ERROR] DDL_LOG: Got error 1062 when trying to execute action for entry 1 of type 'rename table'
|
Further attempts to improve the test setup (MTR vs CLI), testcase length and reproducibility still in progress. Currently observed in 11.1 only, but likely present in other versions.