--_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"=
</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=
<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= 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; @ovirt-3.6 <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; @ovirt-3.6 <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_--