9:18 a.m.
------=_Part_11276357_1295995532.1391066312043
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
From: "Steve Dainard" <sdainard(a)miovision.com>
To: "Alon Bar-Lev" <alonbl(a)redhat.com>
Cc: "users" <users(a)ovirt.org>, "Yedidyah Bar David"
<didi(a)redhat.com>, "Eli
Mesika" <emesika(a)redhat.com>
Sent: Thursday, January 30, 2014 7:44:01 AM
Subject: Re: [Users] engine-backup restore how to
I also see this error in engine.log which repeats every second if I
am trying
to access the web ui.
2014-01-29 18:59:47,531 ERROR [org.ovirt.engine.core.bll.Backend]
(ajp--127.0.0.1-8702-4) Error in getting DB connection. The database is
inaccessible. Original exception is: UncategorizedSQLException:
CallableStatementCallback; uncategorized SQLException for SQL [{call
checkdbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current
transaction is aborted, commands ignored until end of transaction block;
nested exception is org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction block
It looks like the db inserted correctly, I took a quick look through
some
tables and can see the valid admin user, and snapshots. But I can't say for
certain.
The IP address of the new server does not match the IP of the old
(backup
file) server, would this have any impact? I would think not as its a local
db.
When I changed the password for the psql engine user, is there any
config
file this is referenced in that may not have been updated?
In principle, the only needed file is
/etc/ovirt-engine/engine.conf.d/10-setup-database.conf
which was updated by restore. Can you please verify that you can connect to the database
using the credentials in this file? What are its permissions/owner?
Thanks,
--
Didi
------=_Part_11276357_1295995532.1391066312043
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><body><div style=3D"font-family: times new roman, new york,
times, se=
rif; font-size: 12pt; color: #000000"><div></div><blockquote
style=3D"borde=
r-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-w=
eight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,A=
rial,sans-serif;font-size:12pt;"><b>From: </b>"Steve
Dainard" <sdainard@=
miovision.com><br><b>To: </b>"Alon Bar-Lev"
&lt;alonbl(a)redhat.com&gt;<br=
<b>Cc: </b>"users"
&lt;users(a)ovirt.org&gt;, "Yedidyah Bar David" <didi@=
redhat.com>, "Eli Mesika"
&lt;emesika(a)redhat.com&gt;<br><b>Sent: </b>Thu=
rsday, January 30, 2014 7:44:01 AM<br><b>Subject: </b>Re: [Users]
engine-ba=
ckup restore how to<br><div><br></div><div
dir=3D"ltr">I also see this erro=
r in engine.log which repeats every second if I am trying to access the web=
ui.<div><br></div><div>2014-01-29 18:59:47,531 ERROR
[org.ovirt.engine.cor=
e.bll.Backend] (ajp--127.0.0.1-8702-4) Error in getting DB connection. The =
database is inaccessible. Original exception is: UncategorizedSQLException:=
CallableStatementCallback; uncategorized SQLException for SQL [{call check=
dbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current transac=
tion is aborted, commands ignored until end of transaction block; nested ex=
ception is org.postgresql.util.PSQLException: ERROR: current transaction is=
aborted, commands ignored until end of transaction
block</div><div><br></d=
iv><div>It looks like the db inserted correctly, I took a quick look throug=
h some tables and can see the valid admin user, and snapshots. But I can't =
say for certain.</div><div><br></div><div>The IP address of
the new server =
does not match the IP of the old (backup file) server, would this have any =
impact? I would think not as its a local
db.</div><div><br></div><div>When =
I changed the password for the psql engine user, is there any config file t=
his is referenced in that may not have been
updated?</div></div></blockquot=
e><div><br></div><div>In principle, the only needed file
is <span styl=
e=3D"font-family: Helvetica, Arial, sans-serif;"
data-mce-style=3D"font-fam=
ily: Helvetica, Arial, sans-serif;">/etc/ovirt-engine/engine.conf.d/10-setu=
p-database.conf</span></div><div><span style=3D"font-family:
Helvetica, Ari=
al, sans-serif;" data-mce-style=3D"font-family: Helvetica, Arial, sans-seri=
f;">which was updated by restore. Can you please verify that you can connec=
t to the database</span></div><div><span style=3D"font-family:
Helvetica, A=
rial, sans-serif;" data-mce-style=3D"font-family: Helvetica, Arial, sans-se=
rif;">using the credentials in this file? What are its permissions/owner?</=
span></div><div><span style=3D"font-family: Helvetica, Arial,
sans-serif;" =
data-mce-style=3D"font-family: Helvetica, Arial,
sans-serif;"><br></span></=
div><div><span style=3D"font-family: Helvetica, Arial, sans-serif;"
data-mc=
e-style=3D"font-family: Helvetica, Arial,
sans-serif;">Thanks,</span></div>=
<div>-- <br></div><div><span
name=3D"x"></span>Didi<span name=3D"x"></span>=
<br></div><div><br></div></div></body></html>
------=_Part_11276357_1295995532.1391066312043--