Ben, our experience is that we always found solutions to server performance by looking closely at the Application and Server CF error logs. Looking at the detail you give here you appear to already be doing that. Unknown exception and PCode errors are almost always related to memory corruption issues, the major cause being unlocked shared scope variables. If any Application, Server or Session scoped variables are being used all writes and reads need to be locked using CFLOCK. In this situation hunt the logs for any strings with the word "thread" or "threading". Whichever way you do this use the logs to identify the templates causing the issues and if they contain unlocked vars lock them.
Hth. Mike Brunt - CTO Webapper Services LLC http://www.webapper.com Downey CA Office 562.243.6255 "Making the NET Work" -----Original Message----- From: [EMAIL PROTECTED] [mailto:cf-talk@;sdsolutions.de] Sent: Sunday, November 03, 2002 7:18 AM To: CF-Talk Subject: Re: Debugging a Runaway CF5 Server? Hi Ben, two things I can mention we had on a similar problem: 1) After hours or searching, we found out, that a certain domain caused the problems. And on this web-site were 6 Dben connected. All MS-Access. At the end it turned out, that the developer of the web-site has made an sql-fault. In a "LIKE"-search he allowed a one character search. It was a full-text search and a lot people just searched for whatever reason only for: "a" or "o" or "u" And we had hundreds of searches like that. Plus the absolute number of searches exploded through the last weeks. We impleted a routine which doesn't allow this anymore. Since then, the box is fine. 2) It was days/weeks later another database of the same customer. He or his customers made extensive searching in one table he had over 100.000 records. He deleted almost all records (it was a log-table) and no longer used and after that everything works fine now. So watch out for DB-Problems especially with MS-Access. Do you use MS-Access ? Do you have in addition the latest MDAC ? I hope it might help. Uwe BK> I've got a dedicated server running a fairly busy application and about BK> once or twice a day, something is causing the Cold Fusion Server BK> (Version 5) to max out at 100% for about 30 minutes and then settle back BK> down again. While its maxxed out (P4 2Ghz Server), the server pages BK> respond only after 40-60 seconds making the website almost inoperable. BK> A simple restart of the CF Service solves the issue. BK> I'm wondering while the server is "maxxing" , is there a way to look at BK> what each thread is handling at that time to see which template caused BK> the runaway problem? I realize this also could be a bug that's being BK> triggered similar to the zero-byte email bug, but since the server BK> resolves itself after 20-30 minutes, I doubt its that. BK> I've thrown on some CFERROR tags and am cleaning up any rogue BK> code/errors that seem to be cropping up, but so far the maxx out beast BK> hasn't reared its ugly head. BK> Recently I noticed the odd PCODE error popping up occassionaly on BK> different templates if that's useful at all (see below)...on all the BK> servers I run we don't get these types of errors. Does anyone have set BK> "best practice" at hunting down these sorts of runaway server problems? BK> Most of the time we can narrow it down to an infinite loop but its odd BK> that the CFServer doesn't kill this runaway process after the 60 second BK> execution limit so I'm thinking it could be a known bug. BK> Any help is appreciated. :D BK> PCODE Errors: BK> ============= BK> Diagnostics: BK> unknown exception condition BK> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag BK> The error occurred while processing an element with a general identifier BK> of (CFQUERY), occupying document position (45:2) to (45:105) in the BK> template file D:\WWW.blah.COM\PERSONAL\SELL_HISTORY.CFM. BK> Diagnostics: BK> unknown exception condition BK> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag BK> The error occurred while processing an element with a general identifier BK> of (CFQUERY), occupying document position (49:2) to (49:107) in the BK> template file D:\WWW.blah.COM\SEARCH\..\INCLUDES\GLOBAL_VARS.CFM. BK> Diagnostics: BK> unknown exception condition BK> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag BK> The error occurred while processing an element with a general identifier BK> of (CFQUERY), occupying document position (204:3) to (204:107) in the BK> template file D:\WWW.blah.COM\FUNCTIONS\PRNT_LISTING.CFM. BK> Diagnostics: BK> unknown exception condition BK> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag BK> The error occurred while processing an element with a general identifier BK> of (CFQUERY), occupying document position (84:2) to (84:120) in the BK> template file D:\WWW.blah.COM\FUNCTIONS\AUCTION_COMPLETE.CFM. BK> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
