[Bug]: ut test fail in TestMysqlResultSet

[badboynt1]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

lastest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2024-04-18T06:43:17.3421558Z send response failed. error:illegal state{"level":"info","ts":"2024-04-18 06:26:47.340","caller":"[email protected]/application.go:383","msg":"session read failed","listen-addresses":"[127.0.0.1:6001]","session-id":1,"addr":"127.0.0.1:44518","error":"illegal state"} 2024-04-18T06:43:17.3422519Z {"level":"error","ts":"2024-04-18 06:26:47.341","caller":"[email protected]/application.go:357","msg":"handle session failed","listen-addresses":"[127.0.0.1:6001]","error":"illegal state"} 2024-04-18T06:43:17.3422792Z [mysql] 2024/04/18 06:29:01 packets.go:37: unexpected EOF 2024-04-18T06:43:17.3422995Z mysql_protocol_test.go:1796: 2024-04-18T06:43:17.3423652Z Error Trace: /home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1796 2024-04-18T06:43:17.3424557Z /home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1566 2024-04-18T06:43:17.3424824Z Error: Should be true 2024-04-18T06:43:17.3425050Z Test: TestMysqlResultSet 2024-04-18T06:43:17.3425284Z mysql_protocol_test.go:1663: 2024-04-18T06:43:17.3425892Z Error Trace: /home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1663 2024-04-18T06:43:17.3426662Z /opt/hostedtoolcache/go/1.21.5/x64/src/runtime/panic.go:541 2024-04-18T06:43:17.3427360Z /opt/hostedtoolcache/go/1.21.5/x64/src/testing/testing.go:999 2024-04-18T06:43:17.3428187Z /home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1796 2024-04-18T06:43:17.3429048Z /home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1566 2024-04-18T06:43:17.3429308Z Error: Received unexpected error: 2024-04-18T06:43:17.3429701Z invalid connection 2024-04-18T06:43:17.3429924Z Test: TestMysqlResultSet 2024-04-18T06:43:17.3430243Z --- FAIL: TestMysqlResultSet (437.49s) 2024-04-18T06:43:17.3430392Z === RUN Test_writePackets 2024-04-18T06:43:17.3430399Z

Expected Behavior

ut success

Steps to Reproduce

run ut test

Additional information

No response

[sukki37]

repro: https://github.com/matrixorigin/matrixone/actions/runs/8747811301/job/24006853596?pr=15613

[daviszhen]

未投入

[sukki37]

repro: https://github.com/matrixorigin/matrixone/actions/runs/8834230800/job/24255417164?pr=15682

[sukki37]

repro: https://github.com/matrixorigin/matrixone/actions/runs/8890303324/job/24410111618?pr=15804

[daviszhen]

未投入

[sukki37]

repro：https://github.com/matrixorigin/matrixone/actions/runs/8995547998/job/24710679034?pr=15889

2024-05-08T03:18:18.0747369Z === RUN   TestMysqlResultSet
2024-05-08T03:18:18.0747847Z Server started
2024-05-08T03:18:18.0748825Z 2024/05/08 03:03:55.782671 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0750309Z 2024/05/08 03:03:55.783214 +0000 INFO cn-service.frontend check password succeeded {"uuid": "", "session_info": "", "session_id": "018f5628-5886-7ca9-9e90-d2b8e89b6aaa"}
2024-05-08T03:18:18.0751235Z 2024/05/08 03:03:57.756757 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0751980Z 2024/05/08 03:03:59.867407 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0752760Z 2024/05/08 03:04:03.736261 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0753574Z 2024/05/08 03:04:06.578110 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0754422Z 2024/05/08 03:04:08.777465 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0755226Z 2024/05/08 03:04:11.418295 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0755946Z 2024/05/08 03:04:13.091428 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0756808Z 2024/05/08 03:04:16.061593 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0757531Z 2024/05/08 03:04:17.548490 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0758296Z 2024/05/08 03:04:19.045017 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0759134Z 2024/05/08 03:04:21.043617 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0759911Z 2024/05/08 03:04:25.415070 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0760654Z 2024/05/08 03:04:28.067524 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0761442Z 2024/05/08 03:04:31.359843 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0762163Z 2024/05/08 03:04:34.973087 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0763040Z 2024/05/08 03:04:36.866360 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0763789Z 2024/05/08 03:04:39.796217 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0764608Z 2024/05/08 03:04:44.629266 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0765391Z 2024/05/08 03:04:46.339069 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0766108Z 2024/05/08 03:04:48.069305 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0766968Z 2024/05/08 03:04:49.356395 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0767716Z 2024/05/08 03:04:53.194391 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0768485Z 2024/05/08 03:05:06.916251 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0769198Z 2024/05/08 03:05:42.403836 +0000 INFO frontend/util.go:212 Using Dump Storage Engine and Cluster Nodes.
2024-05-08T03:18:18.0772144Z send response failed. error:write tcp4 127.0.0.1:6001->127.0.0.1:55742: use of closed network connection{"level":"info","ts":"2024-05-08 03:08:54.762","caller":"[email protected]/application.go:383","msg":"session read failed","listen-addresses":"[127.0.0.1:6001]","session-id":1,"addr":"127.0.0.1:55742","error":"illegal state"}
2024-05-08T03:18:18.0774164Z {"level":"error","ts":"2024-05-08 03:08:54.762","caller":"[email protected]/application.go:357","msg":"handle session failed","listen-addresses":"[127.0.0.1:6001]","error":"illegal state"}
2024-05-08T03:18:18.0774568Z Server exited
2024-05-08T03:18:18.0775000Z [mysql] 2024/05/08 03:10:31 packets.go:73: unexpected EOF
2024-05-08T03:18:18.0775356Z [mysql] 2024/05/08 03:10:31 packets.go:427: busy buffer
2024-05-08T03:18:18.0775832Z     mysql_protocol_test.go:1796: 
2024-05-08T03:18:18.0776907Z         	Error Trace:	/home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1796
2024-05-08T03:18:18.0778492Z         	            				/home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1566
2024-05-08T03:18:18.0778838Z         	Error:      	Should be true
2024-05-08T03:18:18.0779292Z         	Test:       	TestMysqlResultSet
2024-05-08T03:18:18.0779749Z     mysql_protocol_test.go:1663: 
2024-05-08T03:18:18.0781070Z         	Error Trace:	/home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1663
2024-05-08T03:18:18.0782262Z         	            				/opt/hostedtoolcache/go/1.21.5/x64/src/runtime/panic.go:541
2024-05-08T03:18:18.0783521Z         	            				/opt/hostedtoolcache/go/1.21.5/x64/src/testing/testing.go:999
2024-05-08T03:18:18.0785088Z         	            				/home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1796
2024-05-08T03:18:18.0786578Z         	            				/home/runner/work/matrixone/matrixone/pkg/frontend/mysql_protocol_test.go:1566
2024-05-08T03:18:18.0787203Z         	Error:      	Received unexpected error:
2024-05-08T03:18:18.0787692Z         	            	invalid connection
2024-05-08T03:18:18.0788188Z         	Test:       	TestMysqlResultSet
2024-05-08T03:18:18.0788587Z --- FAIL: TestMysqlResultSet (401.82s)

[sukki37]

repro：https://github.com/matrixorigin/matrixone/actions/runs/8998178225/job/24717765727?pr=15777

[daviszhen]

要重写这个ut。原先的逻辑与主干逻辑是独立的。

[daviszhen]

引入协议静态测试后，重写ut

[daviszhen]

引入协议静态测试后，重写ut

[daviszhen]

引入协议静态测试后，重写ut

[daviszhen]

引入协议静态测试后，重写ut

[daviszhen]

引入协议静态测试后，重写ut

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

未投入

[daviszhen]

fixed.