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]
