Bug 1391187

Summary: pglogical replication fails to start after migration from 5.5 to 5.7
Product: Red Hat CloudForms Management Engine Reporter: luke couzens <lcouzens>
Component: ApplianceAssignee: Nick Carboni <ncarboni>
Status: CLOSED CURRENTRELEASE QA Contact: luke couzens <lcouzens>
Severity: high Docs Contact:
Priority: unspecified    
Version: 5.7.0CC: abellott, cpelland, dajohnso, jhardy, obarenbo, simaishi
Target Milestone: GAKeywords: TestOnly
Target Release: 5.8.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: black:upgrade:migration
Fixed In Version: 5.8.0.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1395387 (view as bug list) Environment:
Last Closed: 2017-06-12 17:13:49 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:
Bug Depends On:    
Bug Blocks: 1395387    

Description luke couzens 2016-11-02 18:09:07 UTC 
Description of problem:pglogical replication fails to start after migration from 5.5 to 5.7


Version-Release number of selected component (if applicable):5.7.0.7


How reproducible:100%


Steps to Reproduce:
1.setup rubyrep on 2 x 5.5 appliances
2.stop replication
3.upgrade to 5.7 using repos[0] and yum update
4.upgrade postgres to latest using miq_postgres_upgrade script
5.make edits to relevant files for pglogical following [1]
6.setup pglogical

Actual results:replication fails to replicate


Expected results:replication works correctly


Additional info:
[0]https://mojo.redhat.com/docs/DOC-1094760
[1]https://mojo.redhat.com/docs/DOC-1089985
Comment 2 Nick Carboni 2016-11-03 13:46:52 UTC 
This failed because of a unique constraint violation during the initial sync for the pglogical subscription.

When a user moves from rubyrep to pglogical they should do a `bin/rake evm:dbsync:uninstall` *before* `yum update` to ensure all of the region's data is removed from the global.

Failing that I opened a PR to remove all of the region's data from the global region as a part of creating the subscription.

https://github.com/ManageIQ/manageiq/pull/12358
Comment 5 luke couzens 2017-03-06 12:39:53 UTC 
Verified in 5.8.0.3