[ovirt-devel] engine-setup broken in master?

[Eli Mesika]

----- Original Message -----
> From: "Omer Frenkel" <ofrenkel at redhat.com>
> To: "Roy Golan" <rgolan at redhat.com>
> Cc: devel at ovirt.org
> Sent: Thursday, June 25, 2015 11:16:23 AM
> Subject: Re: [ovirt-devel] engine-setup broken in master?
> 
> 
> 
> ----- Original Message -----
> > From: "Roy Golan" <rgolan at redhat.com>
> > To: "Omer Frenkel" <ofrenkel at redhat.com>, devel at ovirt.org
> > Sent: Thursday, June 25, 2015 11:07:40 AM
> > Subject: Re: [ovirt-devel] engine-setup broken in master?
> > 
> > Dudi hit the same issue.
> > 
> > On 06/25/2015 10:37 AM, Omer Frenkel wrote:
> > > Hi,
> > > on latest master, engine-setup fails for me with:
> > > [ ERROR ] Failed to execute stage 'Setup validation': Failed checking
> > > Engine database: [u'']
> > >
> > > from the setup log:
> > >
> > > 2015-06-25 10:27:51 DEBUG
> > > otopi.plugins.ovirt_**FILTERED**_setup.ovirt_**FILTERED**.upgrade.dbvalidations
> > > plugin.execute:940 execute-output:
> > > ['/home/ofrenkel/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/dbu
> > > tils/validatedb.sh', '--user=**FILTERED**', '--host=localhost',
> > > '--port=5432', '--database=**FILTERED**',
> > > '--log=/home/ofrenkel/ovirt-**FILTERED**/var/log/ovirt-**FILTERED**/setup/ovirt-**FILTERED**-setup-201506
> > > 25102702-nwwazb.log'] stderr:
> > > ERROR:  function fn_db_validate_fks(boolean, boolean) does not exist
> > > LINE 3:     from fn_db_validate_fks(false, 0 != 0)
> > >                   ^
> > > HINT:  No function matches the given name and argument types. You might
> > > need to add explicit type casts.

Didi, we concluded that engine-setup is responding for installing the SPs, can you please check on upgrade scenario if the call for fkvalidaor script is done before SPs are installed 

> > >
> > > 2015-06-25 10:27:51 DEBUG otopi.context context._executeMethod:155 method
> > > exception
> > > Traceback (most recent call last):
> > >    File "/usr/lib/python2.7/site-packages/otopi/context.py", line 145, in
> > >    _executeMethod
> > >      method['method']()
> > >    File
> > >    "/home/ofrenkel/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/upgrade/dbvalidations.py",
> > >    line 128, in _validation
> > >      violations, issues_found = self._checkDb()
> > >    File
> > >    "/home/ofrenkel/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/upgrade/dbvalidations.py",
> > >    line 91, in _checkDb
> > >      output=stdout,
> > > RuntimeError: Failed checking Engine database:
> > > [u'']
> > >
> > > 2015-06-25 10:27:51 ERROR otopi.context context._executeMethod:164 Failed
> > > to execute stage 'Setup validation': Failed checking Engine database:
> > > [u'']
> > >
> > > ----
> > >
> > > looks like lately this function (fn_db_validate_fks) was moved, might be
> > > related?
> > > ( https://gerrit.ovirt.org/#/c/42655/ )
> > >
> > > i even tried to completely remove my ~/ovirt-engine/ folder and create
> > > from
> > > scratch
> > >
> > > anyone else experienced this?
> > >
> > > Thanks,
> > > Omer.
> > > _______________________________________________
> > > Devel mailing list
> > > Devel at ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/devel
> > 
> > 
> 
> 
> manually running the script [1] fixed it, but upgrade is broken
> 
> [1] psql -f packaging/dbscripts/fkvalidator_sp.sql
> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>