Grouper Users - Open Discussion List

[Scott Koranda <>]

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