Skip to content
New issue

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

Lightning: import to wrong db name with some route rules #33381

Closed
Ehco1996 opened this issue Mar 24, 2022 · 0 comments · Fixed by #33484
Closed

Lightning: import to wrong db name with some route rules #33381

Ehco1996 opened this issue Mar 24, 2022 · 0 comments · Fixed by #33484
Assignees
Labels
affects-6.0 component/lightning This issue is related to Lightning of TiDB. severity/major type/bug The issue is confirmed as a bug.

Comments

@Ehco1996
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

test file and config to reproduce this is here :test-lighning-route.zip

dumped data from dumping

├── dumped_data
│   ├── metadata
│   ├── webui-schema-create.sql
│   └── webui.t1-schema.sql
├── tidb-lightning.log
└── webui.toml

task.toml

[lightning]
file = "tidb-lightning.log"
level = "info"

[tikv-importer]
backend = "tidb"

[mydumper]
data-source-dir = "./dumped_data"

[tidb]
host = "127.0.0.1"
password = "123456"
port = 3307
user = "root"

[[routes]]
schema-pattern = "webui"
target-schema = "webui_test"

2. What did you expect to see? (Required)

i want to route db: webui to webui_test and keep table names

3. What did you see instead (Required)

lightning two db webui and webui_test

MySQL [email protected]:(none)> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dm_meta            |
| mysql              |
| performance_schema |
| sys                |
| webui              |
| webui_test         |
+--------------------+

4. What is your TiDB version? (Required)

❯ tidb-lightning -V
Release Version: v6.1.0-alpha-38-g6d0185585-dirty
Git Commit Hash: 6d01855856aac61e0829f73ed8a47be6add45321
Git Branch: master
Go Version: go1.18
UTC Build Time: 2022-03-24 05:41:35
Race Enabled: false
@Ehco1996 Ehco1996 added type/bug The issue is confirmed as a bug. component/lightning This issue is related to Lightning of TiDB. labels Mar 24, 2022
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 labels Mar 24, 2022
@sleepymole sleepymole assigned Ehco1996 and unassigned sleepymole Mar 30, 2022
@Ehco1996 Ehco1996 removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. labels Apr 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.0 component/lightning This issue is related to Lightning of TiDB. severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
5 participants