Hi David, if you'er getting a lot of SQL errors then there's something wrong in the logic of the application, as it sounds like at various points the values it's sending to the SQL queries are invalid (if it was just the SQL itself you'd be getting the errors 100% of the time).
The other thing is that locking is essential - I wouldn't rely on the automatic read locking to be enough for your setup - every access of a shared scope variable should be properly locked. cheers, Toby Tuesday, January 14, 2003, 3:51:29 PM, you wrote: DL> Thanks for your reply, DL> I'm still battling with stability of CF5. DL> Some more info: DL> Yesterday was a pretty typical day for our 3 servers. DL> For example servers2: DL> * Served 1.3 million hits. DL> * Had 557 entries in application.log (lots of SQL DL> errors). DL> * Coldfusion restarted 42 times. DL> I'm not sure about how the applications do locking but DL> we have "Single Threaded Sessions" ticked and DL> "Automatic read locking" for Server, Application and DL> Session. DL> Simultaneous Requests are limited to 20 and Restart DL> after unresponsive requests is also 20. DL> Enforce strict validation is ticked, and template DL> cache size is 2048. DL> I'm a sysadmin not a CF guru so any thoughts are DL> appreciated. DL> David DL> --- Robin Hilliard <[EMAIL PROTECTED]> wrote: >> David, >> >> Hate to point out the obvious but for starters >> Redhat 7.2 is not a supported >> CF5 platform. The Linux versions listed in the >> system requirements are: >> >> Red Hat Linux 6.2, 7.0 (Personal or Professional) - >> SuSE Linux 7.0 (Personal >> or Professional) - Cobalt Qube, RaQ 3, 4, XTR >> >> CF5 was only tested on these versions. That said >> >> - Is your applicaton log empty? >> - Are you following locking best practices? >> - What is your "restart at X unresponsive requests" >> set to? >> >> Cheers, >> >> -- >> >> Robin Hilliard >> Technical Sales Engineer - Australia/New Zealand >> Certified Advanced Cold Fusion 5 Developer >> Macromedia, Inc. >> >> Mobile: +61 (0)418 414 341 >> >> "David Lutz" <[EMAIL PROTECTED]> wrote in message >> news:21393@cfaussie... >> > >> > In our setup we have a couple of CF5 servers >> running >> > on RedHat7.2 talking to 2 database servers, DB2 >> and >> > MySQL. We also have a staging server only >> available >> > to the office. >> > >> > How many times should the coldfusion process be >> > restarting per day on these servers? >> > >> > On the server with no load cf runs for weeks >> without >> > restarting but on one of our busy servers we see >> this: >> > >> > "Information","1024","12/17/02","20:28:27",,"The >> > ColdFusion Application Server started." >> > >> > in the file server.log at least 20 times a day. >> > >> > Is this something to be concerned about? >> > >> > David DL> http://movies.yahoo.com.au - Yahoo! Movies DL> - What's on at your local cinema? DL> --- DL> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] DL> To unsubscribe send a blank email to [EMAIL PROTECTED] DL> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
