Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] CHANGE_LOG_changeLogTempToChangeLog jobs stop running

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] CHANGE_LOG_changeLogTempToChangeLog jobs stop running


Chronological Thread 
  • From: Shilen Patel <>
  • To: Scott Koranda <>
  • Cc: grouper-users <>
  • Subject: Re: [grouper-users] CHANGE_LOG_changeLogTempToChangeLog jobs stop running
  • Date: Tue, 30 Apr 2019 01:13:31 +0000

There’s a known issue with quartz where jobs may get stuck in a BLOCKED
state. There’s a separate job whose purpose is to fix those (every 30
minutes). Maybe that got stuck too? Do you have anything else that’s
blocked?

To manually run the job that unblocks it:

groovy:000> loaderRunOneJob("OTHER_JOB_schedulerCheckDaemon")

It just basically changes the state from BLOCKED to WAITING for anything that
is not currently firing (i.e. actually blocked). Does that fix the problem?

Thanks!

- Shilen

On 4/29/19, 8:53 PM, "Scott Koranda" <> wrote:

Hi,

> Are any of your other jobs (that run via the daemon) running correctly?

The only other daemon jobs would be the PSP-NG jobs that follow the
changelog. No, those jobs are not running correctly. They appear to have
stopped 5 days ago based on the last entries in grouper_loader_log.

> What do the quartz tables show?
>
> select * from grouper_qz_triggers where
trigger_name='triggerChangeLog_grouperChangeLogTempToChangeLog'
>
> select * from grouper_qz_fired_triggers where
trigger_name='triggerChangeLog_grouperChangeLogTempToChangeLog'

MySQL [grouper]> select * from grouper_QZ_TRIGGERS where
trigger_name='triggerChangeLog_grouperChangeLogTempToChangeLog'\G
*************************** 1. row ***************************
sched_name: DefaultQuartzScheduler
trigger_name: triggerChangeLog_grouperChangeLogTempToChangeLog
trigger_group: DEFAULT
job_name: CHANGE_LOG_changeLogTempToChangeLog
job_group: DEFAULT
description: NULL
next_fire_time: 1556569425000
prev_fire_time: 1556569365000
priority: 5
trigger_state: BLOCKED
trigger_type: CRON
start_time: 1551790380000
end_time: 0
calendar_name: NULL
misfire_instr: 0
job_data:
1 row in set (0.00 sec)

MySQL [grouper]> select * from grouper_QZ_FIRED_TRIGGERS where
trigger_name='triggerChangeLog_grouperChangeLogTempToChangeLog'\G
Empty set (0.00 sec)

Thanks,

Scott





Archive powered by MHonArc 2.6.19.

Top of Page