Re: [Users] Fwd: database issue after power failure
----- Original Message -----
From: "Neil" <nwilson123(a)gmail.com>
To: users(a)ovirt.org
Sent: Monday, October 15, 2012 9:27:24 AM
Subject: [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?
Hi
Is this a new installation or one that was upgraded?
If it is an upgrade IIRC we are backing up the database prior to the upgrade so maybe it
is possible to search for this backup and getting an older version of your DB.
If the DB is deleted and you have no backups you will probably have to reinstall.
I recommend to backup your DB on a daily basis using our backup.sh script , you can use a
simple cron job for that.
Eli
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.
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users