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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
