Bug #112661 Got 'Unknown error -1' when create index on table
Submitted: 9 Oct 2023 6:29 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 6:29] Ying FU 
Description:
mysql> CREATE TABLE table1 ( v0 TEXT NOT NULL , v1 TINYTEXT , v2 VARCHAR(255) DEFAULT 'v21' , v3 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , v4 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , v5 FLOAT NOT NULL DEFAULT 1450916748.971549286 , v6 LONGTEXT NOT NULL , v7 DATE NOT NULL DEFAULT '1983-03-19 15:11:54.823209' ) ENGINE = ARCHIVE CHARACTER SET=latin1 COLLATE=latin1_bin;
Query OK, 0 rows affected, 1 warning (0.05 sec)

mysql> CREATE INDEX index0 ON test.table1 (v4) USING BTREE;

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

How to repeat:
CREATE DATABASE TEST;
USE TEST;
CREATE TABLE table1 ( v0 TEXT NOT NULL , v1 TINYTEXT , v2 VARCHAR(255) DEFAULT 'v21' , v3 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , v4 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , v5 FLOAT NOT NULL DEFAULT 1450916748.971549286 , v6 LONGTEXT NOT NULL , v7 DATE NOT NULL DEFAULT '1983-03-19 15:11:54.823209' ) ENGINE = ARCHIVE CHARACTER SET=latin1 COLLATE=latin1_bin;
CREATE INDEX index0 ON test.table1 (v4) USING BTREE;
[9 Oct 2023 8:51] MySQL Verification Team 
Hello ying ying,

Thank you for the report and test case.

regards,
Umesh