Help in figuring out why server keeps hanging... (many client POST"s)

Hi all,

Here is my situation. I am running an IIS 6 server on Windows 2003 and
MySQL.

The web site works great for many weeks, and then boom, the web site's
connection to the MySQL gets hung. The non-MySQL dependant web pages
come up just fine, but the ones accessing MySQL timeout.

In looking at the web log, there are 500-600 entries in about 20 seconds
from the same IP address trying to POST the same page to the site.

The page that is getting hammered back accesses the MySQL database.

Is there a coding problem that could be causing the client to post back
hundreds of times??

Any ideas what might be causing this, and more importantly how to keep
it from happening in the future?

Sample of log file:
2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
+SV1;+.NET+CLR+1.1.4322) 400 0 64
2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
+SV1;+.NET+CLR+1.1.4322) 400 0 64
2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
+SV1;+.NET+CLR+1.1.4322) 400 0 64
2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
+SV1;+.NET+CLR+1.1.4322) 400 0 64
2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
+SV1;+.NET+CLR+1.1.4322) 400 0 64

Re: Help in figuring out why server keeps hanging... (many client POST"s)

Please do not multi-post. Thread in microsoft.public.inetserver.iis


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//



On Feb 5, 8:14 am, ChuckRock wrote:
> Hi all,
>
> Here is my situation. I am running an IIS 6 server on Windows 2003 and
> MySQL.
>
> The web site works great for many weeks, and then boom, the web site's
> connection to the MySQL gets hung. The non-MySQL dependant web pages
> come up just fine, but the ones accessing MySQL timeout.
>
> In looking at the web log, there are 500-600 entries in about 20 seconds
> from the same IP address trying to POST the same page to the site.
>
> The page that is getting hammered back accesses the MySQL database.
>
> Is there a coding problem that could be causing the client to post back
> hundreds of times??
>
> Any ideas what might be causing this, and more importantly how to keep
> it from happening in the future?
>
> Sample of log file:
> 2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
> 80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
> +SV1;+.NET+CLR+1.1.4322) 400 0 64
> 2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
> 80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
> +SV1;+.NET+CLR+1.1.4322) 400 0 64
> 2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
> 80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
> +SV1;+.NET+CLR+1.1.4322) 400 0 64
> 2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
> 80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
> +SV1;+.NET+CLR+1.1.4322) 400 0 64
> 2007-01-29 18:27:35 W3SVC1 74.xxx.xxx.xxx POST /Restricted/Edit2.aspx -
> 80 - 198.xxx.xxx.xxx Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;
> +SV1;+.NET+CLR+1.1.4322) 400 0 64