While backing up a MariaDB 10.6.21 server where an innodb table is being renamed, the tablespace list generation leads to an InnoDB ERROR which prevents the backup from happening regularly:

+ /usr/bin/mariabackup --backup --stream=xbstream --parallel=1 --incremental-history-name=lsnstore --history=lsnstore

[00] 2025-03-27 21:01:17 Connecting to MariaDB server host: localhost, user: root, password: set, port: 3306, socket: /var/run/mysqld/mysqld.sock
[00] 2025-03-27 21:01:17 Using server version 10.6.21-MariaDB-deb11
/usr/bin/mariabackup based on MariaDB server 10.6.21-MariaDB debian-linux-gnu (x86_64)
[00] 2025-03-27 21:01:17 incremental backup from 0 is enabled.
[00] 2025-03-27 21:01:17 uses posix_fadvise().
[00] 2025-03-27 21:01:17 cd to /data/mysql/
[00] 2025-03-27 21:01:17 open files limit requested 0, set to 1000000
[00] 2025-03-27 21:01:17 mariabackup: using the following InnoDB configuration:
[00] 2025-03-27 21:01:17 innodb_data_home_dir =
[00] 2025-03-27 21:01:17 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2025-03-27 21:01:17 innodb_log_group_home_dir = ./
[00] 2025-03-27 21:01:17 InnoDB: Using liburing
2025-03-27 21:01:17 0 [Note] InnoDB: Number of pools: 1
[00] 2025-03-27 21:01:17 Found and using lsn: 174137625890414 for name lsnstore
[00] 2025-03-27 21:01:17 mariabackup: Generating a list of tablespaces
2025-03-27 21:02:24 0 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace: ./lists/pds_normalization_term_67462_temp.ibd uses space ID: 68230548. Cannot open filepath: ./lists/pds_normalization_term_67462.ibd which uses the same space ID.
[00] FATAL ERROR: 2025-03-27 21:02:24 Failed to validate first page of the file lists/pds_normalization_term_67462, error 39

This operation likely happens because we use an atomic swap/rename table e.g.

RENAME TABLE pds_normalization_term_67462 TO pds_normalization_term_67462_old, pds_normalization_term_67462_temp TO pds_normalization_term_67462