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

[Bryan Holladay]

QRTZ_FIRED_TRIGGERS is all I can remember.  I haven't done this in a
while, so I just wanted to make sure all references were covered.  You
can test it on a local by shutting down during a Quartz Job and
removing the trigger in the DB and starting it up and see if the job
started up again or not.

-Bryan

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"
>