unkin/argocd-apps
3
0
Fork 0
Code Issues 7 Pull Requests 3 Actions Packages Projects Releases Wiki Activity

Enable hot_standby_feedback on the authentik postgres cluster #473

Merged
benvin merged 1 commits from benvin/authentik-hot-standby-feedback into main 2026-09-19 14:34:34 +10:00
Conversation 0 Commits 1 Files Changed 1
+4
unkin-agent commented 2026-09-19 13:56:12 +10:00
Member
Copy Link
Copy Source

Authentik serves multi-second API reads from the CNPG hot standbys. Those reads outlive max_standby_streaming_delay, so recovery cancels them with canceling statement due to conflict with recovery, which authentik surfaces as HTTP 500 — enough to break a terraform apply mid-run.

  • set hot_standby_feedback on so replicas report their oldest xmin to the primary and long reads stop being cancelled
  • SIGHUP reload only, no restart or switchover
  • retained-dead-tuple cost is negligible on a ~155MB database
Authentik serves multi-second API reads from the CNPG hot standbys. Those reads outlive `max_standby_streaming_delay`, so recovery cancels them with `canceling statement due to conflict with recovery`, which authentik surfaces as HTTP 500 — enough to break a terraform apply mid-run. - set `hot_standby_feedback` on so replicas report their oldest xmin to the primary and long reads stop being cancelled - SIGHUP reload only, no restart or switchover - retained-dead-tuple cost is negligible on a ~155MB database
unkin-agent added 1 commit 2026-09-19 13:56:12 +10:00
Enable hot_standby_feedback on the authentik postgres cluster
ci/woodpecker/pr/vector-test Pipeline was successful
Details
ci/woodpecker/pr/pre-commit Pipeline was successful
Details
ci/woodpecker/pr/kubeconform Pipeline was successful
Details
7d186a9b36 
Slow authentik reads served by a hot standby exhaust
max_standby_streaming_delay and are cancelled with "conflict with
recovery", surfacing as HTTP 500s.

- set hot_standby_feedback on (SIGHUP reload, no restart)
benvin merged commit 9535bad9bc into main 2026-09-19 14:34:34 +10:00
benvin deleted branch benvin/authentik-hot-standby-feedback 2026-09-19 14:34:34 +10:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
benvin (BenVincent) unkin-agent (Unkin Agent) unkinben (Ben Vincent)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: unkin/argocd-apps#473
Delete Branch "benvin/authentik-hot-standby-feedback"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?