Server Errors??

[Logan]

Yash, can you comment on these errors I found in my log files from last night...

2004-04-02 10:07:15 61.25.50.22 - W3SVC405 FORM-TI1SWLDILP 64.156.223.130 80 GET /gallery/member.asp id=5681|139|80004005|[DBNETLIB][ConnectionRead_(recv()).]General_network_error._Check_your_network_documentation. 500 0 3962 514 0 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+98;+Win+9x+4.90) mydomain%2Ecom=RememberLID=1&LID=JJTT;+ASPSESSIONIDCSAQBCRB=NKGKJHNBGKPGAGJOBCDKCOHL [url="http://mydomain.com/myjeans/index.asp"]http://mydomain.com/myjeans/index.asp[/url]

2004-04-02 10:07:53 61.25.50.22 - W3SVC405 FORM-TI1SWLDILP 64.156.223.130 80 GET /index.asp |208|80004005|Cannot_open_database_requested_in_login_'<user_id>'._Login_fails. 500 0 5191 497 15 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+98;+Win+9x+4.90) mydomain%2Ecom=RememberLID=1&LID=JJTT;+ASPSESSIONIDCSAQBCRB=NKGKJHNBGKPGAGJOBCDKCOHL [url="http://mydomain.com/gallery/index.asp"]http://mydomain.com/gallery/index.asp[/url]

Time stamps in the log files are EST + 5 hrs so this occurred around 5:07 AM EST. I tlooks like an network or server level problem. Everything seemed to come back to normal at around 5:21 AM EST.

(I replaced my SQL server ID with "<user_ID>").

 

[Yash]

Hmm, can't say
There are a large number of open connections on the SQL server (I guess some people don't understand the importance of closing connections) and we are closing them out. I believe that is what may have caused this issue.

I'm trying to find out if the guys down at the datacenter were doing anything with our router and firewall as well during that time.

 

[Logan]

I should have also added this error:

2004-04-02 10:07:44 61.25.50.22 - W3SVC405 FORM-TI1SWLDILP 64.156.223.130 80 GET /myjeans/editprofile.asp |136|80004005|[DBNETLIB][ConnectionOpen_(Connect()).]SQL_Server_does_not_exist_or_access_denied. 500 0 3959 511 16093 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+98;+Win+9x+4.90) mydomain%2Ecom=RememberLID=1&LID=JJTT;+ASPSESSIONIDCSAQBCRB=NKGKJHNBGKPGAGJOBCDKCOHL [url]http://mydomain.com/myjeans/index.asp[/url]

Same timestamp rules apply (see above).

 

[Yash]

once we clear out the open connections, this should not reoccur.

 

[DirtBag]

is there any way you can check what sites are leaving connections open?

 

[Yash]

We will email you if your site leaves to many connections opened.

 

[DirtBag]

okay, so you can check which sites is leaving connections open?
is it possible to check which files too?

Is it just to ask at any time if connections are left open?
I am currently developing a website and this would be useful information


Or maybe better: How can i check this myself on my own local server?



many questions there, but I think that's it

 

[Stephen]

if you can login to Enterprise manager go to the process information.

 

[DirtBag]

cool!

Thank you