-
Notifications
You must be signed in to change notification settings - Fork 100
Can't restore system tables separately without restoring user tables #1197
Description
Please answer these questions before submitting your issue. Thanks!
- What did you do?
If possible, provide a recipe for reproducing the error.
a. Run "br backup full" to create full backup, including system tables and user tables.
b. Run br restore full --filter "mysql*.*" to restore system tables only, (do not restore user tables)
-
What did you expect to see?
System tables mysql.* should be restored correctly. -
What did you see instead?
br failed to restore system tables. "Nothing to restore" seen in log.
- What version of BR and TiDB/TiKV/PD are you using?
br 5.1.0 dev build.
[root@centos76_vm dev]# ./br -V
Release Version: v5.0.0-master-dirty
Git Commit Hash: b9c4ea6
Git Branch: backupmetav2
Go Version: go1.16.5
UTC Build Time: 2021-06-09 12:33:55
Race Enabled: false
- Operation logs
- Please upload
br.logfor BR if possible - Please upload
tidb-lightning.logfor TiDB-Lightning if possible - Please upload
tikv-importer.logfrom TiKV-Importer if possible - Other interesting logs
- Please upload
[root@centos76_vm dev]# ./br restore full --pd "172.16.6.183:2379" --filter "mysql*.*" --storage "local:///minio/fubin/tidb510_br510" --log-file full_restore_2_system.log
[2021/06/10 11:38:52.086 +08:00] [INFO] [data_slow_query.go:144] ["Telemetry slow query stats initialized"] [currentSQBInfo={0.512:0,65.536:0,524.288:0,2097.152:0,134217.734:0,33554.434:0,1048.576:0,0.008:0,0.016:0,2.048:0,4.096:0,8.192:0,4194.304:0,0.002:0,16777.217:0,67108.867:0,0.004:0,0.064:0,16.384:0,32.768:0,131.072:0,262.144:0,+Inf:0,0.001:0,0.128:0,0.256:0,0.032:0,1.024:0,8388.608:0] [lastSQBInfo={1048.576:0,0.001:0,0.032:0,0.128:0,0.512:0,4.096:0,524.288:0,2097.152:0,33554.434:0,8.192:0,0.256:0,65.536:0,16777.217:0,0.064:0,2.048:0,+Inf:0,0.002:0,0.004:0,1.024:0,4194.304:0,134217.734:0,0.008:0,131.072:0,262.144:0,8388.608:0,0.016:0,16.384:0,32.768:0,67108.867:0]
Detail BR log in full_restore_2_system.log
[2021/06/10 11:38:52.229 +08:00] [INFO] [collector.go:66] ["Full restore success summary"] [total-ranges=0] [ranges-succeed=0] [ranges-failed=0] [total-take=119.928823ms] [Result="Nothing to restore"]
==full_restore_2_system.log==
[2021/06/10 11:38:52.204 +08:00] [INFO] [client.go:195] ["load backupmeta"] [databases=2] [jobs=0]
[2021/06/10 11:38:52.212 +08:00] [INFO] [import.go:242] ["multi ingest support"] [support=true]
[2021/06/10 11:38:52.218 +08:00] [WARN] [restore.go:530] ["set max-index-length to max(3072*4) to skip check index length in DDL"]
[2021/06/10 11:38:52.218 +08:00] [INFO] [restore.go:315] ["nothing to restore, all databases and tables are filtered out"]
-
Configuration of the cluster and the task
tidb-lightning.tomlfor TiDB-Lightning if possibletikv-importer.tomlfor TiKV-Importer if possibletopology.ymlif deployed by TiUP
-
Screenshot/exported-PDF of Grafana dashboard or metrics' graph in Prometheus if possible