InnoDB: Cannot replay rename … because the target file exists

--source include/have_innodb.inc

--source include/not_embedded.inc

CREATE TABLE t1 (a INT) ENGINE=InnoDB;

CREATE TABLE t2 (a INT) ENGINE=InnoDB;

SET GLOBAL innodb_log_checkpoint_now=ON;

RENAME TABLE t2 TO t3, t1 TO t2;

--source include/kill_mysqld.inc

--move_file $MARIADB_DATADIR/test/t2.ibd $MARIADB_DATADIR/test/t1.ibd

--move_file $MARIADB_DATADIR/test/t3.ibd $MARIADB_DATADIR/test/t2.ibd

--source include/start_mysqld.inc

SELECT * FROM t2, t3;

DROP TABLE t2, t3;

2026-10-15  8:03:28 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57717

2026-10-15  8:03:28 0 [Note] InnoDB: Ignoring data file './test/t3.ibd' with space ID 6. Another data file called ./test/t2.ibd exists with the same space ID.

2026-10-15  8:03:28 0 [Note] InnoDB: Ignoring data file './test/t2.ibd' with space ID 5. Another data file called ./test/t1.ibd exists with the same space ID.

2026-10-15  8:03:28 0 [Note] InnoDB: End of log at LSN=61004

2026-10-15  8:03:28 0 [ERROR] InnoDB: Cannot replay rename of tablespace 5 from './test/t1.ibd' to './test/t2.ibd' because the target file exists

2026-10-15  8:03:28 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.

--source include/have_innodb.inc

--source include/have_debug_sync.inc

CREATE TABLE t1 (a INT) ENGINE=InnoDB;

CREATE TABLE t2 (a INT) ENGINE=InnoDB;

SET GLOBAL innodb_log_checkpoint_now=ON;

--let $target= $MYSQLTEST_VARDIR/tmp/backup

--connect backup,localhost,root

SET DEBUG_SYNC='innodb_backup_start SIGNAL started WAIT_FOR renamed';

--send_eval BACKUP SERVER TO '$target'

--connection default

SET DEBUG_SYNC='now WAIT_FOR started';

RENAME TABLE t2 TO t3, t1 TO t2;

SET DEBUG_SYNC='now SIGNAL renamed';

--connection backup

--reap

--connection default

--exec cat $MYSQLTEST_VARDIR/my.cnf >> $target/backup.cnf

--let $restart_parameters= --defaults-file=$target/backup.cnf --datadir=$target

--source include/restart_mysqld.inc

SELECT * FROM t2, t3;

--let $restart_parameters=

--source include/restart_mysqld.inc

DROP TABLE t2, t3;

--rmdir $target