Created attachment 889568 [details]
ovirt-engine-setup-20140425103134.log

Description of problem:
I had a tag creates 'users' and assigned to an user in my setup. engine-setup failed because of this tag. Removing the tag made engine-setup to pass.

...snip...
2014-04-25 10:38:21 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:446 execute-output: ['/usr/share/ovirt-engine/dbscripts/upgrade.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20140425103134.log', '-g'] stderr:
psql:upgrade/03_04_0740_update_user_ids.sql:37: ERROR:  insert or update on table "tags_user_map" violates foreign key constraint "tags_user_map_user"
DETAIL:  Key (user_id)=(215a64da-6961-40d8-b91a-79cf3c1b49d8) is not present in table "users".
CONTEXT:  SQL statement "UPDATE tags_user_map m set user_id = ( SELECT temp_id FROM users WHERE user_id = m.user_id)"
PL/pgSQL function "__temp_update_user_ids_03_04_0740" line 17 at SQL statement

2014-04-25 10:38:22 DEBUG otopi.context context._executeMethod:152 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 345, in _miscUpgrade
    osetupcons.DBEnv.PGPASS_FILE
  File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 451, in execute
    command=args[0],
RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute
2014-04-25 10:38:22 ERROR otopi.context context._executeMethod:161 Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute
...snip...

engine=# select user_id,name from users;                                                                                                 
               user_id                |    name    
--------------------------------------+------------
 fdfc627c-d875-11e0-90f0-83df133b58cc | admin
 22341bfe-195b-421c-8bad-b9c16c8545c2 | ad-w2k8r2
 b8b52a4f-7f82-46f7-8ede-973d2489066b | ad-w2k12r2
 939b52b6-57d4-4545-b318-8f43ec2e7a22 | admin
 03e5248f-0b4f-4182-98c1-8808635525f4 | vdcadmin2
 7ce4c3e8-66b3-4a24-92ad-ea1fc43c769b | vdcadmin
(6 rows)

engine=# select * from tags_user_map;
                tag_id                |               user_id                |         _create_date         
--------------------------------------+--------------------------------------+------------------------------
 503acfc8-39e9-4774-9cc6-95ba51a23e0a | b8b52a4f-7f82-46f7-8ede-973d2489066b | 2014-04-25 10:20:07.79119+02
(1 row)

Version-Release number of selected component (if applicable):
av6.1 / rhevm-3.4.0-0.13.beta3.el6ev.noarch

How reproducible:
???

Steps to Reproduce:
1. assing a tag to a user
2. do update from av6.1 to av7 via engine-setup
3.

Actual results:
update fails

Expected results:
should pass

Additional info: