[ERROR] RECEIVED AN UNKNOWN COMMAND: 28 -- PLEASE REPORT A BUG

[rohitkeshwani07]

[ ] A clear description of your issue
This is reproducible when you prepare a statement, then in parallel you execute a MYSQL alter directly on MySQL server. Now if you try to execute your statement it sends an error. These queries are using binary protocol.

[ ] The version of OS and ProxySQL

2020-05-21 12:25:18 [INFO] ProxySQL version 2.0.12-38-g58a909a0
2020-05-21 12:25:18 [INFO] Detected OS: Linux 394dd4a190d8 4.19.76-linuxkit #1 SMP Fri Apr 3 15:53:26 UTC 2020 x86_64

[ ] Every step to reproduce the issue
step1: execute a prepare statement using PDO Connection and sleep for 20 seconds.
query was

select `payments`.* from `payments` where `payments`.`merchant_id` = ? order by `created_at` desc, `id` desc limit 9

step2: execute ALTER query on mysql directly

ALTER TABLE payments ADD COLUMN `company_pdassdan_verification_dhfdshsdasddgti` varchar(30) DEFAULT NULL;

step3: try executing your statement now. Error logs show,

2020-05-22 10:03:25 MySQL_PreparedStatement.cpp:386:update_metadata(): [WARNING] Updating metadata for stmt 6352 , user root, query select `payments`.* from `payments` where `payments`.`merchant_id` = ? order by `created_at` desc, `id` desc limit 9
2020-05-22 10:03:25 MySQL_Session.cpp:3338:handler(): [ERROR] RECEIVED AN UNKNOWN COMMAND: 28 -- PLEASE REPORT A BUG

mariaDB throws Packets out of order. Expected 1 received 65. Msg can be ignored check here

[ ] The FULL error log (not just the last few lines)
proxysql.log

[] TCP DUMP for the error
tcpdump_proxy.cap.zip

Wasn't able to analyse TCPDUMP but it can be related to issue 2021, where client is sending COM_RESET_CONNECTION to reset the connection faster

Thankyou