I am having an issue restoring my backup, which complains about some duplicates. What could have gone wrong and what could I do?
Multiple files found for the same tablespace ID:
2024-03-21T14:45:47.828141-00:00 0 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967278 = [‘backup_xtrabackup_20240317/undo_002’, ‘undo_002’]
2024-03-21T14:45:47.828167-00:00 0 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967279 = [‘backup_xtrabackup_20240317/undo_001’, ‘undo_001’]
2024-03-21T14:45:47.828180-00:00 0 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967294 = [‘backup_xtrabackup_20240317/mysql.ibd’, ‘mysql.ibd’]
Any idea? The error occurs when trying to prepare the backup before restore.
No error when backing up.
Looks like you have a backup folder inside a backup directory. ie you have backup_xtrabackup_202… directory inside the backup directory.
Possibly xtrbackup is given this location. So you saved a backup inside a backup.
Please move this directory ‘backup_xtrabackup_202…’ outside the backup directory and retry prepare.
That was exactly the issue, thank you!