Bug 1106547 (RHV_PG_95) - [RFE][Tracker]Support Postgresql 9.5
Summary: [RFE][Tracker]Support Postgresql 9.5
Keywords:
Status: CLOSED ERRATA
Alias: RHV_PG_95
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 3.5.0
Hardware: Unspecified
OS: Linux
high
high
Target Milestone: ovirt-4.2.0
: ---
Assignee: Eli Mesika
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On: 1459134 1470985 1470988 1470994
Blocks: 1106552 1492549
TreeView+ depends on / blocked
 
Reported: 2014-06-09 14:48 UTC by Allon Mureinik
Modified: 2019-05-16 13:06 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-05-15 17:36:09 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:
sherold: Triaged+
pstehlik: testing_plan_complete-

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHEA-2018:1488 0 None None None 2018-05-15 17:38:11 UTC

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
Note You need to log in before you can comment on or make changes to this bug.