citusdata / citusdata/pg_cron

startup timeout after a certain amount of simultaneous jobs

Open
#282 4 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 some services which can be scheduled in pg_cron at the same time to be executed in a queue.
The function runs a shell script which does some file copy operations on fileservers; the amount of data can be up to some GB and thus take a while. Until now (over two years), this setting worked fine also when there were big amounts of data and thus the next job in the queue starting with a very long delay (once there were about 40 minutes).
Yersterday, I had first time 36 simultaneous jobs, four of them failed with "startup timeout" message, they started about 5 minutes later.
I recently upgraded pg_cron to postgresql-12-cron 1.5.2-1.pgdg110+1 (debian bullseye).
Can I get an information about the conditions of this startup timeout? Can I influence it?
Thank you in advance for an explanation,
Best, Elke

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.