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

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?


- Shilen

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


> 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
> select * from grouper_qz_fired_triggers where

MySQL [grouper]> select * from grouper_QZ_TRIGGERS where
*************************** 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
1 row in set (0.00 sec)

MySQL [grouper]> select * from grouper_QZ_FIRED_TRIGGERS where
Empty set (0.00 sec)



Archive powered by MHonArc 2.6.19.

Top of Page