cds icon indicating copy to clipboard operation
cds copied to clipboard

ERROR-全量同步过程中出现错误

Open oslet opened this issue 5 years ago • 2 comments

环境: centos 7 | clickhouse ClickHouse server version 20.12.5 | cds 最新版(建议添加一个版本号, commitid: 28c51c5)

现像: 在配置好全量同步,执行同步过程出现如下错误:

{"@timestamp":"2021-01-04T17:03:44.268+08","level":"error","content":"mysqltypeconv.go:59 sql: Scan error on column index 4, name \"Default\":
 converting NULL to string is unsupported"}

可能原因: 建表语句指定了字段类型, 导致NULL转换失败

问题:

* 建表语句是否可支持 Nullable
* 全库同步需要选中所有表 ?

oslet avatar Jan 04 '21 09:01 oslet

这个问题解决了么?

googlefan avatar May 14 '22 06:05 googlefan

已提交合并请求,可以解决该问题,本地测试通过 https://github.com/zeromicro/cds/pull/93/commits/4a237dc474065ead6a7a6fc8572d418a7136b5ce

googlefan avatar May 17 '22 03:05 googlefan