Bug 1622615 - Database replication stops working
Summary: Database replication stops working
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.9.4
Hardware: All
OS: All
high
high
Target Milestone: GA
: 5.10.0
Assignee: Satoe Imaishi
QA Contact: Tasos Papaioannou
URL:
Whiteboard:
Depends On:
Blocks: 1623104 1626502
TreeView+ depends on / blocked
 
Reported: 2018-08-27 15:30 UTC by Tasos Papaioannou
Modified: 2019-02-12 16:53 UTC (History)
6 users (show)

Fixed In Version: 5.10.0.14
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1623104 1626502 (view as bug list)
Environment:
Last Closed: 2019-02-12 16:53:17 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Comment 3 Joe Rafaniello 2018-08-27 18:46:41 UTC 
Preliminary research has me thinking we might need to rebuild the pglogical rpm against the latest scl postgresql.

5.9.4.3 had these versions:
cfme-5.9.4.3-1.el7cf.x86_64
rh-postgresql95-postgresql-9.5.9-4.el7.x86_64
rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64
rh-postgresql95-postgresql-pglogical-2.1.0-2.el7cf.x86_64
rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64

5.9.4.4 had these:
cfme-5.9.4.4-1.el7cf.x86_64
rh-postgresql95-postgresql-9.5.9-4.el7.x86_64
rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64
rh-postgresql95-postgresql-pglogical-2.1.0-2.el7cf.x86_64
rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64

5.9.4.5:
cfme-5.9.4.5-1.el7cf.x86_64
rh-postgresql95-postgresql-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-libs-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-pglogical-2.1.0-2.el7cf.x86_64
rh-postgresql95-postgresql-server-9.5.14-1.el7.x86_64

and 5.9.4.6:
cfme-5.9.4.6-1.el7cf.x86_64
rh-postgresql95-postgresql-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-libs-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-pglogical-2.1.0-2.el7cf.x86_64
rh-postgresql95-postgresql-server-9.5.14-1.el7.x86_64


We jumped from 9.5.9-4 to 9.5.14-1 in cfme 5.9.4.5.
Comment 4 Joe Rafaniello 2018-08-27 18:52:28 UTC 
According to https://github.com/2ndQuadrant/pglogical/issues/183

"It's an issue with the latest point release. You must ensure your logical decoding output plugins (pglogical, bdr, etc) are built with the same PostgreSQL point release as the running PostgreSQL. If you're running a plugin built on 10.4 on 10.5, it'll crash. Similarly, if you run a plugin built on 10.5 on 10.4, that'll crash too. This affects all the point releases not just 10.x."

Although, it's unclear why 9.5.9 to 9.5.14 would have this problem since it's a patch release, not a point release.
Comment 6 Joe Rafaniello 2018-08-27 21:32:41 UTC 
Thank you for rebuilding pglogical against the newer postgreql.  How confident are you that this fixed it? We're considering doing a test build of pglogical that basically rebuilds against the 9.5.14-1 postgresql that is now being shipped with scl.

Thanks.
Comment 10 Tasos Papaioannou 2018-09-07 13:48:50 UTC 
Verified on 5.10.0.14.
Note You need to log in before you can comment on or make changes to this bug.