Bug 1445291 - [RFE] Monitor replication slots
Summary: [RFE] Monitor replication slots
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.8.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: 5.11.z
Assignee: Gregg Tanzillo
QA Contact: Jaroslav Henner
URL:
Whiteboard: black:replication:ha
: 1504999 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-04-25 12:40 UTC by Nick Carboni
Modified: 2023-09-07 18:52 UTC (History)
12 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-26 17:04:09 UTC
Category: Feature
Cloudforms Team: CFME Core
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Nick Carboni 2017-04-25 12:40:26 UTC
In some cases it is possible for PostgreSQL replication slots [1] to exist without having the changes they track consumed.

This can happen if a HA standby server fails and is not brought back online or if a global region database is not responding.

This is fairly simple to check for by inspecting the pg_replication_slots view's "active" column [2]. I'm suggesting that ManageIQ/CFME implement some monitoring for inactive replication slots and raise an event/notification if they persist for some set amount of time.

[1] https://www.postgresql.org/docs/9.5/static/warm-standby.html#STREAMING-REPLICATION-SLOTS
[2] https://www.postgresql.org/docs/9.5/static/view-pg-replication-slots.html

Comment 2 Nick Carboni 2017-11-13 19:08:41 UTC
*** Bug 1504999 has been marked as a duplicate of this bug. ***

Comment 6 dmetzger 2020-02-26 15:53:11 UTC
Opened GitHub Issue https://github.com/ManageIQ/manageiq-appliance/issues/274


Note You need to log in before you can comment on or make changes to this bug.