We had an issue where if we "enabled retrieval of long text" in our ODBC
settings through the CF administrator, certain queries that referenced a
'text' field would crash the Cold Fusion server to 99% CPU. As soon as we
would turn the setting back off and reboot, the server would execute those
queries fine. We had to increase the long text buffer size (same screen as
the last setting) to 300k characters so our records wouldn't get trimmed
like they were in it's default of 65k. Anyway, make sure none of your DSN's
have the "enable long text" checked on. That might be it.

Adam.


> -----Original Message-----
> From: Phillip B [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 12, 2002 1:29 PM
> To: CF-Talk
> Subject: HELP! CF 5 using 99% CPU
> 
> 
> Ok, I come in today and find that CF 5 server is running at 
> 99% CPU. I log into the server and finally get it to shut 
> down.  When I restarted CF it jumps right back to 99% CPU. 
> 
> I also screwed up and didn't get to pull the log files off 
> the server before I left for the weekend so the disk was full 
> and couldn't write any errors to the log file.
> 
> So this is my question. Where should I start looking to find 
> out what the heck is going on?
> 
> Phillip Broussard
> Tracker Marine Group
> 417-873-5957
> 
> 
> 
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to