We've been having a major battle with this here as well. Of our roughly 40 sites running their own CF servers, 2 of them are regularly (almost every day) having this happen. No other sites are reporting this issue. All of our sites run CFMX6.1, with ODBC connections to an Informix datasource configured through the windows server ODBC control panel. Both of these sites host the CF and DB server of the same piece of server hardware. These servers are not performing any other duties besides these 2 functions. Both are highly speced, quality servers, not tarted up desktops. Neither are under an excessive load. Neither are running any CF code that isn't being run at a dozen other sites. It seems to be to do with using ODBC drivers instead of JDBC drivers, however changing over to JDBC is going to be a huge programming and an even bigger testing task. We've since been advised that using an ODBC connection to a db is not recommended in a production environment. (I must have missed that memo!)
We've also found that the services cannot be stopped and restarted, but what we have found is that you can end the jrun task via task manager and then restart the service. This saves doing a whole server reboot. We've also found that running CF in application mode rather than service mode gives some small increase in stability. (ie. run cfusionmx/bin/cfstart.bat instead of starting the service) We've been in constant touch with Macromedia support over this, and are yet to fully resolve it. We have tried _all_ the available relevant hotfixes, and none have made any difference. Here's our symptoms. Everything is running fine. Database queries start to take longer to process. Additional requests for db queries increase query response times. eg. a very simple query that normally takes 31ms, goes up to 450ms, then 995ms then over 10,000ms over the space of 10 to 20 minutes. Some longer queries _never_ return results. During this time, non db cf code runs at normal speeds and shows no signs of slowing down. The database is also responding normally if accessed directly (ie not via CF) After this escalates a little longer, the CF server dies completely and all requests (both db and non db) to it return a JRUN error: The server encountered an internal error and was unable to complete your request. JRun closed connection This error is displayed to any pages that started running before the server dies. A very slightly different error is displayed to pages that were requested to run after the server dies. I've analysed the IIS and CF server logs spanning some of these crashes, and nothing untoward seems to be happening. There is no unusual or even high server load. Pages are being run that were running successfully multiple times before during the same day. I'm stumped and I feel your pain Steve. I'm about to start recoding for JDBC drivers. Regards Darren Tracey > -----Original Message----- > From: Steve Onnis [mailto:[EMAIL PROTECTED] > Sent: Monday, 8 March 2004 11:33 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: JRUN For COldfusion > > > > It just sits there > > I have to end up rebooting the whole server cause if i try > and stop/start > the cf service it doesnt stop and errors. > > Steve > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Sean A > Corfield > Sent: Saturday, March 06, 2004 3:46 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: JRUN For COldfusion > > > On Mar 4, 2004, at 11:52 PM, Steve Onnis wrote: > > This probably links with my coldfusion process thread > > > > The jrun.exe every couple of days latly has been going to 100% and i > > dont > > know why. the same app has been running fine for the last 6 months > > and I > > want to know whats causing it > > Does it go to 100% and stay there or just it just spike to 100%? Could > it be database driver issues? Have you applied the hot fixes available > on macromedia.com? > > Regards, > Sean > > > --- > 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 > --- 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
