【 使用环境 】生产环境
【 OB or 其他组件 】 OMS
【 使用版本 】4.2.2_CE
【问题描述】Ob->Mysql迁移,部分表报错
如下:
错误码:
CONNECTOR-SOOO00000001
等级:
ERROR
错误信息:
java.lang.RuntimeException: Field{name=first_send, index=27, schema=BIT}:BYTES(null) not supported
错误原因:
全量迁移过程中有部分表对象出现异常
解决方案:
请在控制台下方查看报错对象获取具体失败原因,如未解决,请发起工单寻求支持。
表结构:
CREATE TABLE fulfillment_delivery_order_item_info
(
_hd_shard
varchar(128) NOT NULL DEFAULT ‘’ COMMENT ‘shard info’,
id
bigint(20) unsigned NOT NULL,
delivery_order_id
bigint(20) unsigned DEFAULT NULL,
shard_id
int(11) DEFAULT NULL,
business_line
bigint(20) unsigned DEFAULT NULL,
oid
bigint(20) DEFAULT NULL,
delivery_type
int(11) DEFAULT NULL,
delivery_status
int(11) DEFAULT NULL,
express_no
varchar(500) DEFAULT NULL,
express_code
int(11) DEFAULT NULL,
return_address_id
bigint(20) DEFAULT NULL,
shipper_name
varchar(500) DEFAULT NULL,
shipper_phone
varchar(500) DEFAULT NULL,
ext
varchar(2000) DEFAULT NULL,
note
varchar(500) DEFAULT NULL,
create_time
bigint(20) DEFAULT NULL,
update_time
bigint(20) DEFAULT NULL,
deleted
tinyint(1) DEFAULT NULL,
seller_id
bigint(20) DEFAULT NULL,
operator_id
varchar(200) DEFAULT NULL,
delivery_channel
int(11) DEFAULT NULL,
logistics_id
bigint(20) DEFAULT NULL,
main_order_id
bigint(20) DEFAULT NULL,
shipped_num
int(11) DEFAULT NULL,
delivery_version
int(11) DEFAULT NULL,
outer_id
varchar(255) DEFAULT NULL,
delivery_id
bigint(20) DEFAULT NULL,
first_send
bit(1) DEFAULT NULL,
append_delivery
bit(1) DEFAULT NULL,
sign_time
bigint(20) DEFAULT NULL,
PRIMARY KEY (id
, _hd_shard
),
KEY idx_oid
(oid
) BLOCK_SIZE 16384 LOCAL,
KEY idx_main_order_id
(main_order_id
) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by key(id)
(partition p0,
partition p1,
partition p2,
partition p3,
partition p4,
partition p5,
partition p6,
partition p7,
partition p8,
partition p9,
partition p10)
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):