Bug 782176

*** Bug 773723 has been marked as a duplicate of this bug. ***

This one was partially solved:
1. If the DB is local - services should be restarted
2. If the DB is remote - there's nothing we can do.

closing ON_QA bugs as oVirt 3.1 was released:
http://www.ovirt.org/get-ovirt/

I'm re-opening this as I did an installation using the 3.2 alpha bits and selected local DB but when I tried to clean-up (my install failed on iptables setup after creating the database because well iptables doesn't exist in F18) I got this output:

# engine-cleanup 
WARNING: Executing oVirt Engine cleanup utility.
This utility will wipe all existing data including configuration settings, certificates and database.
In addition, all existing DB connections will be closed.
Would you like to proceed? (yes|no): yes

Stopping ovirt-engine service...                         [ DONE ]
Removing Database...                                    [ ERROR ]
Removing CA...                                           [ DONE ]
Stopping engine-notifierd service...                     [ DONE ]

Cleanup finished with errors, please see log file
Error: failed to clear active DB connections
Cleanup log available at /var/log/ovirt-engine/engine-cleanup_2012_12_19_12_05_10.log

The cleanup log shows the cause of failure:

# tail /var/log/ovirt-engine/engine-cleanup_2012_12_19_12_05_10.log
2012-12-19 12:05:12::DEBUG::engine-cleanup::261::root:: CA Remove completed successfully
2012-12-19 12:05:12::DEBUG::engine-cleanup::389::root:: stoping engine-notifierd service.
2012-12-19 12:05:12::DEBUG::common_utils::1163::root:: stopping engine-notifierd
2012-12-19 12:05:12::DEBUG::common_utils::1200::root:: executing action engine-notifierd on service stop
2012-12-19 12:05:12::DEBUG::common_utils::390::root:: Executing command --> '/sbin/service engine-notifierd stop'
2012-12-19 12:05:12::DEBUG::common_utils::428::root:: output = Stopping engine-notifierd (via systemctl):  [  OK  ]

2012-12-19 12:05:12::DEBUG::common_utils::429::root:: stderr = 
2012-12-19 12:05:12::DEBUG::common_utils::430::root:: retcode = 0
2012-12-19 12:05:12::INFO::engine-cleanup::414::root:: Error: failed to clear active DB connections

Attempting to re-run engine-setup at this point results in:

Creating Database...                                  [ ERROR ]
Database creation failed
Please check log file /var/log/ovirt-engine/engine-setup_2012_12_19_12_08_02.log for more information
[root@sgordon-ovirt-engineusersysredhatcom ~]# tail /var/log/ovirt-engine/engine-setup_2012_12_19_12_08_02.log
  File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 154, in run
    step.run()
  File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 60, in run
    function()
  File "/usr/bin/engine-setup", line 969, in _createDB
    output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=output_messages.ERR_DB_CREATE_FAILED, maskList=masked_value_set)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 433, in execCmd
    raise Exception(msg)
Exception: Database creation failed

So even though this is a local database, the active connections weren't cleared and as a result the database wasn't removed.

Oh in addition at this point re-running engine-cleanup results in this:

# engine-cleanup 
WARNING: Executing oVirt Engine cleanup utility.
This utility will wipe all existing data including configuration settings, certificates and database.
In addition, all existing DB connections will be closed.
Would you like to proceed? (yes|no): yes

Stopping ovirt-engine service...                         [ DONE ]

Error: Couldn't connect to the database server.Check that connection is working and rerun the cleanup utility
Error: Cleanup failed.
please check log at /var/log/ovirt-engine/engine-cleanup_2012_12_19_12_13_48.log

# tail /var/log/ovirt-engine/engine-cleanup_2012_12_19_12_15_09.log
2012-12-19 12:15:23::DEBUG::common_utils::430::root:: retcode = 2
2012-12-19 12:15:23::ERROR::engine-cleanup::476::root:: Traceback (most recent call last):
  File "/usr/bin/engine-cleanup", line 471, in <module>
    main(options)
  File "/usr/bin/engine-cleanup", line 433, in main
    if db.exists() and options.drop_db:
  File "/usr/bin/engine-cleanup", line 366, in exists
    raise Exception(MSG_ERROR_CONNECT_DB)
Exception: Error: Couldn't connect to the database server.Check that connection is working and rerun the cleanup utility

Stephen

Could you please attach the complete log file? It would help me to understand the problem.

Thanks.

(In reply to comment #7)
> Stephen
> 
> Could you please attach the complete log file? It would help me to
> understand the problem.
> 
> Thanks.

I don't have the log from that exact run anymore but I just tried it on another fresh install of the 3.2 alpha bits and got the same result. Will attach.

Thank you Stephen, now I see what the problem is.

The fix is posted for review: http://gerrit.ovirt.org/#/c/10389/

*** Bug 886019 has been marked as a duplicate of this bug. ***

merged; http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=4edc191074ef11177c2460ad7fa0953d3c2dad5b