Bug 1261336

Summary: [engine-setup] The error for a missing update in the sql performing the validation should be fixed.
Product: Red Hat Enterprise Virtualization Manager Reporter: Ilanit Stein <istein>
Component: ovirt-engine-setupAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED UPSTREAM QA Contact: Ilanit Stein <istein>
Severity: low Docs Contact:
Priority: unspecified    
Version: 3.6.0CC: bazulay, ecohen, gklein, lsurette, rbalakri, Rhev-m-bugs, yeylon, ylavi
Target Milestone: ovirt-3.6.1   
Target Release: 3.6.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-10-27 12:47:28 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1261335    
Bug Blocks:    

Description Ilanit Stein 2015-09-09 07:59:21 UTC 
Description of problem:

Bug 1254639 - "engine-setup fails at second run",
Show in the setup log a message that need to be fixed:

===============================================================================
2015-08-24 08:07:04 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.upgrade.dbvalidations plugin.execute:940 execute-output: ['/usr/share/ovirt-engine/setup/dbutils/validatedb.sh', '--user=engine', '--host=localhost', '--port=5432', '--database=engine', '--log=/var/log/ovirt-engine/setup/ovirt-engine-setup-20150824080613-j3lju0.log'] stderr:
ERROR:  relation "group_attributes" does not exist
LINE 1: select  (group_id)  from group_attributes where  (group_id) ...
                                 ^
QUERY:  select  (group_id)  from group_attributes where  (group_id) IS NOT NULL and  (group_id)  not in (select group_id from groups);
CONTEXT:  PL/pgSQL function "fn_db_validate_fks" line 40 at EXECUTE statement
===============================================================================

From bug 1256214 (duplicate of bug 1254639), comment 1:
alonbl: "Sandro, you should probably throw exception that is human readable, this is not a debug, error is probably in stderr, and format should not be list/tuple."

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