Hi,
our MySQL server can handle 1000 connections. We have two JBoss instances.
Each configured with max. 100 connections in pool. furthermore we use php
which make on each call a connection to MySQL. After a while (some days) we
get this:
java.sql.SQLException
MESSAGE: Data source rejected establishment of connection, message from
server: "Host 'omaapache2.bln.de' is blocked because of many connection
errors. Unblock with 'mysqladmin flush-hosts'"
STACKTRACE:
java.sql.SQLException: Data source rejected establishment of
connection, message from server: "Host 'omaapache2.rz.de
' is blocked because of many connection errors. Unblock with 'mysqladmin
flush-hosts'"
I don't have any idea why this happens. We can connect to mysql from other
computer or directly to make 'mysqladmin flush-hosts'.
Can somebody give me some tips?
regards,
rafal