【StarRocks版本】例如:2.5.4
2.5.1 可以正常连接,测试了一下2.5.4不知道为啥连接不上。
看FE日志显示的是语法错误。
【StarRocks版本】例如:2.5.4
2.5.1 可以正常连接,测试了一下2.5.4不知道为啥连接不上。
看FE日志显示的是语法错误。
sqlyog版本是多少?
sqlyog v11.24
收到,我们确认一下原因,尽快在下一个新版本修复,谢谢!
2.5.5 版本也有这个问题
FE错误信息:
2023-05-16 16:01:17,181 INFO (starrocks-mysql-nio I/O-3|96) [AcceptListener.handleEvent():57] Connection established. remote=/172.18.108.206:64278
2023-05-16 16:01:17,184 WARN (starrocks-mysql-nio-pool-5|298) [ConnectProcessor.handleQuery():344] Process one query failed. SQL: /*!40101 set @@session.wait_timeout=28800 */, because.
com.starrocks.common.AnalysisException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:300) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:440) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:698) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_261]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_261]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261]
2023-05-16 16:01:17,186 INFO (starrocks-mysql-nio-pool-5|298) [MysqlChannel.fetchOnePacket():176] Receive packet header failed, remote 172.18.108.206:64278 may close the channel.
2023-05-16 16:01:17,186 WARN (starrocks-mysql-nio-pool-5|298) [ReadListener.lambda$handleEvent$0():63] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@6e0d81fd).
java.io.IOException: Error happened when receiving packet.
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:689) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_261]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_261]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261]
先用DBeaver连吧