BackupSchedule的日志备份失败

【 TiDB 版本】6.5.2
【复现路径】做过哪些操作出现的问题
使用BackupSchedule创建备份计划任务
【遇到的问题:问题现象及影响】
log备份失败
【资源配置】
【附件:截图/日志/监控】
I0526 09:46:01.958315 9 backup.go:262] [2023/05/26 09:46:01.958 +00:00] [ERROR] [stream.go:513] [“failed to stream”] [command=“log start”] [error=“failed to commit the change for task log-backup-schedule-s3: etcdserver: too many operations in txn request”] [errorVerbose=“etcdserver: too many operations in txn request\nfailed to commit the change for task log-backup-schedule-s3\ngithub.com/pingcap/tidb/br/pkg/streamhelper.(*MetaDataClient).PutTask\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/streamhelper/client.go:152\ngithub.com/pingcap/tidb/br/pkg/task.RunStreamStart\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/task/stream.go:628\ngithub.com/pingcap/tidb/br/pkg/task.RunStreamCommand\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/task/stream.go:512\nmain.streamCommand\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/stream.go:231\nmain.newStreamStartCommand.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/stream.go:70\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:916\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:1044\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:968\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/main.go:57\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1594”] [stack=“github.com/pingcap/tidb/br/pkg/task.RunStreamCommand\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/task/stream.go:513\nmain.streamCommand\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/stream.go:231\nmain.newStreamStartCommand.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/stream.go:70\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:916\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:1044\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:968\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/br/main.go:57\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250”]

这个数据库大约8000个表,看日志提示observer table,是否可能是一次监控的表太多,然后把所有操作都放一个事务然后造成了bug

1 个赞

表或者分区多了容易出问题,以前用Oracle数据泵处理上万分区表也各种不稳定

请问下,这个问题如何解决的。
我这边也发现这个问题,备份的表300张左右,就出现这个失败日志。

关注中,看看有没有好的解决方案。

升级版本就解决了

升级版本吧