We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Please answer these questions before submitting your issue. Thanks!
Cluster TiDB1
Cluster TiDB2
tiup br:v5.4.0 restore table --pd "172.xx.xx.136:16279" --db "test" --table "test" --storage "local:///tmp/backup"
tiup br:v5.4.0 restore table --pd "172.xx.xx.136:16279" --db "test" --table "test" --storage "local:///tmp/backupincr"
What did you expect to see?
restore incremental data success.
alter table test add unique index indx(age); [2022/06/30 17:35:16.975 +08:00] [INFO] [collector.go:67] ["Table restore failed summary"] [total-ranges=0] [ranges-succeed=0] [ranges-failed=0] Error: [kv:1062]Duplicate entry '1' for key 'indx' Error: run /home/tidbryl/.tiup/components/br/v5.4.0/br (wd:/home/tidbryl/.tiup/data/TAES1t4) failed: exit status 1
/home/tidbryl/.tiup/components/br/v5.4.0/br
BR version: Release Version: v5.4.0 Git Commit Hash: 55f3b24c1c9f506bd652ef1d162283541e428872 Git Branch: heads/refs/tags/v5.4.0 Go Version: go1.16.4 UTC Build Time: 2022-01-25 08:36:34
cluster version: v5.4.0
Operation logs
br.log
tidb-lightning.log
tikv-importer.log
Configuration of the cluster and the task
tidb-lightning.toml
tikv-importer.toml
topology.yml
Screenshot/exported-PDF of Grafana dashboard or metrics' graph in Prometheus if possible
The text was updated successfully, but these errors were encountered:
Cloud you please add the sql statement of adding column age?
age
Sorry, something went wrong.
Done,Please check.
This problem seems to affect all 4.x and 5.x and I'am not sure whether it has been fixed in 6.x
The problem lies the logic: When restore, we always restore ddl first and then the table data, maybe we should rethink this logic again.
/assign @WangLe1321
WangLe1321
No branches or pull requests
Please answer these questions before submitting your issue. Thanks!
If possible, provide a recipe for reproducing the error.
Cluster TiDB1
Cluster TiDB2
tiup br:v5.4.0 restore table --pd "172.xx.xx.136:16279" --db "test" --table "test" --storage "local:///tmp/backup"
tiup br:v5.4.0 restore table --pd "172.xx.xx.136:16279" --db "test" --table "test" --storage "local:///tmp/backupincr"
What did you expect to see?
restore incremental data success.
alter table test add unique index indx(age);
[2022/06/30 17:35:16.975 +08:00] [INFO] [collector.go:67] ["Table restore failed summary"] [total-ranges=0] [ranges-succeed=0] [ranges-failed=0]
Error: [kv:1062]Duplicate entry '1' for key 'indx'
Error: run
/home/tidbryl/.tiup/components/br/v5.4.0/br
(wd:/home/tidbryl/.tiup/data/TAES1t4) failed: exit status 1BR version:
Release Version: v5.4.0
Git Commit Hash: 55f3b24c1c9f506bd652ef1d162283541e428872
Git Branch: heads/refs/tags/v5.4.0
Go Version: go1.16.4
UTC Build Time: 2022-01-25 08:36:34
cluster version: v5.4.0
Operation logs
br.log
for BR if possibletidb-lightning.log
for TiDB-Lightning if possibletikv-importer.log
from TiKV-Importer if possibleConfiguration of the cluster and the task
tidb-lightning.toml
for TiDB-Lightning if possibletikv-importer.toml
for TiKV-Importer if possibletopology.yml
if deployed by TiUPScreenshot/exported-PDF of Grafana dashboard or metrics' graph in Prometheus if possible
The text was updated successfully, but these errors were encountered: