[Users] Fwd: database issue after power failure
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(a)gmail.com>
Date: Mon, Oct 15, 2012 at 9:10 AM
Subject: database issue after power failure
To: users(a)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.