[Users] Fwd: database issue after power failure

[Neil]

I've found out now that another technician accidentally deleted my
psql engine db because he tried to install bacula on the same server.
I have no backup of the DB because I was still in the process of
setting them up and wasn't aware he was going to be installing onto
this server.

I currently have 6 guests that are in a shutdown state because of a
power failure over the weekend. It's using FC storage, only the db
seems to be missing.

Is there anything I can do to recover from this disaster?

Thanks.

Regards.

Neil.


---------- Forwarded message ----------
From: Neil <nwilson123 at gmail.com>
Date: Mon, Oct 15, 2012 at 9:10 AM
Subject: database issue after power failure
To: users at ovirt.org


Hi guys,

I've got what looks like a huge issue after a power failure.

In my server.log I'm seeing "Caused by:
org.postgresql.util.PSQLException: FATAL: database "engine" does not
exist" in my server.log and in my engine.log I'm seeing the following
which also looks very bad.

"2012-10-15 09:08:41,357 ERROR [org.ovirt.engine.core.bll.Backend]
(MSC service thread 1-4) Error in getting DB connection. The database
is inaccessible. Original exception is:
DataAccessResourceFailureException: Error retreiving database
metadata; nested exception is
org.springframework.jdbc.support.MetaDataAccessException: Could not
get Connection for extracting meta data; nested exception is
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not
get JDBC Connection; nested exception is java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/ENGINEDataSource"

Please could someone assist if possible, I'm currently logged in on
#ovirt as well.

Thanks.

Regards.

Neil Wilson.