[Bug]: [date 11.15]tke regression: sysbench 1000w no-pk index point select reported dial tcp cannot assign requested address

[heni02]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

0079c99

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11858160663/job/33073288728

mo log:
https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22s-u%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-branch-nightly-0079c99cc-20241115%5C%22%7D%20%7C%3D%20%60cannot%20assign%20requested%20address%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:%221731734808932%22,%22to%22:%221731735994298%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

sysbench  --mysql-host=172.16.96.188 --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=30 --report-interval=10 --secondary=on  --create_secondary=off  prepare

sysbench  --mysql-host=172.16.96.188 --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=300 --report-interval=10 --range_selects=off --point_selects=1 --secondary=on  --create_secondary=off  run

Additional information

No response

[reusee]

https://grafana.ci.matrixorigin.cn/goto/rCp_eN7Hg?orgId=1
经优化，已经没有了 443 目标端口连接数过多的问题。
53端口的dns查询会在另一个pr优化

[aressu1985]

还是存在
commit: dd576d3
repo: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11997047736/job/33453307439

[aressu1985]

修复了很多次，始终未找到根因，2.0.1版本应该无法完全搞定，继续DELAY

[reusee]

未复现

[reusee]

和 #18725 同一个问题。已提pr

[reusee]

继续观察

[reusee]

working on other issues.

[reusee]

more fix pending.

[reusee]

继续观察

[reusee]

继续观察

[heni02]

观察2周回归没有再出现该问题，closed