Can't get client IPs when " [ERROR] Detected a broken connection during SET NAMES xx.xx.xx.xx

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

6k stars 976 forks source link

Can't get client IPs when " [ERROR] Detected a broken connection during SET NAMES xx.xx.xx.xx #3561

Open chanakagl opened 3 years ago

chanakagl commented 3 years ago

Hi,

I'm getting the following error and I can't figure out where the error is coming from,

MySQL_Session.cpp:2914:handler_again___status_CHANGING_CHARSET(): [ERROR] Detected a broken connection during SET NAMES on xx.xx.xx.xx , 3306 : 2019, Can't initialize character set (null) (path: compiled_in)

I've set mysql-verbose_query_error='true'; but no luck.

renecannao commented 3 years ago

Missing proxysql version , but checking the line number (2914) this seems to be proxysql 2.1.1 . We currently do not log which client is associated to that request, but it seems a reasonable feature request / improvement.

Can you provide the rest of the error log? Thanks

chanakagl commented 3 years ago

We are using ProxySql 2.0.7. Please find the attached Proxysql log. Proxysql.log.txt