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

load data replace error #43849

Closed
nickzabc opened this issue May 16, 2023 · 2 comments
Closed

load data replace error #43849

nickzabc opened this issue May 16, 2023 · 2 comments
Labels
affects-6.5 severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.

Comments

@nickzabc
Copy link

nickzabc commented May 16, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Execution the following SQL:

use test;
drop table if exists t1;
create table t1(id int, name varchar(20), primary key(id) clustered);
load data local infile './a.dat' replace into table t1 fields terminated by ',' enclosed by '' (id,name);
load data local infile './b.dat' replace into table t1 fields terminated by ',' enclosed by '' (id,name);

Content of a.dat

1,abc
2,cdef
3,asdf

Content of b.dat

1,AAA
2,BBB
3,asdf

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

success

3. What did you see instead (Required)

load data local infile './b.dat' replace into table t1 fields terminated by ',' enclosed by '' (id,name);
ERROR 8141 (HY000): assertion failed: key: 7480000000000000885f728000000000000001, assertion: NotExist, start_ts: 441434804390461442, existing start ts: 441434803092848642, existing commit ts: 441434803092848643

4. What is your TiDB version? (Required)

6.5.2

@nickzabc nickzabc added the type/bug The issue is confirmed as a bug. label May 16, 2023
@ti-chi-bot ti-chi-bot bot added 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.1 may-affects-6.5 may-affects-7.1 labels May 16, 2023
@YangKeao YangKeao assigned zyguan and unassigned zyguan May 16, 2023
@you06 you06 added affects-6.5 and removed 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.1 may-affects-6.5 may-affects-7.1 labels May 16, 2023
ti-chi-bot bot pushed a commit that referenced this issue May 16, 2023
@jebter jebter added sig/transaction SIG:Transaction and removed sig/sql-infra SIG: SQL Infra labels May 16, 2023
@zyguan
Copy link
Contributor

zyguan commented Jun 16, 2023

fixed by #43858

@you06
Copy link
Contributor

you06 commented Oct 16, 2023

With refactor of #42565, the load data worker uses internal sessions and the assertion is turned off, so this replace error won't happen anymore.
Remove affect-7.1 and affect-7.3 labels.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.5 severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

5 participants