[MDEV-32207] altering table returns errno: 168 "Unknown (generic) error from engine" Created: 2023-09-20  Updated: 2024-01-08  Resolved: 2024-01-08

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.6.4
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Neama Ageb Assignee: Marko Mäkelä
Resolution: Incomplete Votes: 0
Labels: innodb
Environment:

"Ubuntu 20.04.3 LTS


 Description   

Trying to alter table structure shows this error message ... although table is empty and just created before doing this alter statement.
ALTER TABLE SUITE_OVERHEIDSLOKET_RELEASE.portal_policy_information MODIFY id INT AUTO_INCREMENT;
ERROR 1025 (HY000): Error on rename of './SUITE_OVERHEIDSLOKET_RELEASE/portal_policy_information' to './SUITE_OVERHEIDSLOKET_RELEASE/#sql-backup-d1586-2f8c9' (errno: 168 "Unknown (generic) error from engine")

 Comments   
Comment by Marko Mäkelä [ 2023-11-21 ]

Sorry, I only noticed this bug now.

Can you please provide a self-contained test case, starting with CREATE TABLE and ALTER TABLE? You can obfuscate the table and column names, and possibly omit some columns and indexes, but the SQL statements must be able to reproduce the bug.

It is also possible that this issue has meanwhile been fixed in MariaDB. Currently the latest release in the 10.6 series is 10.6.16.

Generated at Thu Feb 08 10:29:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.