On Wed, 2002-07-31 at 19:09, Troy Hakala wrote: > I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads. > This morning, the server stopped accepting connections and gave me this > error: > > ERROR 1129: Host 'hostname' is blocked because of many connection errors. > Unblock with 'mysqladmin flush-hosts' > > flush-hosts worked and I increased the max_connect_errors from 10 to 1000 > to kind of prevent this in the future. But what causes this error? If you > read the comments on http://www.mysql.com/doc/B/l/Blocked_host.html it > seems that decreasing wait_timeout does cause this. Is there a bug in > mysql where it thinks that killing off sleeping threads is really a > connect error? I'm using 3.23.45, btw.
I'm not shure, but i think it is not a bug. I think a connection is only successfull when it is closed by the same entity who opened it. If it was mysql closing the connection, then it should increment its counter of connection_errors. It tells that someone opened a connection and did not close it. It's only an opinion. -- Diana Soares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
