表分区过多时，无法正确解析表结构，返回报错no tables matched

[zhengshibing]

Environment
python version:
ibd2sql version:
OS version:

Describe the bug
A clear and concise description of what the bug is.

To Reproduce

表结构信息如下
CREATE TABLE CustomerRequestLogExt (
id bigint NOT NULL AUTO_INCREMENT,
c1 bigint DEFAULT NULL,
c2 int DEFAULT NULL,
c3 int DEFAULT NULL,
c4 int DEFAULT NULL,
c5 int DEFAULT NULL,
k varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c6 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c7 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c8 int DEFAULT NULL,
c9 int DEFAULT NULL,
c10 bit(1) DEFAULT NULL,
c11 int DEFAULT NULL,
c12 int DEFAULT NULL,
c13 mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
c14 datetime NOT NULL,
c15 datetime DEFAULT CURRENT_c15 ON UPDATE CURRENT_c15,
PRIMARY KEY (id,c14) USING BTREE,
KEY idx_c1 (c1) USING BTREE,
KEY idx_c2 (c2) USING BTREE,
KEY idx_c2_c6 (c2,c6) USING BTREE,
KEY idx_k (k) USING BTREE,
KEY idx_c5 (c5) USING BTREE,
KEY idx_c12 (c12) USING BTREE,
KEY idx_c7 (c7) USING BTREE,
KEY idx_c14 (c14) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4462259456 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
PARTITION BY RANGE COLUMNS(c14)
(PARTITION p20250301 VALUES LESS THAN ('20250302') ENGINE = InnoDB,
PARTITION p20250302 VALUES LESS THAN ('20250303') ENGINE = InnoDB,
PARTITION p20250303 VALUES LESS THAN ('20250304') ENGINE = InnoDB,
PARTITION p20250304 VALUES LESS THAN ('20250305') ENGINE = InnoDB,
PARTITION p20250305 VALUES LESS THAN ('20250306') ENGINE = InnoDB,
PARTITION p20250306 VALUES LESS THAN ('20250307') ENGINE = InnoDB,
PARTITION p20250307 VALUES LESS THAN ('20250308') ENGINE = InnoDB,
PARTITION p20250308 VALUES LESS THAN ('20250309') ENGINE = InnoDB,
PARTITION p20250309 VALUES LESS THAN ('20250310') ENGINE = InnoDB,
PARTITION p20250310 VALUES LESS THAN ('20250311') ENGINE = InnoDB,
PARTITION p20250311 VALUES LESS THAN ('20250312') ENGINE = InnoDB,
PARTITION p20250312 VALUES LESS THAN ('20250313') ENGINE = InnoDB,
PARTITION p20250313 VALUES LESS THAN ('20250314') ENGINE = InnoDB,
PARTITION p20250314 VALUES LESS THAN ('20250315') ENGINE = InnoDB,
PARTITION p20250315 VALUES LESS THAN ('20250316') ENGINE = InnoDB,
PARTITION p20250316 VALUES LESS THAN ('20250317') ENGINE = InnoDB,
PARTITION p20250317 VALUES LESS THAN ('20250318') ENGINE = InnoDB,
PARTITION p20250318 VALUES LESS THAN ('20250319') ENGINE = InnoDB,
PARTITION p20250319 VALUES LESS THAN ('20250320') ENGINE = InnoDB,
PARTITION p20250320 VALUES LESS THAN ('20250321') ENGINE = InnoDB,
PARTITION p20250321 VALUES LESS THAN ('20250322') ENGINE = InnoDB,
PARTITION p20250322 VALUES LESS THAN ('20250323') ENGINE = InnoDB,
PARTITION p20250323 VALUES LESS THAN ('20250324') ENGINE = InnoDB,
PARTITION p20250324 VALUES LESS THAN ('20250325') ENGINE = InnoDB,
PARTITION p20250325 VALUES LESS THAN ('20250326') ENGINE = InnoDB,
PARTITION p20250326 VALUES LESS THAN ('20250327') ENGINE = InnoDB,
PARTITION p20250327 VALUES LESS THAN ('20250328') ENGINE = InnoDB,
PARTITION p20250328 VALUES LESS THAN ('20250329') ENGINE = InnoDB,
PARTITION p20250329 VALUES LESS THAN ('20250330') ENGINE = InnoDB,
PARTITION p20250330 VALUES LESS THAN ('20250331') ENGINE = InnoDB,
PARTITION p20250331 VALUES LESS THAN ('20250401') ENGINE = InnoDB,
PARTITION p20250401 VALUES LESS THAN ('20250402') ENGINE = InnoDB,
PARTITION p20250402 VALUES LESS THAN ('20250403') ENGINE = InnoDB,
PARTITION p20250403 VALUES LESS THAN ('20250404') ENGINE = InnoDB,
PARTITION p20250404 VALUES LESS THAN ('20250405') ENGINE = InnoDB,
PARTITION p20250405 VALUES LESS THAN ('20250406') ENGINE = InnoDB,
PARTITION p20250406 VALUES LESS THAN ('20250407') ENGINE = InnoDB,
PARTITION p20250407 VALUES LESS THAN ('20250408') ENGINE = InnoDB,
PARTITION p20250408 VALUES LESS THAN ('20250409') ENGINE = InnoDB,
PARTITION p20250409 VALUES LESS THAN ('20250410') ENGINE = InnoDB,
PARTITION p20250410 VALUES LESS THAN ('20250411') ENGINE = InnoDB,
PARTITION p20250411 VALUES LESS THAN ('20250412') ENGINE = InnoDB,
PARTITION p20250412 VALUES LESS THAN ('20250413') ENGINE = InnoDB,
PARTITION p20250413 VALUES LESS THAN ('20250414') ENGINE = InnoDB,
PARTITION p20250414 VALUES LESS THAN ('20250415') ENGINE = InnoDB,
PARTITION p20250415 VALUES LESS THAN ('20250416') ENGINE = InnoDB,
PARTITION p20250416 VALUES LESS THAN ('20250417') ENGINE = InnoDB,
PARTITION p20250417 VALUES LESS THAN ('20250418') ENGINE = InnoDB,
PARTITION p20250418 VALUES LESS THAN ('20250419') ENGINE = InnoDB,
PARTITION p20250419 VALUES LESS THAN ('20250420') ENGINE = InnoDB,
PARTITION p20250420 VALUES LESS THAN ('20250421') ENGINE = InnoDB,
PARTITION p20250421 VALUES LESS THAN ('20250422') ENGINE = InnoDB,
PARTITION p20250422 VALUES LESS THAN ('20250423') ENGINE = InnoDB,
PARTITION p20250423 VALUES LESS THAN ('20250424') ENGINE = InnoDB,
PARTITION p20250424 VALUES LESS THAN ('20250425') ENGINE = InnoDB,
PARTITION p20250425 VALUES LESS THAN ('20250426') ENGINE = InnoDB,
PARTITION p20250426 VALUES LESS THAN ('20250427') ENGINE = InnoDB,
PARTITION p20250427 VALUES LESS THAN ('20250428') ENGINE = InnoDB,
PARTITION p20250428 VALUES LESS THAN ('20250429') ENGINE = InnoDB,
PARTITION p20250429 VALUES LESS THAN ('20250430') ENGINE = InnoDB,
PARTITION p20250430 VALUES LESS THAN ('20250501') ENGINE = InnoDB,
PARTITION p20250501 VALUES LESS THAN ('20250502') ENGINE = InnoDB,
PARTITION p20250502 VALUES LESS THAN ('20250503') ENGINE = InnoDB,
PARTITION p20250503 VALUES LESS THAN ('20250504') ENGINE = InnoDB);

数据库版本为mysql 8.0.19

执行解析ddl命令输出如下

[root@mgr22 ibd2sql-ibd2sql-v2.x]# python3 main.py /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd --ddl --log
[2025-11-05 22:18:22] [INFO] SET: {}
[2025-11-05 22:18:22] [INFO] INIT FILENAME
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd logical_size 16384
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd physical_size 16384
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd compressed False
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd ENCRYPTION False
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd SDI True
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd SHARED False
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd POST_ANTELOPE 1
[2025-11-05 22:18:22] [INFO] /datamysql/data3313/data/mydb/log_tab#p#p20250301.ibd mysql version: 80019
[2025-11-05 22:18:22] [ERROR] unknown error when read sdi 3
no tables matched
[root@mgr22 ibd2sql-ibd2sql-v2.x]#

Other

[zhengshibing]

使用的ibd2sql版本为ibd2sql-ibd2sql-v2.x，下载地址为https://codeload.github.com/ddcw/ibd2sql/zip/refs/heads/ibd2sql-v2.x

[ddcw]

1. 提供的DDL在8.0.19中有个问题(未识别到分区类型),已修复, 可重新下载验证.

2. 你的报错"unknown error when read sdi 3" 是因为解析sdi的时候返回报错了, 但该表和上面的DDL不是一张表, 无法复现, 请提供该报错表的DDL

[zhengshibing]

调整了正常的表结构
CREATE TABLE CustomerRequestLogExt (
id bigint NOT NULL AUTO_INCREMENT,
c1 bigint DEFAULT NULL,
c2 int DEFAULT NULL,
c3 int DEFAULT NULL,
c4 int DEFAULT NULL,
c5 int DEFAULT NULL,
k varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c6 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c7 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
c8 int DEFAULT NULL,
c9 int DEFAULT NULL,
c10 bit(1) DEFAULT NULL,
c11 int DEFAULT NULL,
c12 int DEFAULT NULL,
c13 mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
c14 datetime NOT NULL,
c15 datetime DEFAULT CURRENT_timestamp ON UPDATE CURRENT_timestamp,
PRIMARY KEY (id,c14) USING BTREE,
KEY idx_c1 (c1) USING BTREE,
KEY idx_c2 (c2) USING BTREE,
KEY idx_c2_c6 (c2,c6) USING BTREE,
KEY idx_k (k) USING BTREE,
KEY idx_c5 (c5) USING BTREE,
KEY idx_c12 (c12) USING BTREE,
KEY idx_c7 (c7) USING BTREE,
KEY idx_c14 (c14) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4462259456 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
PARTITION BY RANGE COLUMNS(c14)
(PARTITION p20250301 VALUES LESS THAN ('20250302') ENGINE = InnoDB,
PARTITION p20250302 VALUES LESS THAN ('20250303') ENGINE = InnoDB,
PARTITION p20250303 VALUES LESS THAN ('20250304') ENGINE = InnoDB,
PARTITION p20250304 VALUES LESS THAN ('20250305') ENGINE = InnoDB,
PARTITION p20250305 VALUES LESS THAN ('20250306') ENGINE = InnoDB,
PARTITION p20250306 VALUES LESS THAN ('20250307') ENGINE = InnoDB,
PARTITION p20250307 VALUES LESS THAN ('20250308') ENGINE = InnoDB,
PARTITION p20250308 VALUES LESS THAN ('20250309') ENGINE = InnoDB,
PARTITION p20250309 VALUES LESS THAN ('20250310') ENGINE = InnoDB,
PARTITION p20250310 VALUES LESS THAN ('20250311') ENGINE = InnoDB,
PARTITION p20250311 VALUES LESS THAN ('20250312') ENGINE = InnoDB,
PARTITION p20250312 VALUES LESS THAN ('20250313') ENGINE = InnoDB,
PARTITION p20250313 VALUES LESS THAN ('20250314') ENGINE = InnoDB,
PARTITION p20250314 VALUES LESS THAN ('20250315') ENGINE = InnoDB,
PARTITION p20250315 VALUES LESS THAN ('20250316') ENGINE = InnoDB,
PARTITION p20250316 VALUES LESS THAN ('20250317') ENGINE = InnoDB,
PARTITION p20250317 VALUES LESS THAN ('20250318') ENGINE = InnoDB,
PARTITION p20250318 VALUES LESS THAN ('20250319') ENGINE = InnoDB,
PARTITION p20250319 VALUES LESS THAN ('20250320') ENGINE = InnoDB,
PARTITION p20250320 VALUES LESS THAN ('20250321') ENGINE = InnoDB,
PARTITION p20250321 VALUES LESS THAN ('20250322') ENGINE = InnoDB,
PARTITION p20250322 VALUES LESS THAN ('20250323') ENGINE = InnoDB,
PARTITION p20250323 VALUES LESS THAN ('20250324') ENGINE = InnoDB,
PARTITION p20250324 VALUES LESS THAN ('20250325') ENGINE = InnoDB,
PARTITION p20250325 VALUES LESS THAN ('20250326') ENGINE = InnoDB,
PARTITION p20250326 VALUES LESS THAN ('20250327') ENGINE = InnoDB,
PARTITION p20250327 VALUES LESS THAN ('20250328') ENGINE = InnoDB,
PARTITION p20250328 VALUES LESS THAN ('20250329') ENGINE = InnoDB,
PARTITION p20250329 VALUES LESS THAN ('20250330') ENGINE = InnoDB,
PARTITION p20250330 VALUES LESS THAN ('20250331') ENGINE = InnoDB,
PARTITION p20250331 VALUES LESS THAN ('20250401') ENGINE = InnoDB,
PARTITION p20250401 VALUES LESS THAN ('20250402') ENGINE = InnoDB,
PARTITION p20250402 VALUES LESS THAN ('20250403') ENGINE = InnoDB,
PARTITION p20250403 VALUES LESS THAN ('20250404') ENGINE = InnoDB,
PARTITION p20250404 VALUES LESS THAN ('20250405') ENGINE = InnoDB,
PARTITION p20250405 VALUES LESS THAN ('20250406') ENGINE = InnoDB,
PARTITION p20250406 VALUES LESS THAN ('20250407') ENGINE = InnoDB,
PARTITION p20250407 VALUES LESS THAN ('20250408') ENGINE = InnoDB,
PARTITION p20250408 VALUES LESS THAN ('20250409') ENGINE = InnoDB,
PARTITION p20250409 VALUES LESS THAN ('20250410') ENGINE = InnoDB,
PARTITION p20250410 VALUES LESS THAN ('20250411') ENGINE = InnoDB,
PARTITION p20250411 VALUES LESS THAN ('20250412') ENGINE = InnoDB,
PARTITION p20250412 VALUES LESS THAN ('20250413') ENGINE = InnoDB,
PARTITION p20250413 VALUES LESS THAN ('20250414') ENGINE = InnoDB,
PARTITION p20250414 VALUES LESS THAN ('20250415') ENGINE = InnoDB,
PARTITION p20250415 VALUES LESS THAN ('20250416') ENGINE = InnoDB,
PARTITION p20250416 VALUES LESS THAN ('20250417') ENGINE = InnoDB,
PARTITION p20250417 VALUES LESS THAN ('20250418') ENGINE = InnoDB,
PARTITION p20250418 VALUES LESS THAN ('20250419') ENGINE = InnoDB,
PARTITION p20250419 VALUES LESS THAN ('20250420') ENGINE = InnoDB,
PARTITION p20250420 VALUES LESS THAN ('20250421') ENGINE = InnoDB,
PARTITION p20250421 VALUES LESS THAN ('20250422') ENGINE = InnoDB,
PARTITION p20250422 VALUES LESS THAN ('20250423') ENGINE = InnoDB,
PARTITION p20250423 VALUES LESS THAN ('20250424') ENGINE = InnoDB,
PARTITION p20250424 VALUES LESS THAN ('20250425') ENGINE = InnoDB,
PARTITION p20250425 VALUES LESS THAN ('20250426') ENGINE = InnoDB,
PARTITION p20250426 VALUES LESS THAN ('20250427') ENGINE = InnoDB,
PARTITION p20250427 VALUES LESS THAN ('20250428') ENGINE = InnoDB,
PARTITION p20250428 VALUES LESS THAN ('20250429') ENGINE = InnoDB,
PARTITION p20250429 VALUES LESS THAN ('20250430') ENGINE = InnoDB,
PARTITION p20250430 VALUES LESS THAN ('20250501') ENGINE = InnoDB,
PARTITION p20250501 VALUES LESS THAN ('20250502') ENGINE = InnoDB,
PARTITION p20250502 VALUES LESS THAN ('20250503') ENGINE = InnoDB,
PARTITION p20250503 VALUES LESS THAN ('20250504') ENGINE = InnoDB);

解析依然报错
[root@mgr22 ibd2sql-ibd2sql-v2.x]# python3 main.py /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd --ddl
Traceback (most recent call last):
File "main.py", line 498, in
ddl = table.get_ddl(False,False,disable_foreign_key)
File "/opt/ibd2sql-ibd2sql-v2.x/ibd2sql/innodb_page/table.py", line 677, in get_ddl
partition = self._get_ddl_partition()
File "/opt/ibd2sql-ibd2sql-v2.x/ibd2sql/innodb_page/table.py", line 581, in _get_ddl_partition
partition_type = PARTITION_TYPE[dd['dd_object']['partition_type']]
KeyError: 9
[root@mgr22 ibd2sql-ibd2sql-v2.x]#

[zhengshibing]

1. 提供的DDL在8.0.19中有个问题(未识别到分区类型),已修复, 可重新下载验证.

2. 你的报错"unknown error when read sdi 3" 是因为解析sdi的时候返回报错了, 但该表和上面的DDL不是一张表, 无法复现, 请提供该报错表的DDL

您说的重新下载，是否可以提供一个下载链接呢，我上面的链接软件是昨天晚上刚下载的内容，下载地址为https://codeload.github.com/ddcw/ibd2sql/zip/refs/heads/ibd2sql-v2.x

[ddcw]

下载链接: https://github.com/ddcw/ibd2sql/archive/refs/heads/ibd2sql-v2.x.zip

wget https://github.com/ddcw/ibd2sql/archive/refs/heads/ibd2sql-v2.x.zip
unzip ibd2sql-v2.x.zip
cd ibd2sql-ibd2sql-v2.x/

[ddcw]

该问题是今早刚修复的, 所以要重新下载.

[zhengshibing]

新建后面提供的表，使用新的版本后，能够正常从该表的ibd文件中，解析出ddl信息来。但是解析备份的ibd分区文件，依然会报错
[root@mgr22 ibd2sql-ibd2sql-v2.x]# python3 main.py /datamysql/mgr_CustomerRequestLogExt_ibd/CustomerRequestLogExt#p#p20250301.ibd --ddl
Traceback (most recent call last):
File "main.py", line 346, in
_file_list = FORMAT_IBD_FILE(filename_list,parser.SDI_FILE,parser.KEYRING_FILE,log)
File "/opt/ibd2sql-ibd2sql-v2.x/ibd2sql/ibd2sql.py", line 241, in FORMAT_IBD_FILE
log.info(filename,'ADD TABLE',sdidata['dd_object']['schema_ref'],sdidata['dd_object']['name'])
KeyError: 'schema_ref'
[root@mgr22 ibd2sql-ibd2sql-v2.x]#

当我将ibd文件以import partition tablespace的方式加载到新分区表后，再次尝试解析ibd文件中的ddl信息，也会失败
discard和import 命令如下，import是成功的。
mysql> alter table db1106.CustomerRequestLogExt discard partition p20250301 tablespace;
Query OK, 0 rows affected (0.06 sec)

mysql> alter table db1106.CustomerRequestLogExt import partition p20250301 tablespace;
Query OK, 0 rows affected, 1 warning (9.56 sec)

解析import后重新使用ibd2sql解析则提示异常
[root@mgr22 ibd2sql-ibd2sql-v2.x]# python3 main.py /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd --ddl
no tables matched

[ddcw]

1. 第一个报错是未在同目录下获取到该分区表的第一个分区表元数据信息.判断逻辑如下: 取分区表#前面的部分做正则匹配, 若有sdi信息=2,则表示该分区的元数据信息为该表的元数据信息.

解决办法: 如果该分区表的元数据信息不在同目录下, 可以使用`--sdi-table xxxx.ibd `指定 元数据信息

2. 第二个是报错是未匹配到需要解析的表. 处理方法同上

[zhengshibing]

我的数据库版本为8.0.19，元数据信息是包含在ibd文件中的，而且我使用ibd2sdi能够正常解析出表结构信息

[ddcw]

8.0的元数据信息是包含在ibd里面的, 但分区表只有第一个分区有完整的元数据信息, 你可以尝试使用--sdi-table指定第一个分区试下

[zhengshibing]

通过下面的命令，可以看到我的0301ibd文件是第一个分区，把它放到--sdi-table下面依然解析失败
[root@mgr22 ibd2sql-ibd2sql-v2.x]#
[root@mgr22 ibd2sql-ibd2sql-v2.x]# ll /datamysql/data3313/data/db1106/| head
total 2245040
-rw-r--r-- 1 mysql mysql 2285895680 Nov 6 14:22 CustomerRequestLogExt#p#p20250301.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250302.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250308.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250309.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250311.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250312.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250313.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250315.ibd
-rw-r----- 1 mysql mysql 245760 Nov 6 14:16 CustomerRequestLogExt#p#p20250318.ibd
[root@mgr22 ibd2sql-ibd2sql-v2.x]# python3 main.py --sdi-table=/datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd --ddl --log
[2025-11-10 10:46:55] [INFO] SET: {}
[2025-11-10 10:46:55] [INFO] INIT FILENAME
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd maybe ibd
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd logical_size 16384
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd physical_size 16384
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd compressed False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd ENCRYPTION False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd SDI True
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd SHARED False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd POST_ANTELOPE 1
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd logical_size 16384
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd physical_size 16384
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd compressed False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd ENCRYPTION False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd SDI True
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd SHARED False
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd POST_ANTELOPE 1
[2025-11-10 10:46:55] [INFO] /datamysql/data3313/data/db1106/CustomerRequestLogExt#p#p20250301.ibd mysql version: 80019
[2025-11-10 10:46:55] [ERROR] unknown error when read sdi 3
no tables matched
You have new mail in /var/spool/mail/root
[root@mgr22 ibd2sql-ibd2sql-v2.x]#

[ddcw]

ls 是无法区分是否是第一个分区的, 可以使用ibd2sdi xxx.ibd | grep PRIMARY验证. 报错是解析出来的sdi信息有3个.(1:非第一个分区的分区表, 2:普通表和第一个分区, 大于等于3: 共享表空间 ).

可否提供复现方法, 或者将该问题文件发我邮箱呢: yangguisen1996@gmail.com