Hello, On Fri, May 10, 2024 at 12:00:17PM +0000, Iglesias Paz, Jaime wrote: > Hey guys, I have a problem with HAProxy and Galera Cluster v4 MySQL (3 > nodes). I boot the HAProxy server and it returns the following error: > > may 10 13:48:20 phaproxysql1 haproxy[661]: Proxy stats started. > may 10 13:48:20 phaproxysql1 haproxy[661]: Proxy stats started. > may 10 13:48:20 phaproxysql1 haproxy[661]: [NOTICE] 130/134820 (661) : New > worker #1 (663) forked > may 10 13:48:20 phaproxysql1 systemd[1]: Started HAProxy Load Balancer. > may 10 13:48:20 phaproxysql1 haproxy[663]: [WARNING] 130/134820 (663) : > Server galeramanagerprd/nodo1prd is DOWN, reason: Layer7 wrong status, code: > 1129, info: "Host 'XXXXX' is blocked because of many connection errors; > unblock> > may 10 13:48:21 phaproxysql1 haproxy[663]: [WARNING] 130/134821 (663) : > Server galeramanagerprd/nodo2prd is DOWN, reason: Layer7 wrong status, code: > 1129, info: "Host 'XXXXX' is blocked because of many connection errors; > unblock> > may 10 13:48:21 phaproxysql1 haproxy[663]: [WARNING] 130/134821 (663) : > Server galeramanagerprd/nodo3prd is DOWN, reason: Layer7 wrong status, code: > 1129, info: "Host 'XXXX' is blocked because of many connection errors; > unblock> > may 10 13:48:21 phaproxysql1 haproxy[663]: [NOTICE] 130/134821 (663) : > haproxy version is 2.2.9-2+deb11u6 > may 10 13:48:21 phaproxysql1 haproxy[663]: [NOTICE] 130/134821 (663) : path > to executable is /usr/sbin/haproxy > may 10 13:48:21 phaproxysql1 haproxy[663]: [ALERT] 130/134821 (663) : proxy > 'galeramanagerprd' has no server available! > > The haproxy.cfg configuration file: > .... > defaults > log global > mode http > option httplog > option dontlognull > timeout connect 5000 > timeout client 50000 > timeout server 50000 > errorfile 400 /etc/haproxy/errors/400.http > errorfile 403 /etc/haproxy/errors/403.http > errorfile 408 /etc/haproxy/errors/408.http > errorfile 500 /etc/haproxy/errors/500.http > errorfile 502 /etc/haproxy/errors/502.http > errorfile 503 /etc/haproxy/errors/503.http > errorfile 504 /etc/haproxy/errors/504.http > > listen galeramanagerprd > bind *:3306 > balance source > mode tcp > #option tcplog > option tcpka > option mysql-check user haproxy > server nodo1prd XXXXX:3306 check weight 1 > server nodo2prd XXXXX:3306 check weight 1 > server nodo3prd XXXXX:3306 check weight 1 > .... > > (*) for security I change the IPs to XXXXX > > Reviewing the documentation I can't find where the problem may be.
That reminds me of something a long time ago, where there was a limit on the number of check a mysql server would accept from a same IP address, and it was necessary to change the setting to unlimited. I don't remember the details but there was something to do using some insert commands. I don't know if this is still needed after all these years, but the error message strongly suggests something like this. Willy
