Bifrost icon indicating copy to clipboard operation
Bifrost copied to clipboard

Mysql解析字段报错 Unknown FieldType 3 err:EOF

Open yunduan16 opened this issue 2 years ago • 2 comments

Version:

  • Bifrost Version: [v2.0.3-beta]
  • Os Version: [CentOS Linux release 7.7.1908]

Describe the bug

A clear and concise description of what the bug is. 报错 FieldType EOF error To Reproduce

Steps to reproduce the behavior:

  1. 开始服务然后监听一些数据库实例
  2. 然后就会出现这种报错 3.lastField schemaName:hhzhome_member tableName:hhz_device_token columnName:ban_push Unknown FieldType 1 err:EOF lastField schemaName:xxxxxx tableName: hhz_push columnName:device_token Unknown FieldType 254 err:EOF

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem. hhz_device_token表结构如下 image 表数据如下 image hhz_push表结构如下 image 表数据如下 image

Additional context

这是一个bug吗,还是一个正常的错误提示,不懂为何0或者空字符串也会有这种报错?

yunduan16 avatar Nov 02 '22 07:11 yunduan16

mysql什么版本?

表同步配置是怎么配置的,配置了几个表,

有没有重试过修改数据源,位点从最新位点开始?

权限是否满足?

https://wiki.xbifrost.com/data_source/privileges/

jc3wish avatar Nov 02 '22 15:11 jc3wish

我在mysql8.0排查是因为CHARACTER_OCTET_LENGTH 返回的是int64类型导致char的长度未获取到,导致buf读取数据错乱触发了buf.len() < length导致报错。你可以参考改下 https://github.com/brokercap/Bifrost/pull/284

longfeiRen avatar May 24 '24 09:05 longfeiRen