无法使用 BR 进行恢复，日志上也没 error 日志，如何查询？

🪐 TiDB 技术问题 备份&数据迁移
1

【 TiDB 使用环境】V4.0.10 恢复到 V4.0.14

【备份和数据迁移策略逻辑】 单表恢复

【问题】 当前遇到的问题 没有任何提示，一闪而过

【业务影响】

【TiDB 版本】

[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:37] ["Welcome to Backup & Restore (BR)"]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:38] [BR] [release-version=v4.0.10]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:39] [BR] [git-hash=e8a906b00e02950978550913f88217348bcc4e7e]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:40] [BR] [git-branch=heads/refs/tags/v4.0.10]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:41] [BR] [go-version=go1.13]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:42] [BR] [utc-build-time="2021-01-14 12:39:33"]
[2021/08/16 12:28:42.402 +08:00] [INFO] [version.go:43] [BR] [race-enabled=false]
[2021/08/16 12:28:42.402 +08:00] [INFO] [common.go:450] [arguments] [__command="br restore table"] [db=miner] [pd="[10.0.0.36:2379]"] [storage=local:///backups/backup/transaction] [table=transaction]
[2021/08/16 12:28:42.403 +08:00] [INFO] [client.go:166] ["[pd] create pd client with endpoints"] [pd-address="[10.0.0.36:2379]"]
[2021/08/16 12:28:42.406 +08:00] [INFO] [base_client.go:236] ["[pd] update member urls"] [old-urls="[http://10.0.0.36:2379]"] [new-urls="[http://10.0.0.28:2379,http://10.0.0.36:2379,http://10.0.0.42:2379]"]
[2021/08/16 12:28:42.406 +08:00] [INFO] [base_client.go:252] ["[pd] switch leader"] [new-leader=http://10.0.0.42:2379] [old-leader=]
[2021/08/16 12:28:42.406 +08:00] [INFO] [base_client.go:102] ["[pd] init cluster id"] [cluster-id=6919051586155779965]
[2021/08/16 12:28:42.410 +08:00] [INFO] [client.go:166] ["[pd] create pd client with endpoints"] [pd-address="[10.0.0.36:2379]"]
[2021/08/16 12:28:42.428 +08:00] [INFO] [base_client.go:236] ["[pd] update member urls"] [old-urls="[http://10.0.0.36:2379]"] [new-urls="[http://10.0.0.28:2379,http://10.0.0.36:2379,http://10.0.0.42:2379]"]
[2021/08/16 12:28:42.428 +08:00] [INFO] [base_client.go:252] ["[pd] switch leader"] [new-leader=http://10.0.0.42:2379] [old-leader=]
[2021/08/16 12:28:42.428 +08:00] [INFO] [base_client.go:102] ["[pd] init cluster id"] [cluster-id=6919051586155779965]
[2021/08/16 12:28:42.430 +08:00] [WARN] [version.go:161] ["BR version is outdated, please consider use version 4.0.14 of BR"]
[2021/08/16 12:28:42.430 +08:00] [INFO] [conn.go:127] ["new mgr"] [pdAddrs=10.0.0.36:2379]
[2021/08/16 12:28:42.430 +08:00] [INFO] [tidb.go:72] ["new domain"] [store=tikv-6919051586155779965] ["ddl lease"=1s] ["stats lease"=-1ns]
[2021/08/16 12:28:42.433 +08:00] [INFO] [ddl.go:322] ["[ddl] start DDL"] [ID=df4350e3-cd7d-4b4c-b035-b49e71214aed] [runWorker=true]
[2021/08/16 12:28:42.433 +08:00] [INFO] [manager.go:188] ["start campaign owner"] [ownerInfo="[ddl] /tidb/ddl/fg/owner"]
[2021/08/16 12:28:42.440 +08:00] [INFO] [ddl.go:311] ["[ddl] start delRangeManager OK"] ["is a emulator"=false]
[2021/08/16 12:28:42.440 +08:00] [INFO] [ddl_worker.go:131] ["[ddl] start DDL worker"] [worker="worker 1, tp general"]
[2021/08/16 12:28:42.440 +08:00] [INFO] [ddl_worker.go:131] ["[ddl] start DDL worker"] [worker="worker 2, tp add index"]
[2021/08/16 12:28:42.487 +08:00] [INFO] [domain.go:148] ["full load InfoSchema success"] [usedSchemaVersion=0] [neededSchemaVersion=752] ["start time"=23.691502ms]
[2021/08/16 12:28:42.495 +08:00] [INFO] [domain.go:379] ["full load and reset schema validator"]
[2021/08/16 12:28:42.506 +08:00] [INFO] [client.go:185] ["load backupmeta"] [databases=1] [jobs=0]
[2021/08/16 12:28:42.510 +08:00] [WARN] [restore.go:397] ["set max-index-length to max(3072*4) to skip check index length in DDL"]
[2021/08/16 12:28:42.510 +08:00] [INFO] [restore.go:186] ["nothing to restore, all databases and tables are filtered out"]
[2021/08/16 12:28:42.510 +08:00] [INFO] [client.go:165] ["Restore client closed"]
[2021/08/16 12:28:42.511 +08:00] [INFO] [manager.go:276] ["failed to campaign"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df4350e3-cd7d-4b4c-b035-b49e71214aed"] [error="context canceled"]
[2021/08/16 12:28:42.512 +08:00] [INFO] [manager.go:257] ["break campaign loop, context is done"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df4350e3-cd7d-4b4c-b035-b49e71214aed"]
[2021/08/16 12:28:42.513 +08:00] [INFO] [manager.go:301] ["revoke session"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df4350e3-cd7d-4b4c-b035-b49e71214aed"] []
[2021/08/16 12:28:42.520 +08:00] [INFO] [ddl_worker.go:125] ["[ddl] DDL worker closed"] [worker="worker 1, tp general"] ["take time"=21.4µs]
[2021/08/16 12:28:42.520 +08:00] [INFO] [ddl_worker.go:125] ["[ddl] DDL worker closed"] [worker="worker 2, tp add index"] ["take time"=3.005µs]
[2021/08/16 12:28:42.520 +08:00] [INFO] [delete_range.go:130] ["[ddl] closing delRange"]
[2021/08/16 12:28:42.520 +08:00] [INFO] [session_pool.go:85] ["[ddl] closing sessionPool"]
[2021/08/16 12:28:42.520 +08:00] [INFO] [ddl.go:394] ["[ddl] DDL closed"] [ID=df4350e3-cd7d-4b4c-b035-b49e71214aed] ["take time"=10.007827ms]
[2021/08/16 12:28:42.520 +08:00] [INFO] [ddl.go:303] ["[ddl] stop DDL"] [ID=df4350e3-cd7d-4b4c-b035-b49e71214aed]
[2021/08/16 12:28:42.523 +08:00] [INFO] [domain.go:452] ["infoSyncerKeeper exited."]
[2021/08/16 12:28:42.523 +08:00] [INFO] [domain.go:622] ["domain closed"] ["take time"=13.638ms]
[2021/08/16 12:28:42.524 +08:00] [INFO] [collector.go:61] ["Table restore Success summary: total restore files: 0, total success: 0, total failed: 0, total take(Table restore time): 0s, total take(real time): 121.386423ms"] [Size=34844295627]
3

看起来是索引长度超过了限制，把max-index-length设置成3072*4试试

5

已解决了，前置条件，BR 要版本一致。文档也没说清楚，一直以为是 BR 要跟备份的数据库版本一致呢，原来要跟导入的版本一致。

并且，恢复的目标数据库中表的名字必须跟备份的数据库表一样才可以，这个又是为什么？难道我不能导入到一个新的表中？

这个希望在文档中说明一下。

6

执行备份的时候会生成一个源库的元数据信息，恢复时要验证这个信息，所以目标数据库的库名和表名都要和之前的一致。
文档的问题您可以在这里反馈一下：https://asktug.com/c/advice-feedback/document

7

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