Bug 1418256

Summary:	appliance_console backup restore fails with HA setup where pg_restore works fine
Product:	Red Hat CloudForms Management Engine	Reporter:	luke couzens <lcouzens>
Component:	Appliance	Assignee:	Gregg Tanzillo <gtanzill>
Status:	CLOSED DUPLICATE	QA Contact:	luke couzens <lcouzens>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	5.7.0	CC:	abellott, dajohnso, jhardy, ncarboni, obarenbo
Target Milestone:	GA
Target Release:	cfme-future
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	HA:black
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-05-03 18:18:08 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:

Description luke couzens 2017-02-01 11:46:38 UTC

Description of problem:Trying to restore local backup to HA db fails through appliance_console with 'Restore Failed', however running the same restore using 'pg_restore' works fine with no errors.


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


How reproducible:100%


Steps to Reproduce:
1.Setup HA env following [0]
2.Add provider
3.Backup db (pg_dump was my method)
4.Stop evm service to close connections to db
5.dropdb
6.createdb
7.launch appliance_console
8.select option 7 for restore

Actual results:Restore Fails


Expected results:Restore completes successfully


Additional info:
[0] https://access.redhat.com/documentation/en/red-hat-cloudforms/4.2/single/configuring-high-availability/

On a side note, to drop the db I had to stop/start rh-postgresql95-postgresql as it still had a connection open to the db. This could of been what was causing appliance_console restore to fail, whereas pg_restore could of just been ignoring this connection.

Comment 2 Nick Carboni 2018-05-03 18:18:08 UTC


*** This bug has been marked as a duplicate of bug 1561075 ***