ConERR increase during local mysql server connection using sockets from ProxySQL
Venkatesh Duggirala
Hello Rene,
I have ProxySQL installed on the same machine as MySQL. Both of them are installed inside a docker.
I have set up proxySQL to use socket connection instead of TCP and I was able to run
without any issues in normal cases.
But when I am running, sysbench with higher threads (say eg: 2000),
I see big number increase in ConnERR
ProxySQL Admin> select ConnERR from stats_mysql_connection_pool;
+---------+
| ConnERR |
+---------+
| 2967 |
+---------+
1 row in set (0.00 sec)
which I do not see increased if proxySQL is connected using TCP (ip address and port).
When I see in proxysql error logs, all I see is these errors in hundreds,
2022-10-09 06:06:38 mysql_connection.cpp:1063:handler(): [ERROR] Failed to mysql_real_connect() on 10:/etc/mysql.sock:0 , FD (Conn:2543 , MyDS:2543) , 2013: Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 22.
2022-10-09 06:06:38 mysql_connection.cpp:1063:handler(): [ERROR] Failed to mysql_real_connect() on 10:/etc/mysql.sock:0 , FD (Conn:2545 , MyDS:2545) , 2013: Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 22.
2022-10-09 06:06:38 mysql_connection.cpp:1063:handler(): [ERROR] Failed to mysql_real_connect() on 10:/etc/mysql.sock:0 , FD (Conn:2550 , MyDS:2550) , 2013: Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 22.
2022-10-09 06:06:38 mysql_connection.cpp:1063:handler(): [ERROR] Failed to mysql_real_connect() on 10:/etc/mysql.sock:0 , FD (Conn:2552 , MyDS:2552) , 2013: Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 22.
Could you please throw some light here and help me to understand what could be happening here ? Or any debugging tips to debug this issue why ConERR is increasing only for socket connection ?
Thanks in advance for your help,
regards,
Venkatesh.