I've seen those log files grow before and not cause these performance
issues. Simply stop the CF services, rename it, then start the CF
service.
your server is indicating some issues with:
C:\Inetpub\wwwroot\carbs\stores\1\category.cfm
C:\Inetpub\wwwroot\carbs\stores\1\product1.cfm
C:\Inetpub\wwwroot\carbs\stores\1\sendlink.cfm,
I'd focus on these. SeeFusion should be indicating long running
queries coming from these. I'd bet there some SQL in there causing
issue. Adding a column to a table could do this, especially if the
table has some size to it and there is no index on the colmn and your
code is including the column in a WHERE clause. I'm not very familiar
with MySQL with regards to this though. Also look for any other
'third party' tag calls such as CFHTTP, CFFTP, custom tags, or even a
CFMAIL.
good luck
DK
On 7/2/06, Cameron Childress <[EMAIL PROTECTED]> wrote:
it would be a good idea to evaluate what errors are in that log.
also, I didn't see a respose to my post about how slow dns could
actually be causing the problem. did I miss your response, r are you
only trying one solution at a time?
On 7/2/06, Robert Reil <[EMAIL PROTECTED]> wrote:
> Removed the column in the table I added previously.
> Still following JRUN Hang pattern.
>
> Need to try making a new log file I guess but it wont let go.
> Any ideas?
>
> 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: Sunday, July 02, 2006 7:41 AM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] JRUN Hangs
>
> Cant rename that log as it's in use. Would have to stop/start and im still
> monitoring. Will wait to see if column removal will fix it.
>
> 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: Cody Wehunt [mailto:[EMAIL PROTECTED]
> Sent: Saturday, July 01, 2006 11:55 PM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] JRUN Hangs
>
> I think you should be able to remove the log and see what happens. Should
> not be an issue.
>
> Cody
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
> Sent: Saturday, July 01, 2006 3: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
> -------------------------------------------------------------
>
>
>
>
> -------------------------------------------------------------
> 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
> -------------------------------------------------------------
>
>
>
>
--
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]
-------------------------------------------------------------
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
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
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
-------------------------------------------------------------
