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

[Bug]: Duplicate entry error during create account if not exists xxx with hight concurrency #20728

Open
1 task done
aressu1985 opened this issue Dec 11, 2024 · 3 comments
Open
1 task done
Assignees
Labels
kind/bug Something isn't working severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone

Comments

@aressu1985
Copy link
Contributor

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

0bbda66

Other Environment Information

- Hardware parameters: 64C 128G
- OS type:
- Others:

Actual Behavior

mo-load tool log:
2024-12-11 20:52:09 INFO ResultProcessor:140 - delet**count: tps=0,qps=0,suc=1444,err=8,rt_max=29829,rt_min=0,rt_avg=0.00
2024-12-11 20:52:10 ERROR TransExecutor:274 -
ErrorTime : 2024-12-11 20:52:10
RequestTime : 2024-12-11 20:52:09.663
TxnName : create_account
Statement : create account if not exists acount_6 admin_name 'admin' identified by '111';
ErrorCode : 1062
ErrorMessage : Duplicate entry 'acount_6' for key 'account_name'
Expected : false

2024-12-11 20:52:10 ERROR TransExecutor:274 -
ErrorTime : 2024-12-11 20:52:10
RequestTime : 2024-12-11 20:52:09.663
TxnName : create_account
Statement : create account if not exists acount_6 admin_name 'admin' identified by '111';
ErrorCode : 1062
ErrorMessage : Duplicate entry 'acount_6' for key 'account_name'
Expected : false

mo-log:
mo-service.tar.gz

Expected Behavior

No response

Steps to Reproduce

1. run a mo
2. git clone https://github.com/matrixorigin/mo-load.git
3. ./start.sh -c cases/ddl/create_drop_account -d 10 -g -i 2

Additional information

No response

@aressu1985 aressu1985 added kind/bug Something isn't working needs-triage severity/s0 Extreme impact: Cause the application to break down and seriously affect the use labels Dec 11, 2024
@aressu1985 aressu1985 added this to the 2.0.2 milestone Dec 11, 2024
@sukki37 sukki37 assigned daviszhen and unassigned matrix-meow Dec 12, 2024
@daviszhen
Copy link
Contributor

未投入

1 similar comment
@daviszhen
Copy link
Contributor

未投入

@daviszhen
Copy link
Contributor

daviszhen commented Dec 24, 2024

死锁分析中

@daviszhen daviszhen mentioned this issue Dec 26, 2024
7 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Development

No branches or pull requests

4 participants