Error 1061 (42000): Duplicate key name issues when using MySQL Aria storage engine

[miqraeng]

Description

When restoring the gitea database form a backup I got a lot of messages of type
Error 1061 (42000): Duplicate key name ....

I got those same messages when doing an upgrade, and when restoring the original database.
The command gitea doctor check-db-version gave these messages.

After some research I discovered that my MariaDB database engine was set to Aria
Recreating the database with InnoDB restored proper functionality

Gitea Version

1.19.3 to 1.22.0

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

Git Version

2.30.2

Operating System

Debian GNU/Linux 11 (bullseye) AMD64

How are you running Gitea?

downloaded releases

Database

MySQL/MariaDB

[lunny]

I think Gitea now just supports innodb Engine. https://docs.gitea.com/help/faq#upgrade-errors-with-mysql

[miqraeng]

True, but it would be nice if the gitea doctor feature could identify the issue and possibly remedy it.