【 使用环境 】生产环境
【 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收集诊断信息,详情参见链接(右键跳转查看):
