dumping导出报错

[yilong (yi888long)]

1. 那先确认下，是dumpling的时候业务侧执行了这个sql导致的dumpling失败？
2. 还是每次dumpling都会执行这个sql，导致失败？

[IvanCai]

我现在单独针对这个表导出也是出现了这个错误

[root@TIDB-Monitor bin]# ./dumpling \
>   -u root \
>   -P 4000 \
>   -p xxx \
>   -h 172.18.52.177 \
>   --filetype sql \
>   --threads 10 \
>   -o /tmp/fresh_v4_2021_0226 \
>   -F 256MiB \
>   --snapshot "2021-02-26 12:16:00" \
>   -T fresh_v4.partner_message
Release version: v4.0.10
Git commit hash: 5e6981efa173ff525abb31c6e62a50ecd6da6a09
Git branch:      heads/refs/tags/v4.0.10
Build timestamp: 2021-01-14 12:39:07Z
Go version:      go version go1.13 linux/amd64

[2021/02/26 12:17:26.494 +08:00] [INFO] [config.go:596] ["detect server type"] [type=TiDB]
[2021/02/26 12:17:26.494 +08:00] [INFO] [config.go:615] ["detect server version"] [version=4.0.0]
[2021/02/26 12:17:26.500 +08:00] [INFO] [client.go:166] ["[pd] create pd client with endpoints"] [pd-address="[172.18.52.177:2379,172.18.52.185:2379]"]
[2021/02/26 12:17:26.501 +08:00] [INFO] [base_client.go:252] ["[pd] switch leader"] [new-leader=http://172.18.52.177:2379] [old-leader=]
[2021/02/26 12:17:26.501 +08:00] [INFO] [base_client.go:102] ["[pd] init cluster id"] [cluster-id=6894132624390410896]
[2021/02/26 12:17:32.406 +08:00] [INFO] [collector.go:188] ["backup Failed summary : total backup ranges: 1, total success: 0, total failed: 1"] [unitName="dump table data"] [error="Error 1105: number of enum overflow enum boundary"] [errorVerbose="Error 1105: number of enum overflow enum boundary\
github.com/pingcap/errors.AddStack\
\tgithub.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/errors.go:174\
github.com/pingcap/errors.Trace\
\tgithub.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/juju_adaptor.go:15\
github.com/pingcap/dumpling/v4/export.WriteInsert\
\tgithub.com/pingcap/dumpling@/v4/export/writer_util.go:259\
github.com/pingcap/dumpling/v4/export.FileFormat.WriteInsert\
\tgithub.com/pingcap/dumpling@/v4/export/writer_util.go:593\
github.com/pingcap/dumpling/v4/export.(*Writer).tryToWriteTableData\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:204\
github.com/pingcap/dumpling/v4/export.(*Writer).WriteTableData.func1\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:190\
github.com/pingcap/br/pkg/utils.WithRetry\
\tgithub.com/pingcap/br@v0.0.0-20201119111016-600102357a27/pkg/utils/retry.go:34\
github.com/pingcap/dumpling/v4/export.(*Writer).WriteTableData\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:161\
github.com/pingcap/dumpling/v4/export.(*Writer).handleTask\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:104\
github.com/pingcap/dumpling/v4/export.(*Writer).run\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:86\
github.com/pingcap/dumpling/v4/export.(*Dumper).startWriters.func4\
\tgithub.com/pingcap/dumpling@/v4/export/dump.go:253\
golang.org/x/sync/errgroup.(*Group).Go.func1\
\tgolang.org/x/sync@v0.0.0-20200625203802-6e8e738ad208/errgroup/errgroup.go:57\
runtime.goexit\
\truntime/asm_amd64.s:1357"]
[2021/02/26 12:17:32.406 +08:00] [ERROR] [main.go:78] ["dump failed error stack info"] [error="Error 1105: number of enum overflow enum boundary"] [errorVerbose="Error 1105: number of enum overflow enum boundary\
github.com/pingcap/errors.AddStack\
\tgithub.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/errors.go:174\
github.com/pingcap/errors.Trace\
\tgithub.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/juju_adaptor.go:15\
github.com/pingcap/dumpling/v4/export.WriteInsert\
\tgithub.com/pingcap/dumpling@/v4/export/writer_util.go:259\
github.com/pingcap/dumpling/v4/export.FileFormat.WriteInsert\
\tgithub.com/pingcap/dumpling@/v4/export/writer_util.go:593\
github.com/pingcap/dumpling/v4/export.(*Writer).tryToWriteTableData\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:204\
github.com/pingcap/dumpling/v4/export.(*Writer).WriteTableData.func1\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:190\
github.com/pingcap/br/pkg/utils.WithRetry\
\tgithub.com/pingcap/br@v0.0.0-20201119111016-600102357a27/pkg/utils/retry.go:34\
github.com/pingcap/dumpling/v4/export.(*Writer).WriteTableData\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:161\
github.com/pingcap/dumpling/v4/export.(*Writer).handleTask\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:104\
github.com/pingcap/dumpling/v4/export.(*Writer).run\
\tgithub.com/pingcap/dumpling@/v4/export/writer.go:86\
github.com/pingcap/dumpling/v4/export.(*Dumper).startWriters.func4\
\tgithub.com/pingcap/dumpling@/v4/export/dump.go:253\
golang.org/x/sync/errgroup.(*Group).Go.func1\
\tgolang.org/x/sync@v0.0.0-20200625203802-6e8e738ad208/errgroup/errgroup.go:57\
runtime.goexit\
\truntime/asm_amd64.s:1357"] [stack="main.main\
\tgithub.com/pingcap/dumpling@/cmd/dumpling/main.go:78\
runtime.main\
\truntime/proc.go:203"]

dump failed: Error 1105: number of enum overflow enum boundary

[yilong (yi888long)]

好的，我们先分析下，有进展回尽快答复，多谢。

[solotzg-PingCAP]

tiflash 在该版本处理 enum 列变更的 ddl 存在 bug。如果要紧急恢复，可以先为该表 set tiflash replica 为 0 从而 让 tidb 查询 tikv。

[yilong (yi888long)]

请问具体是哪个bug？ 有 issue 链接吗？ 会在哪个版本修复？

[solotzg-PingCAP]

4.0.10 之后版本已经修复