Created attachment 1065290 [details]
engine-logs

Description of problem:
Failed checking Engine database during engine setup after restore engine from backup

2015-08-20 16:31:21 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=l
ocalhost', '--port=5432', '--database=engine', '--log=/var/log/ovirt-engine/setup/ovirt-engine-setup-20150820163046-m4qvgg.log'] stderr:
ERROR:  relation "user_groups" does not exist
LINE 1: select  (in_group_id)  from user_groups where  (in_group_id)...
                                    ^
QUERY:  select  (in_group_id)  from user_groups where  (in_group_id) IS NOT NULL and  (in_group_id)  not in (select in_group_id from groups);
CONTEXT:  PL/pgSQL function "fn_db_validate_fks" line 40 at EXECUTE statement

2015-08-20 16:31:21 DEBUG otopi.context context._executeMethod:155 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 145, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/dbvalidations.py", line 128, in _validation
    violations, issues_found = self._checkDb()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/dbvalidations.py", line 91, in _checkDb
    output=stdout,
RuntimeError: Failed checking Engine database:
[u'']

2015-08-20 16:31:21 ERROR otopi.context context._executeMethod:164 Failed to execute stage 'Setup validation': Failed checking Engine database:
[u'']

In my setup, I had an engine with dwh and reports. I wanted backup all and after engine-cleanup I wanted restore all from created backup. 

Version-Release number of selected component (if applicable):
rhevm-3.6.0-0.11.master.el6.noarch

How reproducible:
always

Steps to Reproduce:
1. Have an used engine (I have dwh and reports too) (used - some created VMs)
2. Make a backup: engine-backup --mode=backup --scope=all --file=backup.tar --log=backup.log
3. clean the engine: engine-cleanup
4. restore: engine-backup --mode=restore --scope=all --file=backup.tar --log=restore.log
5. engine-setup

Actual results:
[ INFO  ] Unlocking existing entities
[ INFO  ] Checking the Engine database consistency
[ ERROR ] Failed to execute stage 'Setup validation': Failed checking Engine database: [u''] 
[ INFO  ] Stage: Clean up
          Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20150820163046-m4qvgg.log
[ INFO  ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20150820163121-setup.conf'
[ INFO  ] Stage: Pre-termination
[ INFO  ] Stage: Termination
[ ERROR ] Execution of setup failed

Expected results:
Should work.

Additional info:
Attached logs from engine, backup logs and backup file (backup.tar)