citusdata / citusdata/pg_cron

Scheduling more than two jobs, starts failing with "job startup timeout"

Open
#253 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

I have Postgres15 with latest version of pg_cron installed.
I have created some stored procedures to update some data, these stored procedures can be executed fine with CALL public.procedure.
Scheduling with some minutes recurring one job to call one procedure is running fine.
Scheduling with some minutes recurring two jobs to call two procedures are running fine.
Scheduling with some minutes recurring three jobs to call three procedures are staring failing.
The error is "job startup timeout"

![image](https://user-images.githubusercontent.com/6669704/226371103-6ee2b1e7-4a50-45ba-8d75-0291b5acadef.png)

Any idea?

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.