Bug 1611961

Summary: Error updating from 4.2.5.1 to 4.2.5.2
Product: [oVirt] ovirt-engine Reporter: Vladimir <vvlopuk>
Component: Setup.EngineAssignee: Daniel Erez <derez>
Status: CLOSED DUPLICATE QA Contact: meital avital <mavital>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 4.2.5.1CC: bugs
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-08-03 08:34:40 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Storage RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Log none

Description Vladimir 2018-08-03 07:28:40 UTC
Created attachment 1472893 [details]
Log

Description of problem: 
Error updating from 4.2.5.1 to 4.2.5.2

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

How reproducible:
engine-setup

I can not install updates.

Comment 1 Sandro Bonazzola 2018-08-03 08:29:04 UTC
2018-08-03 11:01:51,391+0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180803105711-cb9gin.log', '-c', 'apply'] stderr:
psql:/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql:1: ERROR:  insert or update on table "image_transfers" violates foreign key constraint "fk_image_transfers_command_enitites"
DETAIL:  Key (command_id)=(d7fec018-1a77-4e56-9859-c59fb0ce46a4) is not present in table "command_entities".
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql

2018-08-03 11:01:51,391+0400 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:434 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql
2018-08-03 11:01:51,417+0400 DEBUG otopi.context context._executeMethod:143 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 436, in _misc
    raise RuntimeError(_('Engine schema refresh failed'))
RuntimeError: Engine schema refresh failed
2018-08-03 11:01:51,432+0400 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Engine schema refresh failed

Comment 2 Sandro Bonazzola 2018-08-03 08:34:40 UTC
thanks for reporting, we are tracking this on bug #1609839

*** This bug has been marked as a duplicate of bug 1609839 ***