Bug 1473103

Summary: [Docs][HA] Corrections to Reintroducing the Failed Node
Product: Red Hat CloudForms Management Engine Reporter: Dayle Parker <dayleparker>
Component: DocumentationAssignee: Dayle Parker <dayleparker>
Status: CLOSED CURRENTRELEASE QA Contact: Suyog Sainkar <ssainkar>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 5.8.0CC: hhudgeon, jhardy, obarenbo, ssainkar
Target Milestone: GA   
Target Release: cfme-future   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-07-21 01:51:47 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 Dayle Parker 2017-07-20 02:20:23 UTC
From an email from Jeff Watts.

Document URL: https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.2/html-single/configuring_high_availability/#reintroducing_the_failed_node

Suggestions for improvement: 
Corrections needed in the sql commands for 4.2 and 4.5 HA guides.

Additional information: 


The part where it discusses the recovery from the following error: "requested WAL segment 000000020000000000000004 has already been removed" has the problem. It took us a while before we figured it out. All of the sql commands are missing the final semi-colon.

The commands  in step ii:
 
# psql vmdb_production
vmdb_production=#select * from repl_nodes
vmdb_production=#delete from repl_nodes table where id = $cluster_node_id_of_failed node



They should all be appended with a ";".  Should be:
# psql vmdb_production
vmdb_production=#select * from repl_nodes;
vmdb_production=#delete from repl_nodes table where id = $cluster_node_id_of_failed node;

Comment 5 Dayle Parker 2017-07-21 01:52:35 UTC
Correction - the update is *now* live.