11:54 a.m.
--_000_867A8F0949022146AA9D43C9D643DDF2423203CEchronos2adsunim_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi
Im runnin ovirt 3.6 and want to upgrade the engine to the newest version...
db consisty check failed
I tracked it down to
engine=3D# select fk_violation, fk_status
from fn_db_validate_fks(false, 1 !=3D 0)
where fk_status=3D1
;
ERROR: relation "group_attributes" does not exist
ZEILE 1: select (group_id) from group_attributes where (group_id) ...
^
ANFRAGE: select (group_id) from group_attributes where (group_id) IS NO=
T NULL and (group_id) not in (select group_id from groups);
KONTEXT: PL/pgSQL function "fn_db_validate_fks" line 40 at EXECUTE stateme=
nt
Any ideas what the problem is?
Installed packages attached below
Best regards
Marc
Installierte Pakete
ovirt-engine.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-backend.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-cli.noarch =
3.6.0.0-0.4.20150817.git514a9fd.el6 =
@ovirt-3.6
ovirt-engine-dbscripts.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-extension-aaa-jdbc.noarch =
1.0.0-0.0.master.20150812053007.gitfed2a32.el6 =
@ovirt-3.6
ovirt-engine-extensions-api-impl.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-jboss-as.x86_64 =
7.1.1-1.el6 =
@ovirt-3.5-pre
ovirt-engine-lib.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-restapi.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-sdk-python.noarch =
3.6.0.0-0.16.20150713.git8c2cf30.el6 =
@ovirt-3.6
ovirt-engine-setup.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-setup-base.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-setup-plugin-ovirt-engine.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-setup-plugin-ovirt-engine-common.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-setup-plugin-vmconsole-proxy-helper.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-setup-plugin-websocket-proxy.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-tools.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-userportal.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-vmconsole-proxy-helper.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-webadmin-portal.noarch =
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
@ovirt-3.6
ovirt-engine-websocket-proxy.noarch =
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
@ovirt-3.6
ovirt-engine-wildfly.x86_64 =
8.2.0-1.el6 =
@ovirt-3.6
ovirt-engine-wildfly-overlay.noarch =
001-2.el6 =
@ovirt-3.6
--_000_867A8F0949022146AA9D43C9D643DDF2423203CEchronos2adsunim_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40" <head <meta http-equiv=3D"Content-Type"
content=3D"text/html; charset=3Dus-ascii"=
<meta name=3D"Generator" content=3D"Microsoft
Word 15 (filtered medium)" <style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" / </xml><![endif]--><!--[if gte mso
9]><xml <o:shapelayout
v:ext=3D"edit" <o:idmap v:ext=3D"edit"
data=3D"1" /
</o:shapelayout></xml><![endif]--
</head <body lang=3D"DE"
link=3D"#0563C1" vlink=3D"#954F72" <div
class=3D"WordSection1" <p
class=3D"MsoNormal">Hi<o:p></o:p></p <p class=3D"MsoNormal"><span
lang=3D"EN-US">Im runnin ovirt 3.6 and want to=
upgrade the engine to the newest
version…<o:p></o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">db consisty check
failed <o:p><=
/o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">I tracked it down to
<o:p></o:p=
></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">engine=3D# select
fk_violation,=
fk_status<o:p></o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">from
fn_db_validate_fks(false, =
1 !=3D 0)<o:p></o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">where
fk_status=3D1<o:p></o:p><=
/span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">;<o:p></o:p></span></p <p class=3D"MsoNormal"><span
lang=3D"EN-US">ERROR: relation "gro=
up_attributes" does not exist<o:p></o:p></span></p <p class=3D"MsoNormal"><span
lang=3D"EN-US">ZEILE 1: select (group_id=
) from group_attributes where (group_id)
...<o:p></o:p></span><=
/p <p class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp; &nbs=
p; &=
nbsp; ^<o:p></o:p></span></p <p class=3D"MsoNormal"><span
lang=3D"EN-US">ANFRAGE: select (gr=
oup_id) from group_attributes where (group_id) IS NOT NULL and&=
nbsp; (group_id) not in (select group_id from
groups);<o:p></o:p></sp=
an></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">KONTEXT:
PL/pgSQL functio=
n "fn_db_validate_fks" line 40 at EXECUTE
statement<o:p></o:p></s=
pan></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p <p class=3D"MsoNormal"><span
lang=3D"EN-US">Any ideas what the problem is?<=
o:p></o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">Installed packages
attached bel=
ow <o:p></o:p></span></p <p
class=3D"MsoNormal"><span lang=3D"EN-US">Best regards
<o:p></o:p></span>=
</p <p class=3D"MsoNormal"><span
lang=3D"EN-US">Marc<o:p></o:p></span></p <p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p <p class=3D"MsoNormal">Installierte
Pakete<o:p></o:p></p <p
class=3D"MsoNormal">ovirt-engine.noarch &nb=
sp;
 =
; &n=
bsp;  =
; &n=
bsp; 3.6.0-0.0.m=
aster.20150811152341.git5823dda.el6 &nbs=
p; &=
nbsp;
@ovirt-3.=
6
<o:p></o:p></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-backend.noarch&nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p;
3.6.0-0.0.master.2015081115234=
1.git5823dda.el6  =
; &n=
bsp;
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-cli.noarch &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;
3.6.0.0-0.=
4.20150817.git514a9fd.el6 &n=
bsp;  =
; &n=
bsp;
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-dbscripts.noarch&n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;
3.6.0-0.0.master.20150811152341.git5823d=
da.el6 &nb=
sp; =
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-extension-aaa-jdbc=
.noarch &n=
bsp;  =
; &n=
bsp;
1.0.0-0.0.=
master.20150812053007.gitfed2a32.el6 &nb=
sp; =
@ovirt-3=
.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-extensions-api-imp=
l.noarch &=
nbsp; &nbs=
p; &=
nbsp;
3.6.0-0.0.maste=
r.20150819133528.gite6b79a7.el6 &n=
bsp;  =
;
@ovirt-3.6&nb=
sp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-jboss-as.x86_64&nb=
sp; =
&nb=
sp; =
&nb=
sp;
7.1.1-1.el6 =
&nb=
sp; =
&nb=
sp; =
@ovirt-3=
.5-pre<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-lib.noarch &n=
bsp;  =
; &n=
bsp;  =
;
&=
nbsp; 3.6.0-0.0.=
master.20150819133528.gite6b79a7.el6 &nb=
sp; =
@ovirt-3=
.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-restapi.noarch&nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p;
3.6.0-0.0.master.2015081115234=
1.git5823dda.el6  =
;
&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(a)ovirt-3.6&nbsp;&nbsp;&nbsp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-sdk-python.noarch&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp;
3.6.0.0-0.16.20150713.git8c2cf30.el6 &nb=
sp; =
&nb=
sp; =
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup.noarch =
&nb=
sp;
 =
; &n=
bsp;  =
; 3.6.0-0.0.master.201=
50819133528.gite6b79a7.el6 &=
nbsp; &nbs=
p;
@ovirt-3.6 &n=
bsp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup-base.noarch&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp;
3.6.0-0.0.master.20150819133528.gite6b79a7.el=
6 &n=
bsp;  =
;
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup-plugin-ovirt=
-engine.noarch &=
nbsp; &nbs=
p; &=
nbsp;
3.6.0-0.0.master.20150819133528.gite6b79a7.el=
6 &n=
bsp;  =
;
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup-plugin-ovirt=
-engine-common.noarch =
&nb=
sp;
3.6.0=
-0.0.master.20150819133528.gite6b79a7.el6 &nbs=
p; &=
nbsp;
@ov=
irt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup-plugin-vmcon=
sole-proxy-helper.noarch &nb=
sp; =
3.6.0-0.0.master.201=
50819133528.gite6b79a7.el6 &=
nbsp; &nbs=
p;
@ovirt-3.6 &n=
bsp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-setup-plugin-webso=
cket-proxy.noarch &nbs=
p; &=
nbsp; &nbs=
p;
3.6.0-0.0.master.20150819133528.gite6b79a7.el6 &n=
bsp;  =
; &n=
bsp; @ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-tools.noarch =
&nb=
sp; =
&nb=
sp; =
3.6.0-0.0.master.201=
50811152341.git5823dda.el6 &=
nbsp; &nbs=
p;
@ovirt-3.6 &n=
bsp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-userportal.noarch&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp;
3.6.0-0.0.master.20150811152341.git5823dda.el=
6 &n=
bsp;  =
;
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-vmconsole-proxy-he=
lper.noarch &nbs=
p; &=
nbsp; &nbs=
p;
3.6.0-0.0.master.2015081913352=
8.gite6b79a7.el6  =
; &n=
bsp;
&nbsp;&nbsp;&nbsp;(a)ovirt-3.6&nbsp;&nbsp;&nbsp;
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-webadmin-portal.no=
arch  =
; &n=
bsp;  =
; &n=
bsp;
3.6.0-0.0.master.20150811152341.git5823dda.el6 =
&nb=
sp; =
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-websocket-proxy.no=
arch  =
;
&=
nbsp; &nbs=
p; &=
nbsp;3.6.0-0.0.master.20150819133528.gite6b79a7.el6 =
&nb=
sp; =
@ovirt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-wildfly.x86_64&nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p;
8.2.0-1.el6 &=
nbsp; &nbs=
p; &=
nbsp;
&nb=
sp; =
@ov=
irt-3.6
<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
lang=3D"EN-US">ovirt-engine-wildfly-overlay.no=
arch  =
; &n=
bsp;  =
; &n=
bsp;
001-2.el6 &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp;
@ovirt-3.6
<o:p></o:p></span></p
</div </body </html
--_000_867A8F0949022146AA9D43C9D643DDF2423203CEchronos2adsunim_--