CF 4.5, Solaris 8, Oracle 8.1.7 w/native drivers, 5 threads max., restart if 4 threads are unresponsive. In the log files I've reviewed there are never more than 2 unresponsive threads. The unresponsive thread count increases and decreases as the threads timeout and later return.
I don't know about "database query timeouts" - I'll have to look into that. Anybody know if Oracle does that? Yes, I've reviewed the Allaire/MM document(s). The odd thing is that everything *appears* to be working fine, but the server is still restarting itself for no apparent reason, and crashing/freezing then needing a manual restart. thanks, Chris Norloff ---------- Original Message ---------------------------------- from: Jochem van Dieten <[EMAIL PROTECTED]> >Chris Norloff wrote: >> I've got a system with a lot of timeouts during queries. These timeouts are handled >and logged. >> >> We're having CFserver crashes/freezes with no correlated errors, except for a bunch >of timeouts (like 10 in the previous 6 hours). > >What CF version? What OS? What database? At how many unresponsive >threads do you restart? What is the maximum number of threads? Does your >database support query timeouts and do you use them? > >> Anybody have timeouts that are handled still crash/freeze the server? > >Did you check "ColdFusion Timeouts and Unresponsive Requests"? >http://www.macromedia.com/v1/Handlers/index.cfm?ID=21641&Method=Full > >Jochem > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists