There are a number of reasons why this sort of behaviour can happen outside of the db patch issues.
We found tighening all of our code and sticking to the recommended best practices for CFMX (var'ing variables, defining arguments ect. ) resolved a great deal of these. Most likely caus of handing is thread deadlocking, good archiecture can prevent these happening but they are very difficult to track down. Going over your code and making sure errors are trapped/prevented correctly and at a very granular level can also help with this. Not saying your not doing this but you do have to be really tight else you get issues with bigger apps. One bug we did have causing this issue was isdefined failing Here is a good link for this http://www.macromedia.com/support/jrun/ts/documents/4.0_unresponsive.htm I also wrote a monitor tool to log and report metric data (6.1 not J2EE at the moment, just working on that one) which gave us some clues as to what was going on. You can view a copy here http://210.54.149.108/server_monitor click on the coldfusion reports link for cf data and server reports for ram/cpu stuff. Ignore timeouts at 00 - just a bug, but looking we did have timeouts at 11am so I can inspect logs and find reason. Not to hard to chuck together if you need one. We also found we had an issue with isdefined function failing and return false results which caused us some issues, i recommend changing to structkeyexists instead. Hope this helps Grant -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sameer Kekade Sent: Tuesday, March 09, 2004 1:36 PM To: CFAussie Mailing List Subject: [cfaussie] Re: JRUN For COldfusion We have been facing similar problems lately. All I did was, applied the Hot fix for data source connection pooling. And kept my fingers crossed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Tuesday, 9 March 2004 10:57 AM To: CFAussie Mailing List Subject: [cfaussie] Re: JRUN For COldfusion 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 --- 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
