win2k/IIS5/CF6.1 pro It seems (and I'm guessing here) that DWMX polls the CF webserver for avail dsn's using RDS over the LAN. Every so often, it has a heart attack and won't do it. It gets so bad that DWMX locks up entirely.
When that happens bad enough, none of the DSN's will verify in the CF admin, the pages start running slow, db connection timeouts start happening, etc. the webserver grinds to a halt and takes a minute or so to recover. now, I'm not sure whether it's DW fault that pushes CF over or the other way around. >> this page works fine (usually) << Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. >> but we're even getting errors in /cfide/administrator ! << Error Occurred While Processing Request A timeout occurred while attempting to lock cfadmin_sqlexecutive. The Error Occurred in D:\IISroot\Wwwroot\CFIDE\administrator\Application.cfm: line 158 and when it's as bad as this, even non-db (cfm) pages are slow to load or time out. >> It's (IMO) the JDBC-ODBC bridge, ie: the code that's connecting to Access...Ditch it. Get a decent database but we don't have these problems running ASP/MSAccess. I'd rather think it was crap JDBC drivers but I can't prove it. I'm now looking at modifying some of the settings for the dsn's. any idea which ones would help? -----Original Message----- From: Beattie, Barry Sent: Wednesday, 29 October 2003 1:04 PM To: CFAussie Mailing List Subject: [cfaussie] Re: CF webserver slows down - sometimes... Hi Paul >> It's (IMO) the JDBC-ODBC bridge, ie: the code that's connecting to Access...Ditch it. Get a decent database Hmmm... I've got 3 problems with this 1) these same websites are working fine on the localhost:8500 dev servers (every machine has one). The sites are being moved from localhost:8500 to one machine for "hosting" 2) the students are used to using MSAccess. it can be carried around on a floppy. there are zero issues with versioning, attach/detatch the db, etc. anything else is way overkill (besides you're saying that it isn't MSAccess at fault but the supplied JDBC driver) 3) you're not saying that CF has problems on something that ASP/IIS found easy to do, are you? Surely not..... any ideas on what to do to get to the bottom of this? debugging ideas? things to look for/try? thanx barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 5:22 PM To: CFAussie Mailing List Subject: [cfaussie] Re: CF webserver slows down - sometimes... On Tue, Oct 28, 2003 at 05:11:18PM +1000, Beattie, Barry wrote: > >> How big are they? > > most of these are only about 100-200kb. some with only 20-30 records (all > tables total) > > >> Do they need to be compacted? > > I'll try it but as I said before, we're getting timeouts even on the > cfide/administrator page. > > and why would it work one minute and not the next and then come good? > > I've noticed something strange. Using the performance monitor on all 3 of > our webservers produces a 97% "spike" in CPU resources. It looks like a > heartbeat - every 10 sec or so. The biggest spike is on the problem machine > (the others are lower). We've worked it back to JRun. any idea what it is? It's (IMO) the JDBC-ODBC bridge, ie: the code that's connecting to Access. It's evil. Ditch it. Get a decent database. We had the same sort of problems for ages, running a db via ODBC. The system would just seem to freeze for no apparent reason, inconsistently. Bit the bullet, moved to an external database accessible via JDBC drivers (PostgreSQL) and we haven't had a blip since. Paul Haddon Technical Services Manager Formstar Print Technologies --- 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/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
