Bug: write fields error 0: conn 0: Check conn status error

[dongzl]

What happened:

What you expected to happen:

How to reproduce it (as minimally and precisely as possible):

Anything else we need to know?:

• use mysql client connect arana, execute SQL is OK.

• use follow code insert data:

package mysql

import (
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"testing"
	"time"
)

func Test_sequence(t *testing.T) {
	// DSN:Data Source Name
	dsn := "dksl:123456@tcp(127.0.0.1:13306)/employees"
	db, err := sql.Open("mysql", dsn)
	if err != nil {
		panic(err)
	}
	defer db.Close() // 注意这行代码要写在上面err判断的下面

	start := time.Now().Unix()
	sqlStr := "INSERT INTO student (uid, name, score, nickname, gender, birth_year, created_at, modified_at) VALUES (?, ?, 95, ?, 0, 16, NOW(), NOW());"
	for i := 0; i < 1000; i++ {
		ret, err := db.Exec(sqlStr, i, fmt.Sprintf("%s_%d", "scott", i), fmt.Sprintf("%s_%d", "nc_scott", i))
		if err != nil {
			fmt.Printf("insert failed, err:%v\n", err)
			return
		}
		theID, err := ret.LastInsertId() // 新插入数据的id
		if err != nil {
			fmt.Printf("get lastinsert ID failed, err:%v\n", err)
			return
		}
		fmt.Printf("insert success, the id is %d.\n", theID)
	}
	fmt.Println(time.Now().Unix() - start)
}

• use mysql client connect arana, execute is error.

• arana console error msg:

2022-07-27T11:57:48.328+0800    ERROR   mysql/execute_handle.go:122     write fields error 0: conn 0: Check conn status error
github.com/arana-db/arana/pkg/mysql.(*Listener).handleQuery
        /Users/dongzonglei/source_code/Github/arana/pkg/mysql/execute_handle.go:122
github.com/arana-db/arana/pkg/mysql.(*Listener).ExecuteCommand
        /Users/dongzonglei/source_code/Github/arana/pkg/mysql/server.go:553
github.com/arana-db/arana/pkg/mysql.(*Listener).handle
        /Users/dongzonglei/source_code/Github/arana/pkg/mysql/server.go:203
2022-07-27T11:57:48.328+0800    ERROR   mysql/server.go:207     failed to execute command: conn 0: Check conn status error
github.com/arana-db/arana/pkg/mysql.(*Listener).handle
        /Users/dongzonglei/source_code/Github/arana/pkg/mysql/server.go:207
2022-07-27T11:57:49.949+0800    DEBUG   executor/redirect.go:172        ComQuery: show databases
2022-07-27T11:57:49.949+0800    DEBUG   executor/redirect.go:172        ComQuery: show tables

[Penglq]

the connection#5 of remote client 127.0.0.1:55199 requests quit

[Penglq]

This problem occurs when the mysql client queries again after the GO client executes the statement and exits