Bug 1622615

Summary:	Database replication stops working
Product:	Red Hat CloudForms Management Engine	Reporter:	Tasos Papaioannou <tpapaioa>
Component:	Appliance	Assignee:	Satoe Imaishi <simaishi>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Tasos Papaioannou <tpapaioa>
Severity:	high	Docs Contact:
Priority:	high
Version:	5.9.4	CC:	abellott, dmetzger, jrafanie, obarenbo, smallamp, tpapaioa
Target Milestone:	GA	Keywords:	Regression, TestOnly, ZStream
Target Release:	5.10.0
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:	5.10.0.14	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1623104 1626502 (view as bug list)		Environment:
Last Closed:	2019-02-12 16:53:17 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1623104, 1626502

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.