We have quite a bit of code to go through to find a place where a connection isn't closed
properly. Are you saying the un-closed connections causes IIS to crash? Is there some way
to monitor open connections?
From the MySQL side of things I am thinking about putting the following line in my.ini:
set-variable = max_connect_errors=999999999
If I understand the documentation correctly this will not solve the problem with IIS
crashing, but after IIS restarts, I will not have to flush hosts. Is this correct?
-----Original Message-----
From: SGreen@stripped [mailto:SGreen@stripped]
Sent: Thursday, July 29, 2004 11:20 AM
To: James Frankman
Cc: win32@stripped
Subject: Re: Host 'xxx.xxx.xxx.xxx' is blocked
I think you should also review your data access code and make sure that all of your
connections are being closed on every page. Just one page with a still open connection
can hang you up like this depending on how often it is called. Do not rely on the
garbage collector to close it for you.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"James Frankman" <jfrankman@stripped> wrote on 07/29/2004 01:13:04 PM:
> We have MySQL 4.0 running on our IIS web server. Occasionally, IIS
> crashes and after restarting the server, we get the error message:
>
> '' Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51
> Driver]Host 'xxx.xxx.xxx.xxx' is blocked because of many connection
> errors. Unblock with 'mysqladmin fulsh-hosts' "
>
> Other connections to MySQL work, only connections from IIS to MySQL
> fail until the MySQL service is restarted. I have not tried 'flush
> hosts' since at the time I wasn't familiar with the command, and I
> was under the gun to get our Intranet back up. Restarting MySQL was
> my quickest option
>
> A couple questions:
>
> 1. Is 'mysqladmin flush-hosts' equivelant to the mysql command 'flush hosts'?
> 2. How can I avoid this problem in the future?
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=1
>
