[Users] Testing ovirt all in one on F18 gives error on DB creation

[Alon Bar-Lev]

----- Original Message -----
> From: "Gianluca Cecchi" <gianluca.cecchi at gmail.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: "Juan Antonio Hernandez Fernandez" <jhernand at redhat.com>, "users" <users at ovirt.org>, "Alex Lourie"
> <alourie at redhat.com>, "Ohad Basan" <obasan at redhat.com>
> Sent: Tuesday, December 4, 2012 6:04:41 PM
> Subject: Re: [Users] Testing ovirt all in one on F18 gives error on DB creation
> 
> Probably the problems I have in cleanup are all related to the DB
> problems during engine-setup..?
> In fact this is what I get:
> 
> [root at f18aio ~]# 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_04_08_32_37.log
> 
> So I manage to drop the "engine" database from psql prompt and then
> run the cleanup again:
> 
> [root at f18aio ~]# 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 CA...                                           [ DONE ]
> Stopping engine-notifierd service...                     [ DONE ]
> 
> Cleanup finished successfully!
> Cleanup log available at
> /var/log/ovirt-engine/engine-cleanup_2012_12_04_08_33_53.log
> 
> But at next engine-setup I get the errors I sent the previous mail.
> 
> 
> I'll retry with next nightly build.
> The important thing is the confirmation that "engin-cleanup" has to
> be
> sufficient.
> I'll deploy a new f18 and test.
> 
> Gianluca
> 

If you really have a problem with psql, you can revert anything by removing /var/lib/pgsql, and execute postgresql-setup initdb.