解析后部分显示乱码

[cxheny]

解析完成后表结构显示正常，部分数据显示异常，

[ddcw]

从截图来看更像数据是错位了, 表结构应该不正常, 可否提供下复现方法呢 或者 相关的DDL和数据库版本, 有数据文件的话就更好了

[cxheny]

感谢回复，
ibd2sql版本：ibd2sql VERSION: v1.5 for MySQL 5.7 or 8.0
数据库版本：MySQL 8.0.29
因为涉及到一些敏感数据，不太方便提供ibd文件，我使用debug回复的时候出现了报错，
[2025-11-24 14:18:36] [DEBUG] DEBUG MODE ON
[2025-11-24 14:18:36] [DEBUG] INIT ibd2sql
[2025-11-24 14:18:36] [DEBUG] FORCE False
[2025-11-24 14:18:36] [DEBUG] SET False
[2025-11-24 14:18:36] [DEBUG] MULTIVALUE False
[2025-11-24 14:18:36] [DEBUG] AUTO_DEBUG True
[2025-11-24 14:18:36] [DEBUG] FILTER:

    0 < TRX < 281474976710656    
    0 < ROLLPTR < 72057594037927936

[2025-11-24 14:18:36] [DEBUG] OPEN IBD FILE: ../account_1.ibd
[2025-11-24 14:18:36] [DEBUG] ANALYZE FIRST PAGE: FIL_PAGE_TYPE_FSP_HDR
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 0
[2025-11-24 14:18:36] [DEBUG] ANALYZE FIRST PAGE FINISH
[2025-11-24 14:18:36] [DEBUG] SDI PAGE NO: 3
[2025-11-24 14:18:36] [DEBUG] ANALYZE SDI PAGE
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 3
[2025-11-24 14:18:36] [DEBUG] ANALYZE SDI PAGE FINISH
[2025-11-24 14:18:36] [DEBUG] SET ibd2sql.table = sdi.table (SDI的使命已结束 >_<)
[2025-11-24 14:18:36] [DEBUG] META INFO
[2025-11-24 14:18:36] [DEBUG] COLNO: 1
{'name': 'szaccountid', 'is_autoincrement': False, 'type': 'varchar(20)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'PK', 'is_nullable': False, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 60, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 0, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 2
{'name': 'szuserid', 'is_autoincrement': False, 'type': 'varchar(20)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'SK', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 60, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 3, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 3
{'name': 'uctype', 'is_autoincrement': False, 'type': 'varchar(1)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'SK', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 3, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 4, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 4
{'name': 'sipoints', 'is_autoincrement': False, 'type': 'int', 'isvar': False, 'size': 4, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'latin1_swedish_ci', 'character_set': 'latin1', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 11, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 8, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 5, 'ct': 'int'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 5
{'name': 'simoney', 'is_autoincrement': False, 'type': 'int', 'isvar': False, 'size': 4, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'latin1_swedish_ci', 'character_set': 'latin1', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 11, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 8, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 6, 'ct': 'int'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 6
{'name': 'szenc', 'is_autoincrement': False, 'type': 'varchar(32)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 96, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 7, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 7
{'name': 'szcreatetime', 'is_autoincrement': False, 'type': 'varchar(20)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'SK', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 60, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 8, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 8
{'name': 'szupdatetime', 'is_autoincrement': False, 'type': 'varchar(20)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 60, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 9, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 9
{'name': 'szpassword', 'is_autoincrement': False, 'type': 'varchar(32)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': False, 'default': '', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 96, 'extra': None, 'instant': False, 'instant_value': '', 'instant_null': True, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 0, 'physical_pos': 10, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] COLNO: 10
{'name': 'ucstate', 'is_autoincrement': False, 'type': 'varchar(1)', 'isvar': True, 'size': 0, 'isbig': False, 'elements_dict': {}, 'varsize': 0, 'have_default': True, 'default': 'y', 'comment': '', 'collation': 'utf8_general_ci', 'character_set': 'utf8', 'index_type': 'NONE', 'is_nullable': True, 'is_zerofill': False, 'is_unsigned': False, 'is_auto_increment': False, 'is_virtual': False, 'hidden': 1, 'char_length': 3, 'extra': None, 'instant': True, 'instant_value': 'y', 'instant_null': False, 'generation_expression': '', 'default_option': '', 'collation_id': 33, 'srs_id': 0, 'version_dropped': 0, 'version_added': 1, 'physical_pos': 11, 'ct': 'varbinary'}
[2025-11-24 14:18:36] [DEBUG] IDXNO: 10
{'name': None, 'comment': '', 'idx_type': 'PRIMARY ', 'element_col': [(1, 0, 2)], 'options': {'id': '176', 'root': '4', 'space_id': '6', 'table_id': '1067', 'trx_id': '1469'}, 'is_visible': True}
[2025-11-24 14:18:36] [DEBUG] IDXNO: 10
{'name': 'szuserid', 'comment': '', 'idx_type': '', 'element_col': [(2, 0, 2)], 'options': {'id': '177', 'root': '5', 'space_id': '6', 'table_id': '1067', 'trx_id': '1469'}, 'is_visible': True}
[2025-11-24 14:18:36] [DEBUG] IDXNO: 10
{'name': 'uctype', 'comment': '', 'idx_type': '', 'element_col': [(3, 0, 2)], 'options': {'id': '178', 'root': '6', 'space_id': '6', 'table_id': '1067', 'trx_id': '1469'}, 'is_visible': True}
[2025-11-24 14:18:36] [DEBUG] IDXNO: 10
{'name': 'szcreatetime', 'comment': '', 'idx_type': '', 'element_col': [(7, 0, 2)], 'options': {'id': '179', 'root': '7', 'space_id': '6', 'table_id': '1067', 'trx_id': '1469'}, 'is_visible': True}
[2025-11-24 14:18:36] [DEBUG] INIT SQL PREFIX
[2025-11-24 14:18:36] [DEBUG] DDL:
CREATE TABLE IF NOT EXISTS hqgzh.accounts(
szaccountid varchar(20) NOT NULL,
szuserid varchar(20) NULL,
uctype varchar(1) NULL,
sipoints int NULL,
simoney int NULL,
szenc varchar(32) NULL,
szcreatetime varchar(20) NULL,
szupdatetime varchar(20) NULL,
szpassword varchar(32) NULL,
ucstate varchar(1) NULL DEFAULT 'y',
PRIMARY KEY (szaccountid ),
KEY szuserid (szuserid ),
KEY uctype (uctype ),
KEY szcreatetime (szcreatetime )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
[2025-11-24 14:18:36] [DEBUG] ANALYZE PAGE INODE (PAGE_ID=2) (for get index)
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 2
[2025-11-24 14:18:36] [DEBUG] FIRST INDEX (Non-leaf and leaf page) : (4, 8) (-1 is None)
[2025-11-24 14:18:36] [DEBUG] INIT FIRST PAGE TO FIRST_NO_LEAF_PAGE (4)
[2025-11-24 14:18:36] [DEBUG] COUNT: 1 FIND LEAF PAGE, CURRENT PAGE ID: 4
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 4
[2025-11-24 14:18:36] [DEBUG] INIT ROW BASE INFO
[2025-11-24 14:18:36] [DEBUG] NULL BITMASK LENGTH: 1 bytes. (nullable col count:8)
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO START ####################################
[2025-11-24 14:18:36] [DEBUG] name: szaccountid type: varchar(20) size: 0 isvar: True is_nullable: False
[2025-11-24 14:18:36] [DEBUG] name: szuserid type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: uctype type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: sipoints type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: simoney type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szenc type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szcreatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szupdatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szpassword type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: ucstate type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO END ######################################
[2025-11-24 14:18:36] [DEBUG] CLUSTER INDEX: IDXNO: 1 IDX COLUMMN COUNT:1 INDEX ELEMENT:[1]
[2025-11-24 14:18:36] [DEBUG] ROW INIT FINISH FOR < hqgzh.accounts >

[2025-11-24 14:18:36] [DEBUG] CURRENT PAGE ID(find leaf page): 4
[2025-11-24 14:18:36] [DEBUG] FIND LEAF PAGE ----> OFFSET:99 RECORD TYPE:2
[2025-11-24 14:18:36] [DEBUG] FIND LEAF PAGE ----> OFFSET:127 RECORD TYPE:1
[2025-11-24 14:18:36] [DEBUG] 127 ----> 135 data:00OEGLnS bdata:b'00OEGLnS'
[2025-11-24 14:18:36] [DEBUG] COUNT: 2 FIND LEAF PAGE, CURRENT PAGE ID: 8
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 8
[2025-11-24 14:18:36] [DEBUG] INIT ROW BASE INFO
[2025-11-24 14:18:36] [DEBUG] NULL BITMASK LENGTH: 1 bytes. (nullable col count:8)
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO START ####################################
[2025-11-24 14:18:36] [DEBUG] name: szaccountid type: varchar(20) size: 0 isvar: True is_nullable: False
[2025-11-24 14:18:36] [DEBUG] name: szuserid type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: uctype type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: sipoints type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: simoney type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szenc type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szcreatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szupdatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szpassword type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: ucstate type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO END ######################################
[2025-11-24 14:18:36] [DEBUG] CLUSTER INDEX: IDXNO: 1 IDX COLUMMN COUNT:1 INDEX ELEMENT:[1]
[2025-11-24 14:18:36] [DEBUG] ROW INIT FINISH FOR < hqgzh.accounts >

[2025-11-24 14:18:36] [DEBUG] CURRENT PAGE ID(find leaf page): 8
[2025-11-24 14:18:36] [DEBUG] FIND LEAF PAGE ----> OFFSET:99 RECORD TYPE:2
[2025-11-24 14:18:36] [DEBUG] FIND LEAF PAGE ----> OFFSET:133 RECORD TYPE:0
[2025-11-24 14:18:36] [DEBUG] FIND FINISH, PAGE_ID: 8

[2025-11-24 14:18:36] [DEBUG] FIRST LEAF PAGE ID: 8
[2025-11-24 14:18:36] [DEBUG] #############################################################################
[2025-11-24 14:18:36] [DEBUG] INIT ibd2sql FINISH
[2025-11-24 14:18:36] [DEBUG] #############################################################################

CREATE TABLE IF NOT EXISTS hqgzh.accounts(
szaccountid varchar(20) NOT NULL,
szuserid varchar(20) NULL,
uctype varchar(1) NULL,
sipoints int NULL,
simoney int NULL,
szenc varchar(32) NULL,
szcreatetime varchar(20) NULL,
szupdatetime varchar(20) NULL,
szpassword varchar(32) NULL,
ucstate varchar(1) NULL DEFAULT 'y',
PRIMARY KEY (szaccountid ),
KEY szuserid (szuserid ),
KEY uctype (uctype ),
KEY szcreatetime (szcreatetime )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
[2025-11-24 14:18:36] [DEBUG] ibd2sql get_sql BEGIN: 8 0 4294967296 -1
[2025-11-24 14:18:36] [DEBUG] INIT INDEX OBJECT
[2025-11-24 14:18:36] [DEBUG] ibd2sql.read PAGE: 8
[2025-11-24 14:18:36] [DEBUG] INIT ROW BASE INFO
[2025-11-24 14:18:36] [DEBUG] NULL BITMASK LENGTH: 1 bytes. (nullable col count:8)
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO START ####################################
[2025-11-24 14:18:36] [DEBUG] name: szaccountid type: varchar(20) size: 0 isvar: True is_nullable: False
[2025-11-24 14:18:36] [DEBUG] name: szuserid type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: uctype type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: sipoints type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: simoney type: int size: 4 isvar: False is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szenc type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szcreatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szupdatetime type: varchar(20) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: szpassword type: varchar(32) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] name: ucstate type: varchar(1) size: 0 isvar: True is_nullable: True
[2025-11-24 14:18:36] [DEBUG] ######################################## FIELD INFO END ######################################
[2025-11-24 14:18:36] [DEBUG] CLUSTER INDEX: IDXNO: 1 IDX COLUMMN COUNT:1 INDEX ELEMENT:[1]
[2025-11-24 14:18:36] [DEBUG] ROW INIT FINISH FOR < hqgzh.accounts >

[2025-11-24 14:18:36] [DEBUG] SET FILTER (0, 281474976710656) (0, 72057594037927936)
[2025-11-24 14:18:36] [DEBUG] ################## READ ROW START (PAGE NO:8) ########################
[2025-11-24 14:18:36] [DEBUG] READ ALL ROWS FROM PAGE (PAGE_ID=8)
[2025-11-24 14:18:36] [DEBUG] RESET offset TO PAGE_NEW_INFIMUM (99)
[2025-11-24 14:18:36] [DEBUG] NO:1 READ RECORD HEADER (5 bytes) _offset:99 offset:99 START
[2025-11-24 14:18:36] [DEBUG] THIS ROW IS PAGE_NEW_INFIMUM, WILL CONTINUE. (offset:99)
[2025-11-24 14:18:36] [DEBUG] NO:2 READ RECORD HEADER (5 bytes) _offset:133 offset:133 START
[2025-11-24 14:18:36] [DEBUG] READ RECORD HEADER (5 bytes) _offset:128 offset:133 FINISH
[2025-11-24 14:18:36] [DEBUG] PAGE NO : 8
[2025-11-24 14:18:36] [DEBUG] READ ROW NO : 0 CURRENT_OFFSET:133
[2025-11-24 14:18:36] [DEBUG] REC INSTANT : False
[2025-11-24 14:18:36] [DEBUG] REC DELETED : False
[2025-11-24 14:18:36] [DEBUG] REC MIN_REC : False
[2025-11-24 14:18:36] [DEBUG] REC OWNED : 0
[2025-11-24 14:18:36] [DEBUG] REC HEAP_NO : 16
[2025-11-24 14:18:36] [DEBUG] REC TYPE : 0
[2025-11-24 14:18:36] [DEBUG] REC NEXT : 157
[2025-11-24 14:18:36] [DEBUG] INSTANT FLAG : False
[2025-11-24 14:18:36] [DEBUG] ROW VERSION FLAG : False
[2025-11-24 14:18:36] [DEBUG] 20 bytes ON BOTH SIDES OF RECORD, b'\x00\x0b\x00\x00supremum \x13\x13 \x01\x0c\x08\x00', b'\x00\x00\x10\x00\x9d00OEGLnS\x00\x00 \xe1=-\x01'
[2025-11-24 14:18:36] [DEBUG] READ NULL BITMASK
[2025-11-24 14:18:36] [DEBUG] NULLABLE FILED COUNT: 8 NULLABLE FIELD COUNT(FOR INSTANT):1
[2025-11-24 14:18:36] [DEBUG] NULL BITMASK: COUNT:9 ID: 2048 [0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
[2025-11-24 14:18:36] [DEBUG] READ KEY FILED
[2025-11-24 14:18:36] [DEBUG] READ KEY COLNO:1 NAME:szaccountid
[2025-11-24 14:18:36] [DEBUG] BLOB ERROR 'utf-8' codec can't decode byte 0xe1 in position 11: unexpected end of data
[2025-11-24 14:18:36] [DEBUG] 133 ----> 145 data:0x30304f45474c6e53000020e1 bdata:b'00OEGLnS\x00\x00 \xe1'
[2025-11-24 14:18:36] [DEBUG] READ KEY NO:1 NAME:szaccountid FINISH. VALUES: 0x30304f45474c6e53000020e1
[2025-11-24 14:18:36] [DEBUG] READ TRX(6) AND ROLLPTR(7) INFO
[2025-11-24 14:18:36] [DEBUG] TRX: 67263499599875 ROLLPTR: 35498468184241716
[2025-11-24 14:18:36] [DEBUG] ROW VERSION : -1
[2025-11-24 14:18:36] [DEBUG] INSTANT FLAG : False
[2025-11-24 14:18:36] [DEBUG] ROW VERSION FLAG : False
[2025-11-24 14:18:36] [DEBUG] NAME: szuserid VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 158 ----> 159 data:8 bdata:b'8'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: uctype VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] BLOB ERROR 'utf-8' codec can't decode byte 0x80 in position 8: invalid start byte
[2025-11-24 14:18:36] [DEBUG] 159 ----> 191 data:0x383639383238366d800000008000000038656461383136323638363365336536 bdata:b'8698286m\x80\x00\x00\x00\x80\x00\x00\x008eda81626863e3e6'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: sipoints VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 191 ----> 195 data:-1285476255 bdata:b'3a0a'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: simoney VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 195 ----> 199 data:-1201260239 bdata:b'8f91'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: szenc VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 199 ----> 218 data:45c5e8a62024-11-10 bdata:b'45c5e8a62024-11-10 '
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: szcreatetime VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 218 ----> 237 data:15:45:552025-09-28 bdata:b'15:45:552025-09-28 '
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: szupdatetime VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] 237 ----> 269 data:06:15:34dfc749ba8d3eaa9565a604b3 bdata:b'06:15:34dfc749ba8d3eaa9565a604b3'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: szpassword VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] BLOB ERROR 'utf-8' codec can't decode byte 0x88 in position 32: invalid start byte
[2025-11-24 14:18:36] [DEBUG] 269 ----> 378 data:0x353236373736313820131320010c0800000018210f303074714844686100003088bf4202000003591d4d3231333939333637313536396d80004650800007d03737323265396435663761613862356366623637653937323536386332393334323032342d31302d31322031393a bdata:b'52677618 \x13\x13 \x01\x0c\x08\x00\x00\x00\x18!\x0f00tqHDha\x00\x000\x88\xbfB\x02\x00\x00\x03Y\x1dM213993671569m\x80\x00FP\x80\x00\x07\xd07722e9d5f7aa8b5cfb67e972568c29342024-10-12 19:'
[2025-11-24 14:18:36] [DEBUG] ######## DDCW FLAG 8 ########
[2025-11-24 14:18:36] [DEBUG] NAME: ucstate VERSION_ADDED:1 VERSION_DROPED:0 COL_INSTANT:True ROW VERSION:-1
[2025-11-24 14:18:36] [DEBUG] mysql 8.0.12-28 版本的add column (instant) 读默认值 (实际版本:80029)

[ddcw]

1. ibd2sql v1.5版本比较旧了, 你可以试下新版本: v1.12 https://github.com/ddcw/ibd2sql/archive/refs/tags/v1.12.tar.gz 或者 v2.x版本 https://github.com/ddcw/ibd2sql/archive/refs/heads/ibd2sql-v2.x.zip

2. mysql 8.0.29版本存在一些重大BUG, 不推荐使用了. 官方都不提供相关软件包了.

3. 从debug日志来看可能是边界的问题, 而8.0.29也确实是一个边界版本, 之前也确实没有测试过这个版本. 我准备个8.0.29的环境模拟下, 看能否复现.

[ddcw]

已复现, 是ibd2sql v1.5的BUG, 后面是修复了的, 可以使用上面提供的那两个版本.

测试数据

drop table if exists db1.t20251124;
CREATE TABLE IF NOT EXISTS db1.t20251124(
szaccountid varchar(20) NOT NULL,
szuserid varchar(20) NULL,
uctype varchar(1) NULL,
sipoints int NULL,
simoney int NULL,
szenc varchar(32) NULL,
szcreatetime varchar(20) NULL,
szupdatetime varchar(20) NULL,
szpassword varchar(32) NULL,
PRIMARY KEY (szaccountid ),
KEY szuserid (szuserid ),
KEY uctype (uctype ),
KEY szcreatetime (szcreatetime )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
insert into db1.t20251124 values('12345678','123456789012','1',1,1,'12345678901234567890123456789012','1234567890123456789','1234567890123456789','12345678901234567890123456789012');
alter table db1.t20251124 add column ucstate varchar(1) NULL DEFAULT 'y', ALGORITHM=instant;
insert into db1.t20251124 values('12345679','123456789012','1',1,1,'12345678901234567890123456789012','1234567890123456789','1234567890123456789','12345678901234567890123456789012','y');

v1.5版本测试结果

部分乱码

[2025-11-24 16:24:49] [DEBUG] 	20 bytes ON BOTH SIDES OF RECORD, b'\x00\x0b\x00\x00supremum \x13\x13 \x01\x0c\x08\x00', b'\x00\x00\x10\x00\xa012345678\x00\x00\x00\x00\x05\xc5\x81'
[2025-11-24 16:24:49] [DEBUG] READ NULL BITMASK
[2025-11-24 16:24:49] [DEBUG] 	NULLABLE FILED COUNT: 8  NULLABLE FIELD COUNT(FOR INSTANT):1
[2025-11-24 16:24:49] [DEBUG] 	NULL BITMASK: COUNT:9  ID: 2048 [0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
[2025-11-24 16:24:49] [DEBUG] READ KEY FILED
[2025-11-24 16:24:49] [DEBUG] 	READ KEY COLNO:1 NAME:szaccountid
[2025-11-24 16:24:49] [DEBUG] 	133 ----> 145 data:12345678  bdata:b'12345678\x00\x00\x00\x00'
[2025-11-24 16:24:49] [DEBUG] 	READ KEY NO:1 NAME:szaccountid FINISH. VALUES: 12345678
[2025-11-24 16:24:49] [DEBUG] READ TRX(6) AND ROLLPTR(7) INFO
[2025-11-24 16:24:49] [DEBUG] 	TRX: 6345830957056  ROLLPTR: 52074039747949364
[2025-11-24 16:24:49] [DEBUG] ROW VERSION      : -1
[2025-11-24 16:24:49] [DEBUG] INSTANT FLAG     : False
[2025-11-24 16:24:49] [DEBUG] ROW VERSION FLAG : False
[2025-11-24 16:24:49] [DEBUG] 	NAME: szuserid  VERSION_ADDED:0  VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1
[2025-11-24 16:24:49] [DEBUG] 	158 ----> 159 data:5  bdata:b'5'

v1.x版本

使用的v1.12版本解析是正常的. v1.x版本已停止更新了, 建议使用v2.x版本系列.

v2.x版本

v2.x版本解析也是正常的. 后续建议使用v2.x版本系列, 该版本还支持并发和坏块处理的.

[cxheny]

已复现, 是ibd2sql v1.5的BUG, 后面是修复了的, 可以使用上面提供的那两个版本.

测试数据

drop table if exists db1.t20251124;
CREATE TABLE IF NOT EXISTS db1.t20251124(
szaccountid varchar(20) NOT NULL,
szuserid varchar(20) NULL,
uctype varchar(1) NULL,
sipoints int NULL,
simoney int NULL,
szenc varchar(32) NULL,
szcreatetime varchar(20) NULL,
szupdatetime varchar(20) NULL,
szpassword varchar(32) NULL,
PRIMARY KEY (szaccountid ),
KEY szuserid (szuserid ),
KEY uctype (uctype ),
KEY szcreatetime (szcreatetime )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
insert into db1.t20251124 values('12345678','123456789012','1',1,1,'12345678901234567890123456789012','1234567890123456789','1234567890123456789','12345678901234567890123456789012');
alter table db1.t20251124 add column ucstate varchar(1) NULL DEFAULT 'y', ALGORITHM=instant;
insert into db1.t20251124 values('12345679','123456789012','1',1,1,'12345678901234567890123456789012','1234567890123456789','1234567890123456789','12345678901234567890123456789012','y');

v1.5版本测试结果

部分乱码

[2025-11-24 16:24:49] [DEBUG] 20 bytes ON BOTH SIDES OF RECORD, b'\x00\x0b\x00\x00supremum \x13\x13 \x01\x0c\x08\x00', b'\x00\x00\x10\x00\xa012345678\x00\x00\x00\x00\x05\xc5\x81' [2025-11-24 16:24:49] [DEBUG] READ NULL BITMASK [2025-11-24 16:24:49] [DEBUG] NULLABLE FILED COUNT: 8 NULLABLE FIELD COUNT(FOR INSTANT):1 [2025-11-24 16:24:49] [DEBUG] NULL BITMASK: COUNT:9 ID: 2048 [0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] [2025-11-24 16:24:49] [DEBUG] READ KEY FILED [2025-11-24 16:24:49] [DEBUG] READ KEY COLNO:1 NAME:szaccountid [2025-11-24 16:24:49] [DEBUG] 133 ----> 145 data:12345678 bdata:b'12345678\x00\x00\x00\x00' [2025-11-24 16:24:49] [DEBUG] READ KEY NO:1 NAME:szaccountid FINISH. VALUES: 12345678 [2025-11-24 16:24:49] [DEBUG] READ TRX(6) AND ROLLPTR(7) INFO [2025-11-24 16:24:49] [DEBUG] TRX: 6345830957056 ROLLPTR: 52074039747949364 [2025-11-24 16:24:49] [DEBUG] ROW VERSION : -1 [2025-11-24 16:24:49] [DEBUG] INSTANT FLAG : False [2025-11-24 16:24:49] [DEBUG] ROW VERSION FLAG : False [2025-11-24 16:24:49] [DEBUG] NAME: szuserid VERSION_ADDED:0 VERSION_DROPED:0 COL_INSTANT:False ROW VERSION:-1 [2025-11-24 16:24:49] [DEBUG] 158 ----> 159 data:5 bdata:b'5' # v1.x版本 使用的v1.12版本解析是正常的. v1.x版本已停止更新了, 建议使用v2.x版本系列. # v2.x版本 v2.x版本解析也是正常的. 后续建议使用v2.x版本系列, 该版本还支持并发和坏块处理的.

好的，非常感谢~