matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: 1.2-dev standalone: sysbench10w write_only1000threads reported Duplicate entry and w-w error

Open heni02 opened this issue 1 year ago • 5 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

6cfdcaf20fb7cda1a027e1b5c0b837607d4442d7

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9536425137/job/26283375736 企业微信截图_53a17115-6bb7-44e4-89fc-200503e559d2

mo log plz contact me

Expected Behavior

No response

Steps to Reproduce

sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 oltp_write_only.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=1000 --time=30 --report-interval=10    prepare
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 —db-ps-mode=disable --mysql-ignore-errors=20701 oltp_write_only.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=1000 --time=300 --report-interval=10     --range_selects=off --point_selects=1 run

Additional information

No response

heni02 avatar Jun 17 '24 03:06 heni02

Dup with #16577

triump2020 avatar Jun 17 '24 03:06 triump2020

Maybe this PR leads to this bug, i' ll confirm this.

triump2020 avatar Jun 17 '24 09:06 triump2020

date 6.22 回归测试复现 job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9623774223/job/26546707962 w-w报错时间: 企业微信截图_ce8d0cb8-6ae0-4732-80df-c3a4f8ef2c5d

dup报错时间: 企业微信截图_ce8d0cb8-6ae0-4732-80df-c3a4f8ef2c5d

日志太大,私发定位

heni02 avatar Jun 23 '24 04:06 heni02

单机的 ww/dup 原因已定位到大致原因。

triump2020 avatar Jun 28 '24 10:06 triump2020

需要进一步定位根本原因

triump2020 avatar Jul 03 '24 12:07 triump2020

@heni02 PR had fix it .

triump2020 avatar Jul 05 '24 03:07 triump2020

需要继续观察两天回归测试

heni02 avatar Jul 08 '24 07:07 heni02

观察两周没有再出现 confirm,closed

heni02 avatar Jul 19 '24 04:07 heni02