【 TiDB 使用环境】生产环境
【 TiDB 版本】6.1.2
【复现路径】做过哪些操作出现的问题,a集群是5.3.1升级到6.1.2的版本,br工具也做了升级,另外我们新建了一套集群b
【遇到的问题:问题现象及影响】经过操作发现,我们历史5.3.1的br备份,在b集群6.1.2可以还原成功,但是数据查询无结果。把现有的集群a数据做br备份,在b集群还原失败。现在寻求一个可靠的数据同步组件方案,把a集群数据同步b集群后,业务迁移到b集群。
【资源配置】
【附件:截图/日志/监控】两套集群都是6.1.2版本的br,可以换别的版本进行操作吗?具体问题如何排查?
(base) [root@tidb0003 cluster]# ./br backup table \
–db spider --table aba_quarterly \
–pd “172.16.16.13:2379” \
-s “local:///home/br-backup/table/quarterly/20221221” \
–log-file backupfull.log
Detail BR log in backupfull.log
Table Backup <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
Checksum <------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
[2022/12/22 04:45:15.860 +08:00] [INFO] [collector.go:69] [“Table Backup success summary”] [total-ranges=801] [ranges-succeed=801] [ranges-failed=0] [backup-checksum=1m10.426031647s] [backup-fast-checksum=578.474µs] [backup-total-ranges=8] [backup-total-regions=557] [total-take=6m40.065563235s] [Size=15248693413] [BackupTS=438214358710616065] [total-kv=269627120] [total-kv-size=41.97GB] [average-speed=104.9MB/s] [backup-data-size(after-compressed)=15.25GB]
(base) [root@tidb0003 cluster]#
– 还原失败
[tidb@tiup-new tools]$ ./br restore table \
–db spider --table aba_quarterly \
–pd “172.16.16.67:2379” \
-s “local:///home/br-backup/table/quarterly/20221221” \
–log-file backupfull.log \
–check-requirements=false
Detail BR log in backupfull.log
[2022/12/22 04:49:49.665 +08:00] [INFO] [collector.go:69] [“Table Restore failed summary”] [total-ranges=0] [ranges-succeed=0] [ranges-failed=0]
Error: the config ‘new_collations_enabled_on_first_bootstrap’ not match, upstream:False, downstream: True: [BR:Common:ErrUnknown]internal error
[tidb@tiup-new tools]$