we have a record in the act_ru_timer_job table
this record is past due and seemingly not being grabbed by flowable to be processed. we see the query to find jobs to execute looks like this:
from ACT_RU_TIMER_JOB RES
where SCOPE_TYPE_ is null
and DUEDATE_ <= $1
and LOCK_OWNER_ is null LIMIT $2 OFFSET $3
$1 being the current time and we are not able to find where $2 or $3 are coming from. The query correctly returns the record without the LIMIT and OFFSET filters. There is currently a high volume in ACT_RU_TIMER_JOB (10 million records). Do you think this is an issue with the volume never being able to get to this and many other records? What else could potentially cause a timer to not be triggered?