Proxysql: The number of parameters in bound buffers differs from number of columns in resultset

Created on 15 Feb 2018  路  3Comments  路  Source: sysown/proxysql

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

Most helpful comment

Any update? I have the same problem on ProxySQL version 2.0.10.

All 3 comments

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.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

williamsantanamoip picture williamsantanamoip  路  17Comments

patrickdk77 picture patrickdk77  路  15Comments

nielsalkema picture nielsalkema  路  22Comments

ethaniel picture ethaniel  路  18Comments

tapuhi picture tapuhi  路  17Comments