matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 277 forks source link

[Bug]: [date 9.11]1.2-dev tke regression: sysbench no-pk point select test reported operation error S3: GetObject, exceeded maximum number of attempts, 3 #18725

Open heni02 opened 2 months ago

heni02 commented 2 months ago

Is there an existing issue for the same bug?

Branch Name

1.2-dev,main

Commit ID

2fed24bdf

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/10813870929/job/30021691067

企业微信截图_0c258cbf-35b5-404c-a5c1-053ea71d0b4e

FATAL: mysql_stmt_execute() returned error 1105 (operation error S3: GetObject, exceeded maximum number of attempts, 3, https response error StatusCode: 0, RequestID: , HostID: , request send failed, Get "https://mo-nightly-gz-1308875761.cos.ap-guangzhou.myqcloud.com/mo-benchmark-10813870929/data/0191e397-5f91-7c0a-a0fa-1b927613232f_00000?x-id=GetObject": dial tcp 169.254.0.47:443: connect: cannot assign requested address) for query 'SELECT c FROM sbtest10 WHERE id=?'

mo log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22qFM%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-branch-nightly-2fed24bdf-20240911%5C%22%7D%20%7C%3D%20%60S3:%20GetObject,%20exceeded%20maximum%20number%20of%20attempts,%203%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221726045516630%22,%22to%22:%221726131916630%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

sysbench  --mysql-host=172.16.110.95 --mysql-port=6001 --mysql-user=dump --mysql-password=111  oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=10000000 --threads=100 --time=150 --report-interval=10 --range_selects=off --point_selects=1 --secondary=on  --create_secondary=off --auto_inc=off prepare

sysbench  --mysql-host=172.16.110.95 --mysql-port=6001 --mysql-user=dump --mysql-password=111  oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=10000000 --threads=100 --time=150 --report-interval=10 --range_selects=off --point_selects=1 --secondary=on  --create_secondary=off --auto_inc=off run

Additional information

No response

reusee commented 1 month ago

无进展

reusee commented 1 month ago

无进展

reusee commented 1 month ago

无进展

reusee commented 1 month ago

无进展

reusee commented 4 weeks ago

无进展

reusee commented 3 weeks ago

已提pr替换成腾讯云sdk

reusee commented 3 weeks ago

无进展

aressu1985 commented 2 weeks ago

repo link: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11556246019

aressu1985 commented 2 weeks ago

repo link: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11556246019/job/32194544455

image
reusee commented 1 week ago

已优化,观察中

reusee commented 3 days ago

无进展

reusee commented 20 hours ago

无进展