| Author |
 Topic  |
|
fav
Starting Member
Spain
7 Posts |
 Posted - 16 April 2002 : 11:41:08
|
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 |
|
|
fav
Starting Member
Spain
7 Posts |
Posted - 16 April 2002 : 12:00:39
|
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
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 12:03:51
|
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 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 April 2002 : 13:15:37
|
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 ?
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 April 2002 : 19:48:16
|
Looping code perhaps ? that will quickly throw CPU up to 100%
www.daoc-halo.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 April 2002 : 20:26:39
|
yes possibly, although in my experience it is normally dllhost that is the culprit but yes, non terminating loops will quickly crash the server.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 23:17:02
|
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 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 April 2002 : 23:19:38
|
| 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. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 April 2002 : 04:32:54
|
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.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 April 2002 : 04:40:28
|
| the bug is still present in the v3.3.03 download. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 April 2002 : 05:43:07
|
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 |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 17 April 2002 : 08:05:27
|
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 |
|
|
|
Topic |
|
Topic Locked
