1064: Reach limit of connections

[张建]

The ProxySQL version used is 2.4.0-3-g6fc9c45.

When ProxySQL is used to proxy StarRocks, the following error messages occasionally appear:

2024-10-09 08:54:08 mysql_connection.cpp:1063:handler(): [ERROR] Failed to mysql_real_connect() on 10:bi-olap-sr-ho03.idc1.fn:9030 , FD (Conn:97 , MyDS:97) , 1064: Reach limit of connections.

The number of connections in ProxySQL is configured as follows:

The number of StarRocks connections is set as follows:

Questions to ask:

1. How do you know the number of connections per user in ProxySQL?

2.from the screenshot above, the number of connections did not Reach the limit, why the emergence of Reach limit of connections?