Bug #112660 Got error -1 - 'Unknown error -1' from storage engine
Submitted: 9 Oct 2023 2:21 Modified: 9 Oct 2023 8:51
Reporter: Ying FU Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.1.0, 8.0.34 OS:Linux
Assigned to: CPU Architecture:Any

[9 Oct 2023 2:21] Ying FU 
Description:
mysql> CREATE  TABLE table22 ( v0 FLOAT  DEFAULT 2031962.984951307  PRIMARY KEY, v1 LONGBLOB NOT  NULL  , v2 MEDIUMBLOB NOT  NULL  , v3 INT NOT  NULL DEFAULT 185659406 , v4 BOOL NOT  NULL DEFAULT FALSE , v5 DATE  DEFAULT '1510-12-12 13:55:01.953044' , v6 TINYTEXT NOT  NULL  , v7 MEDIUMBLOB NOT  NULL  , v8 DATE NOT  NULL DEFAULT '1607-05-30 00:06:10.403383'   ) ENGINE = INNODB CHARACTER SET=cp1257 COLLATE=cp1257_general_ci;

mysql> ALTER TABLE table22 ENGINE = ARCHIVE;

ERROR 1030 (HY000): Got error -1 - 'Unknown error -1' from storage engine

How to repeat:
CREATE  TABLE table22 ( v0 FLOAT  DEFAULT 2031962.984951307  PRIMARY KEY, v1 LONGBLOB NOT  NULL  , v2 MEDIUMBLOB NOT  NULL  , v3 INT NOT  NULL DEFAULT 185659406 , v4 BOOL NOT  NULL DEFAULT FALSE , v5 DATE  DEFAULT '1510-12-12 13:55:01.953044' , v6 TINYTEXT NOT  NULL  , v7 MEDIUMBLOB NOT  NULL  , v8 DATE NOT  NULL DEFAULT '1607-05-30 00:06:10.403383'   ) ENGINE = INNODB CHARACTER SET=cp1257 COLLATE=cp1257_general_ci;

ALTER TABLE table22 ENGINE = ARCHIVE;
[9 Oct 2023 8:51] MySQL Verification Team 
Hello ying ying,

Thank you for the report and test case.

regards,
Umesh