Hi guys, We used to have this sort of problem here under 4.5. Problem was a firewall on the DB server. We changed the firewall rules to allow access to/from the DB to our CF boxes and all was fine after that. Not sure if this causing your problem, but this is the same behavious we experienced.
Cheers -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Stephen Bosworth Application Development and Integration Communication and Information Services The University of Newcastle, Australia Phone: 02 4921 6574 Fax: 02 4921 7087 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> [EMAIL PROTECTED] 28/10/2003 1:10:26 pm >>> Hi Taco, Mate, I do. that's where the log snippets come from at the bottom of the email. set for a warning after 20sec c:\cfusionmx\logs\server.log and from application.log (also shows jdbc timeout issues) "Error","jrpp-123","10/28/03","09:33:45","andes","Error Executing Database Query.SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The specific sequence of files included or processed is: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm " "Error","jrpp-124","10/28/03","09:37:36","andes","Error Executing Database Query.SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The specific sequence of files included or processed is: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm " "Error","jrpp-122","10/28/03","09:37:36","andes","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm " "Error","jrpp-126","10/28/03","09:37:36","andes","Error Executing Database Query.SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The specific sequence of files included or processed is: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm " "Error","jrpp-125","10/28/03","09:37:36","andes","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm " -----Original Message----- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 11:54 AM To: CFAussie Mailing List Subject: [cfaussie] RE: CF webserver slows down - sometimes... why dont you log slow pages? Its under cf admin. then look and see which page causes the problems? -----Original Message----- From: Beattie, Barry [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 10:22 AM To: CFAussie Mailing List Subject: [cfaussie] CF webserver slows down - sometimes... Hi all I'm asking for any advice on trying to get to the bottom of this. It's driving me nuts! we're getting stupid timeout errors that appear one minute/dissapear the next. I just checked it again and a page was taking over 5min to load but leave it for a minute and come back and it works blindingly fast. It's not IIS, I'm watching the taskmanager and all is fine (not working hard at all) and the asp pages aren't suffering this. so if anyone has any suggestions of what to specifically look for or try I'd appreciate it. thanx barry.b here's what I've found so far: calling pages: *.html/txt pages are fast *.cfm pages that have no cf code in them are fast *.cfm pages that access a db runs like a dog (with fleas) or times out -SOMETIMES!!! also, when using DW in design mode it's taking forever (plus with timeouts) for DWMX to call the CF server for the datasource schema's to be returned (using RDS over the LAN) so I'm thinking that the only connection between these 2 things are the databases and/or drivers and/or connections - almost all MSAccess db's and in most cases identical db's each with their own DSN. The code is good: 60% of the time it works fine (no errors, is fast, etc). But without warning everything slows down. here's something out of the logs "Warning","jrpp-122","10/28/03","09:23:46",,"Thread: jrpp-122, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 466 seconds, exceeding the 20 second warning limit" "Warning","jrpp-123","10/28/03","09:33:45",,"Thread: jrpp-123, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 758 seconds, exceeding the 20 second warning limit" "Warning","jrpp-124","10/28/03","09:37:36",,"Thread: jrpp-124, processing template: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm, completed in 974 seconds, exceeding the 20 second warning limit" "Warning","jrpp-126","10/28/03","09:37:36",,"Thread: jrpp-126, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 725 seconds, exceeding the 20 second warning limit" "Warning","jrpp-122","10/28/03","09:37:36",,"Thread: jrpp-122, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 792 seconds, exceeding the 20 second warning limit" "Warning","jrpp-125","10/28/03","09:37:36",,"Thread: jrpp-125, processing template: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm, completed in 805 seconds, exceeding the 20 second warning limit" --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to 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
