[GitHub] [incubator-doris] EmmyMiao87 commented on pull request #5386: Support for AuthSwitchRequest In HandShakePacket to better support MySQL 8.0 clients

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org