citusdata / citusdata/pg_cron

pg_cron logs many errors when default_transaction_read_only on

Open
#270 0 comments 0 reactions 1 assignee Claimed by @marcocitus View on GitHub
enhancement
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

On managed service default_transaction_read_only is turned on when disk gets full. pg_cron then goes on to generate many logs due to attempting to execute `UPDATE`. This produces much logging in a scenario where logging would be best kept to a minimum

Ideally pg_cron would either explicitly set the transaction to writable or respect the default & back out

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.