fanchao916 opened a new issue #10400:
URL: https://github.com/apache/shardingsphere/issues/10400


   sharding-proxy 5.x版本,使用mysql客户端连接之后(mysql -uxx -pxx -hxx -Pxxx),show 
databases 可以显示有的库,执行use sharding_db之后,执行show tables;报错
   
   ERROR 2006 (HY000): MySQL server has gone away
   No connection. Trying to reconnect...
   Connection id:    31
   Current database: sharding_db
   
   ERROR 2013 (HY000): Lost connection to MySQL server during query
   
   因为知道里面有什么表,直接执行 select * from  sharding_db.t_order 之后错误同上。
   
   使用python,mysqlworkbench连接这个proxy ,可以执行show tables等命令,数据查询也是正常的。
   
--------------------------------------------------------------------------------------------------
   还是用mysql 客户端连进来之后,首先执行了一个show variables  之后,不具体use xxx,再执行show 
tables,可以看到配置在库里的表。也可以执行查询。但是执行 use  xxx 之后,不管执行show  tables还是select 语句,都是报服务断开
   
   以上报错的时候,在日志里没有任何记录
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to