Mysql Multiple files found for the same tablespace ID

MySQL & MariaDB
,
1

Hello, I am receiving the error I have shared below in my Percona Mysql system running on a single server and I cannot open the service. What path should I follow?

OS : Ubuntu 22.04
Mysql-Percona : 8.0.30

2024-03-11T13:24:09.683475Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-22) starting as process 974044
2024-03-11T13:24:09.698196Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-11T13:24:12.976924Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2024-03-11T13:24:12.977066Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 5389 = [‘db_v2/users.ibd’, ‘db_v2_stg/user.ibd’]
2024-03-11T13:24:12.977116Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 5388 = [‘db_v2/Contact.ibd’, ‘db_v2_stg/Contact.ibd’]
2024-03-11T13:24:12.977638Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2024-03-11T13:24:12.977740Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-03-11T13:24:12.978088Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-11T13:24:12.978218Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-11T13:24:12.979200Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-22) Percona Server (GPL), Release ‘22’, Revision ‘7e301439b65’.

2

@Alican_Cakir, it would appear someone tried to duplicate tables from “prod” to “stg” by simply copying the innodb datafile. You can’t do this. You must use CREATE TABLE db_v2_stg.user LIKE db_v2.user and then INSERT INTO db_v2_stg.user SELECT * FROM db_v2.user.
I suggest you go to the disk and rm db_v2_stg/user.ibd and similar for the other table.