Bug 1813371

Summary:	Persistent Postgres Upgrade using Gluster File PVs fails on Socket Issue [rh-postgresql10]
Product:	Red Hat Software Collections	Reporter:	Barbora Mikulova <bmikulov>
Component:	postgresql	Assignee:	Patrik Novotný <panovotn>
Status:	CLOSED ERRATA	QA Contact:	Vaclav Danek <vdanek>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	rh-postgresql10	CC:	databases-maint, hgomes, hhorak, mrobson, panovotn, pkubat, praiskup, rhel-cs-apps-subsystem-qe, vdanek
Target Milestone:	---	Keywords:	TestCaseProvided, ZStream
Target Release:	3.4
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:	rh-postgresql10-postgresql-10.12-2.el7	Doc Type:	No Doc Update
Doc Text:		Story Points:	---
Clone Of:	1696732	Environment:
Last Closed:	2020-03-26 12:28:08 UTC	Type:	---
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:	1696732
Bug Blocks:	1813215

Comment 4 Honza Horak 2020-03-18 08:53:43 UTC

Steps to reproduce outside of OpenShift:
1) #> yum -u install rh-postgresql96 rh-postgresql10
2) #> scl enable rh-postgresql96 -- postgresql-setup --initdb
3) #> scl enable rh-postgresql10 bash
4) bash# PGSETUP_PGUPGRADE_OPTIONS='-s /tmp' postgresql-setup --upgrade --upgrade-from=rh-postgresql96-postgresql

Actual results:
bash# PGSETUP_PGUPGRADE_OPTIONS=-s=/tmp postgresql-setup --upgrade --upgrade-from=rh-postgresql96-postgresql
 * upgrading from 'rh-postgresql96-postgresql.service' to 'rh-postgresql10-postgresql.service'
 * Upgrading database.
ERROR: pg_upgrade tool failed
ERROR: Upgrade failed.
 * See /var/lib/pgsql/upgrade_rh-postgresql10-postgresql.log for details.

Expected results:
bash# PGSETUP_PGUPGRADE_OPTIONS='-s /tmp' postgresql-setup --upgrade --upgrade-from=rh-postgresql96-postgresql
 * upgrading from 'rh-postgresql96-postgresql.service' to 'rh-postgresql10-postgresql.service'
 * Upgrading database.
 * Upgraded OK.
WARNING: The configuration files were replaced by default configuration.
WARNING: The previous configuration and data are stored in folder
WARNING: /var/opt/rh/rh-postgresql96/lib/pgsql/data.
 * See /var/lib/pgsql/upgrade_rh-postgresql10-postgresql.log for details.

Comment 9 errata-xmlrpc 2020-03-26 12:28:08 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2020:0980