ProxySQL - MySQL_Session.cpp:7954:unable_to_parse_set_statement

Dear community,

I am running proxysql 2.5.5-1.2.bullseye, I just see that one of my script is generating a lot of warning messages into our proxysql syslog.

Sep 18 10:34:27 server proxysql 2024-09-18 10:34:19 MySQL_Session.cpp:7954:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 192.168.1.1:39284. Setting lock_hostgroup. Please report a bug for future enhancements:/*!100100 SET @@MAX_STATEMENT_TIME=0.000000 */

the script use the following mysqldump command which lead to this log message :

mysqldump -h server -u user -ppassword database table --where="campaign_id = 10" >> result.sql

I don’t know if this is a bug or not. I did run a ngrep during the wuery I can see mysqldump command is sending commands which might lead to this log.

Any help appreciated.

Hello @romgo,
Have you searched through ProxySQL’s bug list for anything similar?

If you don’t find anything, I would report this issue over there so the ProxySQL team can take a look.

Hello,

thank you, but in my case has this is generated by mysqldump itself, I’m not sure how I can sort things out.

Yes, but you are sending this through proxysql and proxysql does not support this. You need to report this to them so they can fix proxysql. There isn’t anything you can do other than take your dumps without using proxysql, and connect directly to MySQL.

Thanks ! if anyone come accross this thread here ie the report : MySQL_Session.cpp:7954:unable_to_parse_set_statement · Issue #4677 · sysown/proxysql · GitHub