Proxysql failing to set session variable

[krishmanoh]

MySQL_Session.cpp:3860:handler_status_WAITING_CLIENTDATASTATE_SLEEP___MYSQL_COM_QUERY_qpo(): [ERROR] Unable to parse query. If correct, report it as a bug: SET SESSION SQL_MODE='STRICT_TRANS_TABLES,PIPES_AS_CONCAT',SESSION INTERPRETER_MODE='INTERPRET_FIRST'

This is correct, not sure why proxysql fails to handle it. It works fine with a single session variable.

proxysql --version ProxySQL version 1.4.9-percona-1.1, codename Truls

This happens when using as part of jdbc url - this works when connecting directly to mysql.

"jdbc:mysql://172.32.10.5:3306/crud_demo_ad?jdbcCompliantTruncation=false&maxAllowedPacket=1024000&sessionVariables=sql_mode='STRICT_TRANS_TABLES,PIPES_AS_CONCAT',interpreter_mode='interpret_first'", "root", "xxxx");

[yakirgb]

Is it working without interpreter_mode='interpret_first'? Try: "jdbc:mysql://172.32.10.5:3306/crud_demo_ad?jdbcCompliantTruncation=false&maxAllowedPacket=1024000&sessionVariables=sql_mode='STRICT_TRANS_TABLES,PIPES_AS_CONCAT'", "root", "xxxx");

[krishmanoh]

Yes, it does.

[yakirgb]

interpreter_mode is parameter of MemSQL and not MySQL

[krishmanoh]

Does proxysql validate the session variables before passing it to the database?

[yakirgb]

See: https://github.com/sysown/proxysql/wiki/Multiplexing#not-handled-session-variables

[renecannao]

Closing. Thank you @yakirgb for the help