Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cron Job errors not showing in logs #371

Open
autodidacticon opened this issue Dec 26, 2024 · 0 comments
Open

Cron Job errors not showing in logs #371

autodidacticon opened this issue Dec 26, 2024 · 0 comments

Comments

@autodidacticon
Copy link

A test cron_job was added to our crontab with intentionally faulty logic; the cron job calls a nonexistent stored procedure.

SELECT cron.schedule('process-updates', '10 seconds', 'CALL nonexistent_procedure()');

Failures are recorded in cron.job_run_details but there are no error / failure statements in the postgres server logs. It would be expected to see something like 'COMMAND failed'.

Our settings:

log_min_messages = warning
client_min_messages = warning
cron.log_min_messages = warning

What am I missing?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant