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)
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)