Re: [ovirt-users] ovirt 3.6 engine-setup failed db consisty check failed

Friday, 21 August 2015

This is a multi-part message in MIME format.
--------------000105090606030906040205
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

please take a look at this bz[1]

Ondra

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1254639

On 08/21/2015 10:54 AM, Marc Werner wrote:
...

 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=# select fk_violation, fk_status

 from fn_db_validate_fks(false, 1 != 0)

 where fk_status=1

 ;

 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 NOT NULL and  (group_id)  not in (select group_id from groups);

 KONTEXT:  PL/pgSQL function "fn_db_validate_fks" line 40 at EXECUTE 
 statement

 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

 _______________________________________________
 Users mailing list
 Users(a)ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users 

--------------000105090606030906040205
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi,<br>
    <br>
    please take a look at this bz[1]<br>
    <br>
    Ondra<br>
    <br>
    [1] <a class="moz-txt-link-freetext"
href="https://bugzilla.redhat.com/show_bug.cgi?id=1254639">h...
    <br>
    <div class="moz-cite-prefix">On 08/21/2015 10:54 AM, Marc Werner
      wrote:<br>
    </div>
    <blockquote
cite="mid:867A8F0949022146AA9D43C9D643DDF2423203CE@chronos2.ads.uni-magdeburg.de"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="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="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal">Hi<o:p></o:p></p>
        <p class="MsoNormal"><span lang="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="MsoNormal"><span lang="EN-US">db
consisty check failed
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">I tracked
it down to <o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">engine=#
select
            fk_violation, fk_status<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">from
            fn_db_validate_fks(false, 1 !=
0)<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">where
fk_status=1<o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">;<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">ERROR: 
relation
            "group_attributes" does not
exist<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">ZEILE 1:
select 
            (group_id)  from group_attributes where  (group_id)
...<o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">                                 
            ^<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">ANFRAGE: 
select 
            (group_id)  from group_attributes where  (group_id) IS NOT
            NULL and  (group_id)  not in (select group_id from
groups);<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">KONTEXT: 
PL/pgSQL
            function "fn_db_validate_fks" line 40 at EXECUTE
statement<o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Any ideas
what the
            problem is?<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Installed
packages
            attached below <o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Best
regards <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">Marc<o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal">Installierte
Pakete<o:p></o:p></p>
        <p class="MsoNormal">ovirt-engine.noarch                

                                                  3.6.0-0.0.master.20150811152341.git5823dda.el6                              
          @ovirt-3.6   
          <o:p></o:p></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-backend.noarch                                                          
            3.6.0-0.0.master.20150811152341.git5823dda.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-cli.noarch                                                              
            3.6.0.0-0.4.20150817.git514a9fd.el6                                         
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-dbscripts.noarch                                                        
            3.6.0-0.0.master.20150811152341.git5823dda.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-extension-aaa-jdbc.noarch                                               
            1.0.0-0.0.master.20150812053007.gitfed2a32.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-extensions-api-impl.noarch                                              
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-jboss-as.x86_64                                                         
            7.1.1-1.el6                                                                 
            @ovirt-3.5-pre<o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-lib.noarch                                              

                3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-restapi.noarch                                                          
            3.6.0-0.0.master.20150811152341.git5823dda.el6               
                           (a)ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-sdk-python.noarch                                                       
            3.6.0.0-0.16.20150713.git8c2cf30.el6                                        
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup.noarch                      

                                      3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup-base.noarch                                                       
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup-plugin-ovirt-engine.noarch                                        
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup-plugin-ovirt-engine-common.noarch                                 
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup-plugin-vmconsole-proxy-helper.noarch                              
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-setup-plugin-websocket-proxy.noarch                                     
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-tools.noarch                                                            
            3.6.0-0.0.master.20150811152341.git5823dda.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-userportal.noarch                                                   

    3.6.0-0.0.master.20150811152341.git5823dda.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-vmconsole-proxy-helper.noarch                                           
            3.6.0-0.0.master.20150819133528.gite6b79a7.el6                           
               (a)ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-webadmin-portal.noarch                                                  
            3.6.0-0.0.master.20150811152341.git5823dda.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-websocket-proxy.noarch                        

                          3.6.0-0.0.master.20150819133528.gite6b79a7.el6                              
            @ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-wildfly.x86_64                                                          
            8.2.0-1.el6                                        
                                     (a)ovirt-3.6   
            <o:p></o:p></span></p>
        <p class="MsoNormal"><span
lang="EN-US">ovirt-engine-wildfly-overlay.noarch                                                  
            001-2.el6                                                                   
            @ovirt-3.6   
            <o:p></o:p></span></p>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated"
href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext"
href="http://lists.ovirt.org/mailman/listinfo/users">http://...
</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------000105090606030906040205--

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

Re: [ovirt-users] ovirt 3.6 engine-setup failed db consisty check failed