EmmyMiao87 commented on pull request #5386:
URL: https://github.com/apache/incubator-doris/pull/5386#issuecomment-802619770
Due to the upgrade of the mysql protocol, if the user uses the 5.1 version
of the client, it will lose the connection with the Mysql server during the
query problem.
It can be seen from the warning log of fe that there are similar
```
2021-03-19 15:32:56,508 WARN (doris-mysql-nio-pool-486|1023)
[MysqlChannel.fetchOnePacket():154] receive packet sequence id[0] want to get[3]
2021-03-19 15:32:56,508 WARN (doris-mysql-nio-pool-486|1023)
[AcceptListener.lambda$handleEvent$1():83] connect processor exception because
java.io.IOException: Bad packet sequence.
at
org.apache.doris.mysql.MysqlChannel.fetchOnePacket(MysqlChannel.java:155)
~[palo-fe.jar:3.4.0]
at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:209)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
~[palo-fe.jar:3.4.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_131]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
```
The solution is:
Upgrade mysql client to 5.7.
Here is the installation packageļ¼
https://cloud.baidu.com/doc/PALO/s/qkizg0xdw
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
