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

Bug 1488630

Summary:	03_06_0620_create_fence_agents_table.sql:60: ERROR: null value in column "agent_user" violates not-null constraint
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Douglas Schilling Landgraf <dougsland>
Component:	ovirt-engine	Assignee:	Douglas Schilling Landgraf <dougsland>
Status:	CLOSED ERRATA	QA Contact:	Jiri Belka <jbelka>
Severity:	high	Docs Contact:
Priority:	high
Version:	3.6.10	CC:	dberry, lsurette, mkalinin, mperina, pstehlik, rbalakri, Rhev-m-bugs, srevivo, ykaul, ylavi
Target Milestone:	ovirt-4.2.0
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1490089 1490090 (view as bug list)		Environment:
Last Closed:	2018-05-15 17:43:37 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:
Bug Blocks:	1490089, 1490090

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