Skip to content

Unable to parse unknown SET query from client 127.0.0.1:45954. Setting lock_hostgroup. Please report a bug for future enhancements:SET PROFILING = 1 #5061

@giveup

Description

@giveup

This is the place to report a reproducible bug, documentation error or feature request for ProxySQL.

Support questions will not be answered here. For community support, use the Google forum: https://groups.google.com/forum/#!forum/proxysql

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

  • A clear description of the issue
Unable to parse unknown SET query from client 127.0.0.1:45954. Setting lock_hostgroup. Please report a bug for future enhancements:SET PROFILING = 1
  • ProxySQL version
2025-07-31 14:34:16 [INFO] Using OpenSSL version: OpenSSL 3.5.1 1 Jul 2025
ProxySQL version 3.0.1-420-g2c26a42, codename Truls
  • OS version
CentOS Stream 9
  • The steps to reproduce the issue
I don’t know how to reproduce it; I just found it in the logs.
  • The full ProxySQL error log (default location: /var/lib/proxysql/proxysql.log)
2025-07-31 11:38:54 MySQL_Thread.cpp:3899:ProcessAllSessions_Healthy0(): [WARNING] Closing unhealthy client connection 127.0.0.1:55110
2025-07-31 11:39:24 MySQL_Thread.cpp:3899:ProcessAllSessions_Healthy0(): [WARNING] Closing unhealthy client connection 127.0.0.1:39676
2025-07-31 11:39:27 MySQL_Session.cpp:7918:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 127.0.0.1:45954. Setting lock_hostgroup. Please report a bug for future enhancements:SET PROFILING = 1
2025-07-31 11:41:42 MySQL_Thread.cpp:3899:ProcessAllSessions_Healthy0(): [WARNING] Closing unhealthy client connection 127.0.0.1:38848
2025-07-31 11:49:42 MySQL_Thread.cpp:3899:ProcessAllSessions_Healthy0(): [WARNING] Closing unhealthy client connection 127.0.0.1:34648

If this is a crashing bug, please also include:

  • The package used to install ProxySQL
  • The compressed proxysql binary
  • The compressed core dump (Note: if you're worried it may contain sensitive data, please contact us for information on sharing it securely: https://proxysql.com/contact-us/)

If the above information is not provided, this issue is likely to be closed.

Please use markdown to format any code or SQL: https://guides.github.com/features/mastering-markdown/

Thank you!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions