ERROR 1061 (42000) at line 5: Duplicate key name 'IDX_oauth2_application_uid'

[blade1989]

Description

Trying to import a .sql file created with gitea dump.

Gitea Version

1.21.10

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

Excerpt of the terminal:

mariadb -h {server} -u {DB_USER} -p{PASSWORD} {DB_NAME} </path/to/dump/gitea-db.sql
ERROR 1061 (42000) at line 5: Duplicate key name 'IDX_oauth2_application_uid'

Line 5:

CREATE INDEX `IDX_oauth2_application_uid` ON `oauth2_application` (`uid`);

When I grep for the key name, I can only find one;

grep 'IDX_oauth2_application_uid' /data/apps/gitea/dump/gitea-db.sql -n
5:CREATE INDEX `IDX_oauth2_application_uid` ON `oauth2_application` (`uid`);

Git Version

No response

Operating System

Ubuntu 22.04.3 LTS

How are you running Gitea?

Docker rootless

Database

MySQL/MariaDB

[lunny]

Maybe you old database have already this index? You should create a new blank database and import it but not override an old database.

[blade1989]

It's a blank database. It was a migration test. new database server.

[yp05327]

I can not image this would happen in a newly created database, and the command was executed at the first time. 🤔

[yp05327]

Can you provide the version of your MariaDB?

And if it is possible, can you provide the details of how to reproduce this issue.
For example, how did you deploy your MariaDB and the version of it.
And line1~line5 in gitea-db.sql, of cause, you can mask your private information if you need.