If you have jrun hangs and you're using AbleCommerce make SURE you're using the latest build. The older builds had some serious SQL locking issues. If your threads are going up to the max and just hanging, it most likely means they're all waiting on 1 thread which is locked on your database.
If you're using MS SQL Svr go to the enterprise admin and look at your threads. You'll most likely see a bunch of them all waiting for this one blocking thread. If you kill that thread your server will 'unclog' itself. We had this issue last year and it took some serious work, running SQL profiler etc to find the source of the problem and have able commerce fix it. We are currently running CFMX 5.5 build 1357 and the problem has largely gone away. Leon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Saturday, July 01, 2006 2:40 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] JRUN Hangs It hung again. --------------- 14:35:12 Begain to stack up It stacked up to 10 at max 15:05:47 Let go of the next one to bring it to 9 15:11:58 que back to Zero (0) Server Log view: http://www.motorcyclecarbs.com/remove.me/060701_1525_CFAdminSrvLog1.htm http://www.motorcyclecarbs.com/remove.me/060701_1525_CFAdminSrvLog2.htm 14:35 correlates to this error on Log2 ------------------------------------------------- Date Time Severity ThreadID Application Name Jul 1, 2006 2:36 PM Warning 0 [Not listed] ------------------------------------------------- Thread: jrpp-62, processing template: C:\Inetpub\wwwroot\CFIDE\administrator\logviewer\searchlog.cfm, completed in 93 seconds, exceeding the 20 second warning limit ------------------------------------------------- I don't think that is it though. However! Z:\CFusionMX\runtime\logs\default-err.log is 101MB! Could this be relevant? Could the server be taking 20 mins to parse this??? If it is what is pulling it? How do I archive it? Where are the settings? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -----Original Message----- From: Robert Reil [mailto:[EMAIL PROTECTED] Sent: Saturday, July 01, 2006 12:53 PM To: discussion@acfug.org Subject: [ACFUG Discuss] JRUN Hangs: (Was:Slow Site Starting on Reboot) Could adding a column to a table do this? I didn't think about that. Gosh I really wish I knew what I was doing... :( ------------------ Report: 12:49:00 Update: Since the last report all has been well until. At 11:59:06 the request query started stacking up. At 12:00:49 the requests hit limit of 10 At 12:18:01 the first of the 10 was processed stating 1,135,313ms transpired By 12:20:12 a que qty of 9~10 went back and forth only processing 6 requests At 12:28:50 the que decreased from 10 to 9 and slowly declined At 12:34:49 the que balance returned to 0 Its: 12:49:00 and the balance is still 0 and processing requests between 200~2000ms each. Note this is a report from my last report which for convenience I will post here. ----------------- Report: 9:57:28 Removed AVG. Rebooted. Services started. Viewed with seefusion. And looked at task manager. 4 requests hit (unprocessed) JRUN at 60-100% continuously Ran up to 10requests. Only 2 of them processed quickly. 10th one hit at 9:25:50am JRUN holding 95~100% Started knocking them out of the processing que at 9:46:57am with 2 strings at 155,702ms Started processing users requests at 9:48:47 in a normal capacity. User requests average 30 seconds. Que steadily brought down to qty 3 at 9:54:48 Maintained 3 in que but processed request in approx 400ms till the request que was brought down to zero at 9:57:28. Maintaining que of zero steadily and JRUN use ZERO resources except for 30% spikes on a quick request as I assume it should be. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -----Original Message----- From: Dean H. Saxe [mailto:[EMAIL PROTECTED] Sent: Saturday, July 01, 2006 10:38 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Slow Site Starting on Reboot Have you modified the DB recently? I've seen bad SQL and/or DB changes that absolutely kill performance. Are you sure none of your code has a cartesian product from a bad join clause? See http:// en.wikipedia.org/wiki/Database and http://en.wikipedia.org/wiki/ Cartesian_product for a definition. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] "What difference does it make to the dead, the orphans, and the homeless, whether the mad destruction is wrought under the name of totalitarianism or the holy name of liberty and democracy? " --Gandhi Find out about my Hike for Discovery at www.fullfrontalnerdity.com/hfd/ On Jul 1, 2006, at 10:02 AM, Robert Reil wrote: > Removed AVG. > Rebooted. > Services started. > Viewed with seefusion. > And looked at task manager. > > 4 requests hit (unprocessed) > JRUN at 60-100% continuously > Ran up to 10requests. > Only 2 of them processed quickly. > 10th one hit at 9:25:50am > JRUN holding 95~100% > Started knocking them out of the processing que at 9:46:57am with > 2 strings > at 155,702ms > Started processing users requests at 9:48:47 in a normal capacity. > User requests average 30 seconds. > Que steadily brought down to qty 3 at 9:54:48 Maintained 3 in que but > processed request in approx 400ms till the request que was brought > down to zero at 9:57:28. > Maintaining que of zero steadily and JRUN use ZERO resources except > for 30% spikes on a quick request as I assume it should be. > > Im now happy with it's performance but I wonder when and if it will > hang again. And I KNOW it will hang again for 20 mins if I reboot > again. > This behavior is duplicatable. > > Thanks for all your patience as I rambled, whined, and gave irrelevant > data. > LOL. > > Any direction from here? Seems all I have done is identified the > symptoms. > But without seefusion I would still be whining. > > Robert P. Reil > Managing Director, > Motorcyclecarbs.com, Inc. > 4292 Country Garden Walk NW > Kennesaw, Ga. 30152 > Office 770-974-8851 > Fax 770-974-8852 > www.motorcyclecarbs.com > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------