Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1490936

Summary: automatic postgres upgrade fails on remote db
Product: [oVirt] ovirt-engine Reporter: Lucie Leistnerova <lleistne>
Component: Setup.CoreAssignee: Simone Tiraboschi <stirabos>
Status: CLOSED CURRENTRELEASE QA Contact: Lucie Leistnerova <lleistne>
Severity: high Docs Contact:
Priority: unspecified    
Version: 4.2.0CC: bugs, lsvaty, sbonazzo
Target Milestone: ovirt-4.2.0Keywords: Regression
Target Release: 4.2.0Flags: rule-engine: ovirt-4.2+
rule-engine: blocker+
sbonazzo: devel_ack+
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-12-20 11:26:26 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Integration RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1459134    

Description Lucie Leistnerova 2017-09-12 14:10:40 UTC
Description of problem:
Upgrade engine to 4.2 with remote postgres 9.2 fails while trying to connect to local db.

Version-Release number of selected component (if applicable):
ovirt-engine-setup-4.2.0-0.0.master.20170911195522.git5ddba50.el7.centos.noarch

How reproducible: always


Steps to Reproduce:
1. have engine 4.1 with remote postgres 9.2 database
2. try to upgrade to 4.2 with automatic postgres upgrade


Actual results: engine-setup fails with 
[ ERROR ] Failed to execute stage 'Misc configuration': could not connect to server: No such file or directory
         	Is the server running locally and accepting
         	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Expected results: don't offer automatic upgrade with remote db or fix the upgrade script that it can be done remotely

Comment 1 Red Hat Bugzilla Rules Engine 2017-09-12 14:44:07 UTC
This bug report has Keywords: Regression or TestBlocker.
Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP.

Comment 2 Lucie Leistnerova 2017-09-19 12:20:55 UTC
engine-setup fails with error Please upgrade engine PostgreSQL server to 9.5.7 and retry. Automatic upgrade is not offered.

verified in ovirt-engine-setup-4.2.0-0.0.master.20170918173214.git7183359.el7.centos.noarch

Comment 3 Sandro Bonazzola 2017-12-20 11:26:26 UTC
This bugzilla is included in oVirt 4.2.0 release, published on Dec 20th 2017.

Since the problem described in this bug report should be
resolved in oVirt 4.2.0 release, published on Dec 20th 2017, it has been closed with a resolution of CURRENT RELEASE.

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