[Building Sakai] anybody know how to clear a stuck quartz job? [EVALSYS]

[Paul Dagnall]

Similar to what Chris posted, changing the state to WAITING


On Mon, Jun 18, 2012 at 1:41 PM, Charles Hedrick <hedrick at rutgers.edu>wrote:

> executing
>
> On Jun 18, 2012, at 1:39 PM, Paul Dagnall <pdagnall1 at udayton.edu> wrote:
>
> For stuck Turn-It-In issues, I have just deleted the record from
> QRTZ_FIRED_TRIGGERS, but in that case I wasn't as concerned with duplicity
> if that didn't really kill it. What is in the STATE column in the offending
> record?
>
> Paul Dagnall
> Application Developer & Administrator
> University of Dayton
>
>
> On Mon, Jun 18, 2012 at 1:27 PM, Maurer, Christopher Wayne <
> chmaurer at iupui.edu> wrote:
>
>> This doesn't really help with your immediate problem, but I'll probably
>> try to get this applied in trunk sometime soon.
>> https://jira.sakaiproject.org/browse/SAK-21425 (Need a way to see running
>> jobs and have ability to kill them.)
>>
>> Chris
>>
>> On 6/18/12 1:23 PM, "Bryan Holladay" <holladay at longsight.com> wrote:
>>
>> >I will defer this to someone else on the list then since I haven't
>> >done this w/o restarting (or even know if it's possible).
>> >
>> >-Bryan
>> >
>> >On Mon, Jun 18, 2012 at 1:21 PM, Charles Hedrick <hedrick at rutgers.edu>
>> >wrote:
>> >> yes. restarting would be really hard at the moment.
>> >>
>> >> On Jun 18, 2012, at 1:19 PM, Bryan Holladay <holladay at longsight.com>
>> >>wrote:
>> >>
>> >>> I thought it requires clearing the fired triggers and any other
>> >>> references in the DB to that running job, then restarting.  Are you
>> >>> trying to do this w/o restarting?
>> >>>
>> >>> On Mon, Jun 18, 2012 at 12:59 PM, Charles Hedrick
>> >>><hedrick at rutgers.edu> wrote:
>> >>>> We're not getting emails sent by EVALSYS. I believe the problem is
>> >>>>that Quartz is stuck. QRTZ_FIRED_TRIGGERS shows
>>
>> >>>>org.sakaiproject.component.app.scheduler.ScheduledInvocationManagerImpl
>> >>>>.runner executing, with the fired time not changing. Is there a way to
>> >>>>clear this? Can I just clear the fired triggers table, or do we need
>> >>>>something more?
>> >>>>
>> >>>> _______________________________________________
>> >>>> sakai-dev mailing list
>> >>>> sakai-dev at collab.sakaiproject.org
>> >>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >>>>
>> >>>> TO UNSUBSCRIBE: send email to
>> >>>>sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> >>>>"unsubscribe"
>> >>
>> >_______________________________________________
>> >sakai-dev mailing list
>> >sakai-dev at collab.sakaiproject.org
>> >http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >
>> >TO UNSUBSCRIBE: send email to
>> >sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> >"unsubscribe"
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120618/85b436c6/attachment.html