ProxySQL version 1.4.6 .
Investigate this error that sometimes happens after ALTER TABLE:
2018-02-02 18:24:34 MySQL_Session.cpp:2732:handler(): [ERROR] Detected a broken connection during query on (0,172.16.2.41,3306) , FD (Conn:239 , MyDS:239) : 2057, The number of parameters in bound buffers differs from number of columns in resultset
2018-02-02 18:24:50 MySQL_Session.cpp:2732:handler(): [ERROR] Detected a broken connection during query on (0,172.16.2.41,3306) , FD (Conn:86 , MyDS:86) : 2057, The number of parameters in bound buffers differs from number of columns in resultset
2018-02-02 18:24:52 MySQL_Session.cpp:2732:handler(): [ERROR] Detected a broken connection during query on (0,172.16.2.41,3306) , FD (Conn:248 , MyDS:248) : 2057, The number of parameters in bound buffers differs from number of columns in resultset
2018-02-02 18:25:13 MySQL_Session.cpp:2732:handler(): [ERROR] Detected a broken connection during query on (0,172.16.2.41,3306) , FD (Conn:260 , MyDS:260) : 2057, The number of parameters in bound buffers differs from number of columns in resultset
I have the same problem, when an ALTER TABLE was executed from the MySQL server, then in the Proxysql log it shows me those errors.
It will be that when executing the ALTER TABLE from the mysql directly (without going through the Proxysql), Proxysql does not know what is the correct structure of the table?
I have to execute ALTER TABLEs through Proxysql only?
I have 1.4.10 version.
Thanks
Any update? I have the same problem on ProxySQL version 2.0.10.
I am facing the same problem as well with laravel and proxysql 2.0.12. Let me know any leads. Can help debug this.
Most helpful comment
Any update? I have the same problem on ProxySQL version 2.0.10.