matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: sysbench mixed test report strange error.

Open Ariznawlll opened this issue 1 year ago • 13 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

1.0-dev

Commit ID

8081e0516065caf2531835c42f92e00c99f0082a

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image image image

sysbench工具log: sysbench.log

mo-log:http://10.222.6.1/explore?panes=%7B%22uUC%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-stability-regression%5C%22%7D%20%7C%3D%20%60panic%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:%22now-12h%22,%22to%22:%22now%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

混合场景并行跑

Additional information

No response

Ariznawlll avatar Dec 22 '23 09:12 Ariznawlll

截图上是utc+8的时间。实际是utc 21号。

daviszhen avatar Dec 25 '23 11:12 daviszhen

sysbench.log 有几种报错情况: 1,the connection between CN and TN has been disconnected 发生时间点在utc 2023-12-21 19:43:00 左右。 这个原因未明确,大概率是cn重启了。但是在监控上看不出来此时间点有pod重启。

发生在utc 2023-12-21 20:40:00 前后。cn重启。能在监控上看到。http://10.222.6.1/d/cluster-detail-namespaced/cluster-detail-namespaced?orgId=1&from=1703181600000&to=1703203199000&var-namespace=mo-stability-regression&var-account=All&var-interval=$__auto_interval_interval&var-cluster=.%2A&var-loki=loki

2,Communications link failure. lock table not found on remote lock service Could not create connection to database server. dial tcp4 10.10.4.99:6003: connect: connection refused Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 发生在 utc 2023-12-21 20:20:00 前后。 以及utc 2023-12-21 20:40:00 前后。 以及utc 2023-12-21 21:48:00 前后。

这段时间是cn oom重启导致的。监控的时间点能对得上。

image

http://10.222.6.1/d/cluster-detail-namespaced/cluster-detail-namespaced?orgId=1&from=1703181600000&to=1703203199000&var-namespace=mo-stability-regression&var-account=All&var-interval=$__auto_interval_interval&var-cluster=.%2A&var-loki=loki

daviszhen avatar Dec 26 '23 03:12 daviszhen

就utc 2023-12-21 19:43:00 这个时间点 时间点日志与监控。其它时间点日志与监控基本对得上

daviszhen avatar Dec 26 '23 04:12 daviszhen

只处理OOM部分

ouyuanning avatar Dec 26 '23 05:12 ouyuanning

no process

nnsgmsone avatar Jan 25 '24 10:01 nnsgmsone

no process

nnsgmsone avatar Jan 30 '24 10:01 nnsgmsone

no process

nnsgmsone avatar Feb 02 '24 10:02 nnsgmsone

no process

nnsgmsone avatar Feb 21 '24 13:02 nnsgmsone

no process

nnsgmsone avatar Feb 26 '24 10:02 nnsgmsone

处理数据正确性问题中

nnsgmsone avatar Feb 29 '24 10:02 nnsgmsone

no process

nnsgmsone avatar Mar 05 '24 10:03 nnsgmsone

no proess

nnsgmsone avatar Mar 08 '24 10:03 nnsgmsone

no process

nnsgmsone avatar Mar 13 '24 10:03 nnsgmsone

no process

nnsgmsone avatar Mar 18 '24 11:03 nnsgmsone

no process

nnsgmsone avatar Mar 21 '24 10:03 nnsgmsone

The issue is outdated, and neither the context nor the environment has been preserved, making it impossible to locate. Close it for now. If it reoccurs, open a new issue.

sukki37 avatar Mar 26 '24 09:03 sukki37