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

DM loading NONCLUSTERED auto_increment and AUTO_ID_CACHE=1 table with lightning physical backend results in "duplicate entry" #9620

Closed
fubinzh opened this issue Aug 21, 2023 · 4 comments
Labels
affects-7.1 area/dm Issues or PRs related to DM. severity/major type/bug The issue is confirmed as a bug.

Comments

@fubinzh
Copy link

fubinzh commented Aug 21, 2023

What did you do?

Refer to: pingcap/tidb#46100
DM need update lightning version

What did you expect to see?

It should be OK for DM to load NONCLUSTERED auto_increment and AUTO_ID_CACHE=1 table with lightning physical backend.

What did you see instead?

After DM load data, later insert might report error "duplicate entry"

Versions of the cluster

DM version: v7.3.0

current status of DM cluster (execute query-status <task-name> in dmctl)

(paste current status of DM cluster here)
@fubinzh fubinzh added area/dm Issues or PRs related to DM. type/bug The issue is confirmed as a bug. labels Aug 21, 2023
@fubinzh
Copy link
Author

fubinzh commented Aug 21, 2023

/severity major

@fubinzh
Copy link
Author

fubinzh commented Aug 21, 2023

/label affects-7.1

@lichunzhu
Copy link
Contributor

lichunzhu commented Oct 20, 2023

TiDB dependencies are already updated on master e4ac90b.
I use the original PR's pingcap/tidb#46171 integration test data to do a manual test and it works. Close this now.
image

@D3Hunter
Copy link
Contributor

D3Hunter commented Nov 8, 2023

this pr #9642 already updated tidb dependency, and include the fix, 7.5 contains it

after #9954 cp to 7.1, 7.1 also contains the fix

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 area/dm Issues or PRs related to DM. severity/major type/bug The issue is confirmed as a bug.
Projects
Development

No branches or pull requests

5 participants