tidb-lightning导入报错

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:3.0.12
  • 【问题描述】:tidb集群间备份恢复,集群版本相同,工具为4.0.2版本dumpling导出为sql文本,在新集群中tidb-lightnint导入恢复。
    tidb-backend方式,共3个schema,前两个schema导入成功无报错,1个schema里共3张表全部导入失败。

部分报错信息:
[ERROR] [restore.go.1605] [“write to data engine failed”] [table=zipkin.zipkin_spans] [engineNumber=0] [fileIndex=1] [path=/data/dfs01/dbbackup/tidb_bak/20201021/zipkin.zipkin_spans.1.sql.0] [task=deliver] [error=“Error 1054: Unknown column ‘0x’ in ’ '”]
[ERROR] [restore.go.1001] [“encode kv data and write failed”] [table=zipkin.zipkin_spans] [engineNumber=0] [takeTime=230.847429ms] [error=“Error 1054: Unknown column ‘0x’ in ’ '”]
[ERROR] [restore.go.848] [“restore engine failed”] [table=zipkin.zipkin_spans] [engineNumber=0] [takeTime=235.069659ms] [error=“Error 1054: Unknown column ‘0x’ in ’ '”]
[ERROR] [restore.go.870] [“import whole table failed”] [table=zipkin.zipkin_spans] [takeTime=238.008873ms] [error=“Error 1054: Unknown column ‘0x’ in ’ '”]
[ERROR] [restore.go.610] [“restore table failed”] [table=zipkin.zipkin_spans] [takeTime=248.882466ms] [error=“restore table zipkin.zipkin_spans failed: Error 1054: Unknown column ‘0x’ in ’ '”]

zipkin.zipkin_spans表结构:
create table zipkin_spans(
trace_id_high bigint not null default ‘0’,
trace_id bigint not null,
id bigint not null,
name varchar(255) not null,
remote_service_name varchar(255) default null,
parent_id bigint default null,
debug bit(1) default null,
start_ts bigint default null,
duration bigint default null,
primary key (trace_id_high,trace_id,id),
key idx1(trace_id_high,trace_id),
key idx2(name),
key idx3(remote_service_name),
key idx4(start_ts)
);

从备份文件 zipkin.zipkin_spans.1.sql 中,找出insert语句,测试在MYSQL SHELL中执行insert 一条数据,执行成功未报错。

麻烦帮忙看下是什么问题?

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

该问题是已知 bug,已经在最新版本的 lightning 修复了,lightning 版本是向后兼容的,麻烦使用最近版本的试一下,应该没问题的

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。