Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
First Last Prev Next    This bug is not in your last search results.
Bug 1488630 - 03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "agent_user" violates not-null constraint
03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "ag...
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine (Show other bugs)
3.6.10
Unspecified Unspecified
high Severity high
: ovirt-4.2.0
: ---
Assigned To: Douglas Schilling Landgraf
Jiri Belka
:
Depends On:
Blocks: 1490089 1490090
  Show dependency tree / graph
 
Reported: 2017-09-05 18:15 EDT by Douglas Schilling Landgraf
Modified: 2018-05-15 13:45 EDT (History)
11 users (show)

See Also:
Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1490089 1490090 (view as bug list)
Environment:
Last Closed: 2018-05-15 13:43:37 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: Infra
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 3178621 None None None 2017-09-12 04:48 EDT
oVirt gerrit 81480 ovirt-engine-3.6 MERGED db: make sure values for fence_agents table are not null 2017-11-02 12:15 EDT
oVirt gerrit 81584 ovirt-engine-4.0 ABANDONED db: make sure values for fence_agents table are not null 2018-01-10 21:43 EST
oVirt gerrit 81585 ovirt-engine-4.1 MERGED db: make sure values for fence_agents table are not null 2017-09-27 05:29 EDT
oVirt gerrit 81641 master MERGED inventory: Check for pm ip set and not pm_user 2017-11-02 11:12 EDT
Red Hat Product Errata RHEA-2018:1488 None None None 2018-05-15 13:45 EDT

  None (edit)
Description Douglas Schilling Landgraf 2017-09-05 18:15:10 EDT 
Description of problem:

vds_static can have pm_user, pm_password and pm_type as NULL [1]
but fence_agents table won't accept [2] and might make upgrade from 3.5 to 3.6 fail in case there is null value.

psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "agent_user" violates not-null constraint

[1] https://github.com/oVirt/ovirt-engine/blob/af054c3cff9fe27f557175055007d8349cead8a4/packaging/dbscripts/create_tables.sql#L1345-L1347

[2] https://github.com/oVirt/ovirt-engine/blob/af054c3cff9fe27f557175055007d8349cead8a4/packaging/dbscripts/upgrade/03_06_0620_create_fence_agents_table.sql#L8-L10
Comment 8 rhev-integ 2017-11-02 09:38:04 EDT 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[Open patch attached]

For more info please contact: rhv-devops@redhat.com
Comment 9 rhev-integ 2017-11-02 17:08:17 EDT 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[Open patch attached]

For more info please contact: rhv-devops@redhat.com
Comment 11 Jiri Belka 2017-11-13 08:06:09 EST 
ok, ovirt-engine-4.2.0-0.0.master.20171112130303.git8bc889c.el7.centos.noarch
Comment 12 RHV Bugzilla Automation and Verification Bot 2017-12-06 11:16:01 EST 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[No relevant external trackers attached]

For more info please contact: rhv-devops@redhat.com
Comment 13 RHV Bugzilla Automation and Verification Bot 2017-12-12 16:14:35 EST 
INFO: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[No relevant external trackers attached]

For more info please contact: rhv-devops@redhat.com
Comment 14 RHV Bugzilla Automation and Verification Bot 2017-12-18 12:05:00 EST 
INFO: Bug status (VERIFIED) wasn't changed but the folowing should be fixed:

[No relevant external trackers attached]

For more info please contact: rhv-devops@redhat.com
Comment 18 errata-xmlrpc 2018-05-15 13:43:37 EDT 
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
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.