[MDEV-31880] Rename Error Created: 2023-08-08  Updated: 2023-09-10  Resolved: 2023-09-10

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

Type: Bug Priority: Critical
Reporter: Debbie Kurth Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Linux


 Description   

A standard plugin, for a wordpress enviornment is giving this following error:

An unexpected database error occurred: "Error on rename of './virtualhorsespor_vhsbackstage_wp493/wpo8_elm_daily_stats' to './virtualhorsespor_vhsbackstage_wp493/#sql-backup-50c-1487c' (errno: 168 "Unknown (generic) error from engine")"

I need to know how to fix this.

 Comments   
Comment by Marko Mäkelä [ 2023-08-09 ]

I believe that the error originates from a DDL statement, such as ALTER TABLE or OPTIMIZE TABLE.

In include/my_base.h I can see the following:

#define HA_ERR_GENERIC           168     /* Generic error */

Which storage engine was the table created in?

SHOW CREATE TABLE virtualhorsespor_vhsbackstage_wp493.wpo8_elm_daily_stats;

Are there any related messages in the server error log? In a Systemd based environment, journalctl -u mariadb should display the log.

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