Bug 1106547 (RHV_PG_95)

Summary: [RFE][Tracker]Support Postgresql 9.5
Product: Red Hat Enterprise Virtualization Manager Reporter: Allon Mureinik <amureini>
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED ERRATA QA Contact: Lucie Leistnerova <lleistne>
Severity: high Docs Contact:
Priority: high    
Version: 3.5.0CC: emesika, lpeer, mperina, pstehlik, rbalakri, Rhev-m-bugs, scohen, srevivo, ylavi
Target Milestone: ovirt-4.2.0Keywords: FutureFeature, Performance, Tracking
Target Release: ---Flags: sherold: Triaged+
pstehlik: testing_plan_complete-
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-05-15 17:36:09 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1459134, 1470985, 1470988, 1470994    
Bug Blocks: 1106552, 1492549    

Description Allon Mureinik 2014-06-09 14:48:02 UTC 
Description of problem:
Postgres <= 9.2 has a limitation where non-key-field row updates block foreign key checks (this is the root cause for, e.g., bug 1077715).

This BZ is filed to track upgrading RHEVM's database to 9.3 (or higher) in order to prevent such bugs in the future, and allow creating foreign keys in such situations.

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

How reproducible:
100%

Steps to Reproduce:
1. echo "select version()" | psql -U engine -d engine
2.
3.

Actual results:
Current postgres version is 8.4:
"""

                                                     version                                                      
------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
"""

Expected results:
Postgres 9.3 or above.


Additional info:
See http://www.postgresql.org/docs/9.3/static/release-9-3.html, specifically secion 5.3.1.1 for details on the locking issue.
Comment 3 Oved Ourfali 2016-01-20 08:00:30 UTC 
Moving to RHEV-M Future, as RHEL7 won't contain a postgres version higher than 9.2.
Comment 7 Lucie Leistnerova 2017-11-02 10:57:55 UTC 
We still don't have any d/s build to test. Please move to ON_QA after proper build first created.
Comment 9 Lucie Leistnerova 2017-11-03 12:29:42 UTC 
Engine 4.2 is installed/upgraded with 9.5 postgres - rh-postgresql95 from software collections. It's installable and connectable. 
All issues will be reported as separate bugs.

verified in ovirt-engine-4.2.0-0.4.master.el7.noarch
Comment 10 RHV bug bot 2017-12-06 16:15:09 UTC 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[No external trackers attached]

For more info please contact: rhv-devops
Comment 11 RHV bug bot 2017-12-06 16:51:04 UTC 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[No external trackers attached]

For more info please contact: rhv-devops
Comment 12 RHV bug bot 2017-12-12 21:13:52 UTC 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[No external trackers attached]

For more info please contact: rhv-devops
Comment 13 RHV bug bot 2017-12-18 17:04:24 UTC 
INFO: Bug status (VERIFIED) wasn't changed but the folowing should be fixed:

[No external trackers attached]

For more info please contact: rhv-devops
Comment 16 errata-xmlrpc 2018-05-15 17:36:09 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/RHEA-2018:1488
Comment 17 Franta Kust 2019-05-16 13:06:26 UTC 
BZ<2>Jira Resync