Bug #100750 Unknown error is given when trying to alter engine for a table

• Submitted: 5 Sep 2020 9:21
• Modified: 5 Sep 2020 10:33
• Reporter: Yushan ZHANG
• Status: Verified
• Category: MySQL Server: Storage Engines
• Severity: S3 (Non-critical)
• Version: 8.0.21, 5.7.31
• OS: Any
• CPU Architecture: Any
• Tags: ALTER TABLE, engine, innodb

[5 Sep 2020 9:21] Yushan ZHANG

Description:
'Unknown error' is returned when changing the engine from InnoDB to ARCHIVE:

mysql> CREATE TABLE `t1` (`pk` int NOT NULL, PRIMARY KEY (`pk`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.05 sec)

mysql> ALTER TABLE t1 ENGINE = ARCHIVE;
ERROR 1030 (HY000): Got error -1 - 'Unknown error -1' from storage engine

How to repeat:
drop table if exists `t1`;

CREATE TABLE `t1` (
  `pk` int NOT NULL,
  PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE t1 ENGINE = ARCHIVE;

[5 Sep 2020 10:33] MySQL Verification Team

Hello Yushan ZHANG,

Thank you for the report and feedback.

regards,
Umesh

[18 Oct 2020 21:31] Gaurav Kumar Garg

PR is open for further Review: https://github.com/mysql/mysql-server/pull/310

[26 Oct 2020 14:15] OCA Admin

Contribution submitted via Github - Bug#100750: Unknown error is given when trying to alter engine to arc… 
(*) Contribution by Gaurav Kumar Garg (Github gaurav36, mysql-server/pull/310#issuecomment-711727647): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_505565377.txt (text/plain), 1.27 KiB.

[29 Oct 2020 10:45] Georgi Kodinov

Added a comment to the github request, please fix.