err: create select plan error: stmt type does not support shard now

[xiaomi]

err: create select plan error: stmt type does not support shard now

[teckick]

您好, 感谢反馈!

对于问题1, 还需要您看下gaea的日志是否有相关报错信息.

对于问题2, 目前gaea不支持DDL, 一般是由DBA直接在MySQL实例上执行建表等操作.

[Feigerlan]

问题1（不带参数-A的情况下才会出现这个问题，如果带了-A 参数 可以正常show tables和select *等等）：
mysql连接show tables报错现象如下：
MySQL [cas]> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 10007
Current database: cas

日志如下：
[root@sh-loancore-clusterdb-dapseq logs]# tail gaea.log.wf
[2020-07-23 08:58:34] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:34] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Run:session.go:240] Session write response error, connId: 10006, err: Conn 10006: Write(header) failed: write tcp4 172.16.1.24:13306->172.16.1.93:52408: write: broken pipe
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Run:session.go:240] Session write response error, connId: 10007, err: Conn 10007: Write(header) failed: write tcp4 172.16.1.24:13306->172.16.1.93:52414: write: broken pipe
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/backend.(*Slice).GetConn:slice.go:88] get connection from slave failed, try to get from master, error: no database
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Run:session.go:240] Session write response error, connId: 10008, err: Conn 10008: Write(header) failed: write tcp4 172.16.1.24:13306->172.16.1.93:52416: write: broken pipe
[root@sh-loancore-clusterdb-dapseq logs]# tail gaea.log
[2020-07-23 08:58:34] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [DEBUG] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Close:session.go:196] client closed, 10006
[2020-07-23 08:58:34] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [NOTICE] [900000001] [main.main.func1:main.go:90] Ignore broken pipe signal
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [NOTICE] [900000001] [main.main.func1:main.go:90] Ignore broken pipe signal
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [DEBUG] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Close:session.go:196] client closed, 10007
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [NOTICE] [900000001] [main.main.func1:main.go:90] Ignore broken pipe signal
[2020-07-23 08:58:40] [gaea_proxy] [sh-loancore-clusterdb-dapseq] [DEBUG] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Session).Close:session.go:196] client closed, 10008

问题2 ：
想请教一下这块gaea在小米的使用场景后续有支持DDL的计划吗?

[teckick]

客户端使用的是哪个版本? 使用其他客户端测试会出现同样问题吗?

[Feigerlan]

mysql --version
mysql Ver 15.1 Distrib 10.1.41-MariaDB, for Linux (x86_64) using readline 5.1