Grouper Users - Open Discussion List

[Shilen Patel <>]

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