citusdata / citusdata/pg_cron

Job scheduled form another cron job does not always start

Open
#362 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Cron job starts as planned, does some work and at the end schedules new cron jobs to start after 2 minutes.
Sometimes these additional jobs start executing and sometimes scheduled time goes by and jobs do not start.
I tried to set start time with 15, 20 minutes delay, but they still do not always start.

When cron expression is updated directly in cron.job table then job starts on time.
I suspect that it could be caching issue. Something from context of first job is used when sub-jobs are scheduled.
When job cron expression is updated manually then cache is invalidated and job is picked up.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.