bret at pectopah
Jun 30, 2008, 12:05 PM
Post #2 of 3
(298 views)
Permalink
|
|
Re: Need to cancel unexecuted publishing job
[In reply to]
|
|
Hi Chris. The easiest thing is to find the job in the job table, which
should be easy because its value for "executing" will be true.
Then you just set that value to f, which will effectively reset it, and
it'll run normally, and that will clear it out. See here:
http://wiki.bricolage.cc/bin/view/Bric/UsefulSQL#Delete_all_failed_jobs_1_8_5
(It's the second example. You should not need to delete any records.)
Hope this helps,
Bret
On Mon, 2008-06-30 at 11:52 -0700, Schults, Chris wrote:
> I just uploaded 600+ images using bric_media_upload, which worked fine.
>
> I then published them using bric_soap. We use bric_queued, so they all
> got added to the Jobs queue.
>
> During publishing, the bric_queued process got killed because it got too
> big.
>
> I restarted Bricolage and publishing resumed and finished. However,
> there is one job that is stuck on Distribute and I can't cancel it via
> the UI. When I try, I get, 'Cannot cancel "Distribute
> "trickortreaters.gif" to "Web"" because it is currently executing.'
>
> I created another publish job for this asset, which seemed to execute
> fine, but it did not clear the stuck one as I hoped.
>
> This was probably the job being executed when bric_queued got killed. I
> assume I need to delve into the database. If so, any suggestions for
> what I should do exactly?
>
> Thanks,
>
> Chris
>
> --------------------------------
>
> Chris Schults
> Web Developer
> PCC Natural Markets
> 206-547-1222 x104
> chris.schults[at]pccsea.com
> http://www.pccnaturalmarkets.com
>
> Sign up for PCC Fresh, a monthly newsletter filled with seasonal
> recipes, exciting new products, and more:
> http://www.pccnaturalmarkets.com/enews
>
>
>
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
>
--
Bret Dawson
Producer
Pectopah Productions Inc.
(416) 895-7635
bret[at]pectopah.com
www.pectopah.com
|
