thr3ads.net - Puppet users - [Puppet Users] Clearing delayed job failures in dashboard [Oct 2011]

If this information is useful, please help other people find it:
Share via:

Steven L. Seed

2011-Oct-28 18:32 UTC

[Puppet Users] Clearing delayed job failures in dashboard

<html>
  <head>

    <meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font color="#000000" size="3">I have a ton of
delayed job failures
      in my dashboard under background tasks. They are mostly failed
      imports of report yaml files that were deleted. There are over
      40000 of them so I can''t use the "Mark all as read"
button because
      it causes dashboard to hang forever. Anyone know how I can clear
      these from the command line?</font>
  </body>
</html>

<p></p>

-- <br />
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.<br />
To post to this group, send email to puppet-users@googlegroups.com.<br />
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.<br />

For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.<br />

Evgeny

2011-Oct-31 07:26 UTC

head link

[Puppet Users] Re: Clearing delayed job failures in dashboard

this will clean all reports, I don''t know how to clean only delayed
job failures but it may help

rake RAILS_ENV=production reports:prune upto=0 unit=day

On Oct 28, 9:32 pm, "Steven L. Seed" <slseed1...@gmail.com>
wrote:> I have a ton of delayed job failures in my dashboard under background
tasks. They are mostly failed imports of report yaml files that were deleted.
There are over 40000 of them so I can''t use the "Mark all as
read" button because it causes dashboard to hang forever. Anyone know how I
can clear these from the command line?
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Steven L. Seed

2011-Nov-01 16:48 UTC

head link

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard

I don''t think this will help. I do report cleanup daily to keep only
the
last 14 days and it hasn''t touched the number of delayed job failures 
reported.

On 10/31/2011 12:26 AM, Evgeny wrote:> this will clean all reports, I don''t know how to clean only
delayed
> job failures but it may help
>
> rake RAILS_ENV=production reports:prune upto=0 unit=day
>
> On Oct 28, 9:32 pm, "Steven L. Seed"<slseed1...@gmail.com> 
wrote:
>> I have a ton of delayed job failures in my dashboard under background
tasks. They are mostly failed imports of report yaml files that were deleted.
There are over 40000 of them so I can''t use the "Mark all as
read" button because it causes dashboard to hang forever. Anyone know how I
can clear these from the command line?
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Nigel Kersten

2011-Nov-01 18:58 UTC

head link

Re: [Puppet Users] Clearing delayed job failures in dashboard

On Fri, Oct 28, 2011 at 11:32 AM, Steven L. Seed
<slseed1969@gmail.com>wrote:
>  I have a ton of delayed job failures in my dashboard under background
> tasks. They are mostly failed imports of report yaml files that were
> deleted. There are over 40000 of them so I can''t use the
"Mark all as read"
> button because it causes dashboard to hang forever. Anyone know how I can
> clear these from the command line?
>
>''rake -T'' is very useful for looking for rake tasks.

# rake -T jobs
rake jobs:clear               # Clear the delayed_job queue.
rake jobs:work                # Start a delayed_job worker.

The first one looks like the one you want.

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Steven L. Seed

2011-Nov-01 21:27 UTC

head link

Re: [Puppet Users] Clearing delayed job failures in dashboard

Thanks Nigel, but I have already tried that. I originally used the
    ''rake jobs:clear'' command to clear out all pending delayed
jobs that
    had built up over time. That''s when they appeared in the
    "delayed_jobs_failures" list ie. "Background Task
Failures". My
    problem isn''t that there are delayed jobs pending, just that the
log
    of failed jobs is so large that I can''t clear them properly.  

    On 11/01/2011 11:58 AM, Nigel Kersten wrote:

      On Fri, Oct 28, 2011 at 11:32 AM, Steven
        L. Seed &lt;slseed1969@gmail.com&gt;
        wrote:

           I have a ton of delayed job failures in my
              dashboard under background tasks. They are mostly failed
              imports of report yaml files that were deleted. There are
              over 40000 of them so I can''t use the "Mark all as
read"
              button because it causes dashboard to hang forever. Anyone
              know how I can clear these from the command line? 

        ''rake -T'' is very useful for looking for rake tasks.

        # rake -T jobs

        rake jobs:clear               # Clear the delayed_job
          queue.

        rake jobs:work                # Start a delayed_job
          worker. 

      The first one looks like the one you want.

      -- 

      You received this message because you are subscribed to the Google
      Groups "Puppet Users" group.

      To post to this group, send email to
      puppet-users@googlegroups.com.

      To unsubscribe from this group, send email to
      puppet-users+unsubscribe@googlegroups.com.

      For more options, visit this group at
      http://groups.google.com/group/puppet-users?hl=en.

-- 

You received this message because you are subscribed to the Google Groups
"Puppet Users" group.

To post to this group, send email to puppet-users@googlegroups.com.

To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.

For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Nigel Kersten

2011-Nov-01 22:47 UTC

head link

Re: [Puppet Users] Clearing delayed job failures in dashboard

On Tue, Nov 1, 2011 at 2:27 PM, Steven L. Seed <slseed1969@gmail.com>
wrote:
>  Thanks Nigel, but I have already tried that. I originally used the
''rake
> jobs:clear'' command to clear out all pending delayed jobs that had
built up
> over time. That''s when they appeared in the
"delayed_jobs_failures" list
> ie. "Background Task Failures". My problem isn''t that
there are delayed
> jobs pending, just that the log of failed jobs is so large that I
can''t
> clear them properly.
>
That''s totally a bug then. Can you report it here please?

http://projects.puppetlabs.com/projects/dashboard/issues/new

Thanks Steven.

I''ll poke around and get someone to update your ticket with a
workaround.




>
>
>
> On 11/01/2011 11:58 AM, Nigel Kersten wrote:
>
>
>
> On Fri, Oct 28, 2011 at 11:32 AM, Steven L. Seed
<slseed1969@gmail.com>wrote:
>
>>  I have a ton of delayed job failures in my dashboard under background
>> tasks. They are mostly failed imports of report yaml files that were
>> deleted. There are over 40000 of them so I can''t use the
"Mark all as read"
>> button because it causes dashboard to hang forever. Anyone know how I
can
>> clear these from the command line?
>>
>>
>  ''rake -T'' is very useful for looking for rake tasks.
>
>  # rake -T jobs
> rake jobs:clear               # Clear the delayed_job queue.
> rake jobs:work                # Start a delayed_job worker.
>
> The first one looks like the one you want.
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To post to this group, send email to puppet-users@googlegroups.com.
> To unsubscribe from this group, send email to
> puppet-users+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/puppet-users?hl=en.
>
>
>

-- 
Nigel Kersten
Product Manager, Puppet Labs

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Evgeny

2011-Nov-03 12:10 UTC

head link

[Puppet Users] Re: Clearing delayed job failures in dashboard

then only it will help:

delete FROM `delayed_job_failures` WHERE 1

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Luke Bigum

2011-Nov-03 12:19 UTC

head link

[Puppet Users] Re: Clearing delayed job failures in dashboard

FYI this is a lot faster to delete everything from a MySQL table:

TRUNCATE TABLE delayed_job_failures;

On Nov 3, 12:10 pm, Evgeny <eokole...@gmail.com>
wrote:> then only it will help:
>
> delete FROM `delayed_job_failures` WHERE 1
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Nigel Kersten

2011-Nov-03 15:36 UTC

head link

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard

FWIW the bug was put in as:

https://projects.puppetlabs.com/issues/10442

(adding these comments to it)



On Thu, Nov 3, 2011 at 5:19 AM, Luke Bigum <Luke.Bigum@lmax.com> wrote:
> FYI this is a lot faster to delete everything from a MySQL table:
>
> TRUNCATE TABLE delayed_job_failures;
>
> On Nov 3, 12:10 pm, Evgeny <eokole...@gmail.com> wrote:
> > then only it will help:
> >
> > delete FROM `delayed_job_failures` WHERE 1
>
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To post to this group, send email to puppet-users@googlegroups.com.
> To unsubscribe from this group, send email to
> puppet-users+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/puppet-users?hl=en.
>
>

-- 
Nigel Kersten
Product Manager, Puppet Labs

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Steven L. Seed

2011-Nov-03 17:43 UTC

head link

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Thanks all. That worked.<br>
    <br>
    On 11/03/2011 08:36 AM, Nigel Kersten wrote:
    <blockquote
cite="mid:CAGUqgV9dqOjKtB=fUD2-Fe4C=Pdi3j1qQs6858b=SuiuWSgeTw@mail.gmail.com"
      type="cite">FWIW the bug was put in as:
      <div><br>
      </div>
      <div><a moz-do-not-send="true"
         
href="https://projects.puppetlabs.com/issues/10442">https://projects.puppetlabs.com/issues/10442</a></div>
      <div><br>
      </div>
      <div>(adding these comments to it)</div>
      <div><br>
      </div>
      <div><br>
        <br>
        <div class="gmail_quote">On Thu, Nov 3, 2011 at 5:19 AM,
Luke
          Bigum <span dir="ltr">&lt;<a
moz-do-not-send="true"
             
href="mailto:Luke.Bigum@lmax.com">Luke.Bigum@lmax.com</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex;">
            FYI this is a lot faster to delete everything from a MySQL
            table:<br>
            <br>
            TRUNCATE TABLE delayed_job_failures;<br>
            <div class="HOEnZb">
              <div class="h5"><br>
                On Nov 3, 12:10&nbsp;pm, Evgeny &lt;<a
moz-do-not-send="true"
                 
href="mailto:eokole...@gmail.com">eokole...@gmail.com</a>&gt;
                wrote:<br>
                &gt; then only it will help:<br>
                &gt;<br>
                &gt; delete FROM `delayed_job_failures` WHERE 1<br>
                <br>
                --<br>
                You received this message because you are subscribed to
                the Google Groups "Puppet Users" group.<br>
                To post to this group, send email to <a
                  moz-do-not-send="true"
                 
href="mailto:puppet-users@googlegroups.com">puppet-users@googlegroups.com</a>.<br>
                To unsubscribe from this group, send email to <a
                  moz-do-not-send="true"
                 
href="mailto:puppet-users%2Bunsubscribe@googlegroups.com">puppet-users+unsubscribe@googlegroups.com</a>.<br>
                For more options, visit this group at <a
                  moz-do-not-send="true"
                 
href="http://groups.google.com/group/puppet-users?hl=en"
                 
target="_blank">http://groups.google.com/group/puppet-users?hl=en</a>.<br>
                <br>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        Nigel Kersten<br>
        Product Manager, Puppet Labs<br>
        <br>
        <br>
      </div>
      -- <br>
      You received this message because you are subscribed to the Google
      Groups "Puppet Users" group.<br>
      To post to this group, send email to
      <a class="moz-txt-link-abbreviated"
href="mailto:puppet-users@googlegroups.com">puppet-users@googlegroups.com</a>.<br>
      To unsubscribe from this group, send email to
      <a class="moz-txt-link-abbreviated"
href="mailto:puppet-users+unsubscribe@googlegroups.com">puppet-users+unsubscribe@googlegroups.com</a>.<br>
      For more options, visit this group at
      <a class="moz-txt-link-freetext"
href="http://groups.google.com/group/puppet-users?hl=en">http://groups.google.com/group/puppet-users?hl=en</a>.<br>
    </blockquote>
    <br>
  </body>
</html>

<p></p>

-- <br />
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.<br />
To post to this group, send email to puppet-users@googlegroups.com.<br />
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.<br />

For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.<br />

Puppet users - Oct 2011 - Clearing delayed job failures in dashboard

[Puppet Users] Clearing delayed job failures in dashboard

[Puppet Users] Re: Clearing delayed job failures in dashboard

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard

Re: [Puppet Users] Clearing delayed job failures in dashboard

Re: [Puppet Users] Clearing delayed job failures in dashboard

Re: [Puppet Users] Clearing delayed job failures in dashboard

[Puppet Users] Re: Clearing delayed job failures in dashboard

[Puppet Users] Re: Clearing delayed job failures in dashboard

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard

Re: [Puppet Users] Re: Clearing delayed job failures in dashboard