Bug 1488630 - 03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "agent_user" violates not-null constraint
Summary: 03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "ag...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 3.6.10
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ovirt-4.2.0
: ---
Assignee: Douglas Schilling Landgraf
QA Contact: Jiri Belka
URL:
Whiteboard:
Depends On:
Blocks: 1490089 1490090
TreeView+ depends on / blocked
 
Reported: 2017-09-05 22:15 UTC by Douglas Schilling Landgraf
Modified: 2021-06-10 13:00 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1490089 1490090 (view as bug list)
Environment:
Last Closed: 2018-05-15 17:43:37 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 3178621 0 None None None 2017-09-12 08:48:17 UTC
Red Hat Product Errata RHEA-2018:1488 0 None None None 2018-05-15 17:45:35 UTC
oVirt gerrit 81480 0 ovirt-engine-3.6 MERGED db: make sure values for fence_agents table are not null 2017-11-02 16:15:10 UTC
oVirt gerrit 81584 0 ovirt-engine-4.0 ABANDONED db: make sure values for fence_agents table are not null 2018-01-11 02:43:04 UTC
oVirt gerrit 81585 0 ovirt-engine-4.1 MERGED db: make sure values for fence_agents table are not null 2017-09-27 09:29:36 UTC
oVirt gerrit 81641 0 master MERGED inventory: Check for pm ip set and not pm_user 2017-11-02 15:12:34 UTC

Description Douglas Schilling Landgraf 2017-09-05 22:15:10 UTC 
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 13:38:04 UTC 
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
Comment 9 rhev-integ 2017-11-02 21:08:17 UTC 
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
Comment 11 Jiri Belka 2017-11-13 13:06:09 UTC 
ok, ovirt-engine-4.2.0-0.0.master.20171112130303.git8bc889c.el7.centos.noarch
Comment 12 RHV bug bot 2017-12-06 16:16:01 UTC 
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
Comment 13 RHV bug bot 2017-12-12 21:14:35 UTC 
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
Comment 14 RHV bug bot 2017-12-18 17:05:00 UTC 
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
Comment 18 errata-xmlrpc 2018-05-15 17:43:37 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 19 Franta Kust 2019-05-16 13:08:38 UTC 
BZ<2>Jira Resync
Note You need to log in before you can comment on or make changes to this bug.