Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
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.
Attachments
Issue Links
- relates to
-
-
- Open
-
-
-
- Open
-