proxysql:2.5.3 "2024-12-16 19:02:16 MySQL_Session.cpp:7861:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 10.152.170.121:60142. Setting lock_hostgroup. Please report a bug for future enhancements:SET SESSION cte_max_recursion_depth=1000000"

[Hitesh-Agrawal]

If you are submitting a reproducible bug report, please provide:

• Getting below error in ProxySQL Version 2.5.3 which is a proxy for backend MySQL AWS RDS with EngineVersion: 8.0.mysql_aurora.3.05.2
• [
• ProxySQL version :2.5.3

Config:
mysql_servers =
(
{ address="rds-cluster-XXXXXXX.cluster-ro-XXXXXXXXXXX.eu-central-1.rds.amazonaws.com", port=3306, hostgroup=10, max_connections=128 },
{ address="rds-cluster-XXXXXXX.cluster-XXXXXXXXXXX.eu-central-1.rds.amazonaws.com", port=3306, hostgroup=20, max_connections=128 },
)

mysql_query_rules =
(
{
rule_id=100
active=1
match_pattern="^SELECT .* FOR UPDATE"
destination_hostgroup=20
apply=1
},
{
rule_id=200
active=1
match_pattern="^SELECT ."
destination_hostgroup=10
apply=1
},
{
rule_id=300
active=1
match_pattern="^SHOW ."
destination_hostgroup=10
apply=1
},
{
rule_id=400
active=1
match_pattern=".*"
destination_hostgroup=20
apply=1
}
)

Error: "
2024-12-16 19:02:16 MySQL_Session.cpp:7861:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 10.152.170.121:60142. Setting lock_hostgroup. Please report a bug for future enhancements:SET SESSION cte_max_recursion_depth=1000000"