Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 inetinfo.exe & dllhost.exe eat up my processors..!
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

fav
Starting Member

Spain
7 Posts

Posted - 16 April 2002 :  11:41:08  Show Profile
I just installed the forum on a 2 processor machine running W2K and SQL Server2K. I had a few issues at installation time but finally (using these forums!) I got to set up everything set.
BUT...
When I click on the members link on top of the page and then click on one of the users to view the user profile all of the sudden these two processes start taking CPU until they reach the 100% of the two processors that I have. dllhost.exe can be killed, but does not help. As inetinfo goes, there's no way to kill it!

Please, can anybody help us....

Fernando

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 April 2002 :  11:56:20  Show Profile  Send ruirib a Yahoo! Message
How many members do you have?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

fav
Starting Member

Spain
7 Posts

Posted - 16 April 2002 :  12:00:39  Show Profile
I never had more than three. I went to test everything before going life and this I what I found from the first time I tried.
By the way, we're using IIS5

Fernando

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 April 2002 :  12:03:51  Show Profile  Send ruirib a Yahoo! Message
Ok, I'm just guessing here, but I'm on lucky streak today ().
What driver are you using? Please post your connection string.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 April 2002 :  13:15:37  Show Profile  Visit HuwR's Homepage
I have never heard of inetinfo doing this it normally only barely touches the processor, do you have any ASP components or ISAPI filters installed, what does the SQL do to the processors ?

Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 16 April 2002 :  19:48:16  Show Profile  Visit Gremlin's Homepage
Looping code perhaps ? that will quickly throw CPU up to 100%

www.daoc-halo.com
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 April 2002 :  20:26:39  Show Profile  Visit HuwR's Homepage
yes possibly, although in my experience it is normally dllhost that is the culprit but yes, non terminating loops will quickly crash the server.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 April 2002 :  20:35:39  Show Profile
I am pretty sure that this is caused by a bug in the forum, see here:

http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=13799
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 April 2002 :  23:17:02  Show Profile  Send ruirib a Yahoo! Message
Sorry to ask Richard, but what bug would it be?

This is probably not the right place, but I found the explanation given in that post, for that specific problem rather unconvincing. I've never experienced anything similar to that situation. I always managed to use the columns in a recordset in a manner that I pleased, regardless of their order in the SELECT statement.

Couldn't that specific problem have to do with some ODBC driver bug? Does that happen with an OLEDB driver? Changing the cursor type used for that recordset wouldn't eliminate the problem (I've been think about doing this for quite a while but I'm not able to reproduce that error)?



-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 April 2002 :  23:19:38  Show Profile
It's specific to SQL Server. The TEXT fields must come at the end of the SELECT Statement. But M_SIG (which is a nvarchar field) is at the end.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 April 2002 :  23:24:39  Show Profile  Send ruirib a Yahoo! Message
I see. Thanks for the info.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 17 April 2002 :  01:55:22  Show Profile
I believe the blob field error is only present on certain ado versions. Here's a ms kb article on this subject.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175239


======
Doug G
======
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 17 April 2002 :  04:32:54  Show Profile  Visit HuwR's Homepage
Well that's a bit odd, since I have experienced this problem using mdac2.6, since my server has never seen a version earlier than that, so I'm not sure their info is entirely correct.

So, I would still follow the orderring guidlines when writing the SQL, I thought we had fixed all these anyway.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 17 April 2002 :  04:40:28  Show Profile
the bug is still present in the v3.3.03 download.
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 17 April 2002 :  05:43:07  Show Profile  Visit Gremlin's Homepage
As an aside, if the zip file was updated as bugs are fixed or things changed it might prevent a lot of these same topics asking for help over and over again and people just refering them to a post to fix it themselves ?

An example would be post.asp and the errors with adding members to private forums, these known bugs with fixes really should be incorporated into the base download as they're identified and fixed.

Rant off, flame suit back on.

www.daoc-halo.com
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 17 April 2002 :  08:05:27  Show Profile
quote:

As an aside, if the zip file was updated as bugs are fixed or things changed it might prevent a lot of these same topics asking for help over and over again and people just refering them to a post to fix it themselves ?

An example would be post.asp and the errors with adding members to private forums, these known bugs with fixes really should be incorporated into the base download as they're identified and fixed.

Rant off, flame suit back on.

www.daoc-halo.com



I don't think that this is a good solution - it will cause versioning problems. The solution I found to this was to use "patches" which are downloadable. The users just expand the distributed version and then the patches to overwrite the files.

I think it is a good idea to release a patch every 1-2 months to cover fixes (and keep a record of them) to get rid of those endless bug reports .


Think Pink
==> Start Internationalization Here
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.57 seconds. Powered By: Snitz Forums 2000 Version 3.4.07