Bifrost icon indicating copy to clipboard operation
Bifrost copied to clipboard

mysql 同步到clickhouse 发生错误, Json type 90 is not handled

Open xianghuawe opened this issue 3 years ago • 1 comments

Version:

  • Bifrost Version: [ Bifrost v1.8.3-release amd64]

Describe the bug

MySQL 同步到clickhouse 当修改json类型字段数据时触发以下报错,从而导致binlog无法继续解析,数据同步从而中断

错误信息如下

lastField schemaName:teamones_saas tableName:project_template columnName:module_field_config Unknown FieldType 245 err:Json type 90 is not handled
2022/05/23 17:34:58 event row parser err: Json type 90 is not handled
2022/05/23 17:34:58 row event err: Json type 90 is not handled
parseEvent err:Json type 90 is not handled
2022/05/23 17:34:58 mysql23 monitor: parseEvent err:Json type 90 is not handled
2022/05/23 17:34:58 mysql23 monitor: running

字段示例数据见附件 (太大了,所以丢附件里了)

json_data.txt

xianghuawe avatar May 23 '22 09:05 xianghuawe

尝试用一下新版本,试试,修复了分区表解析有问题等bug

jc3wish avatar Sep 15 '22 13:09 jc3wish