2018-05-25 9:41 GMT+02:00 Maton, Brett <matonb(a)ltresources.co.uk&gt;: > The 4.2.4 upgrade appears to have a database issue, i'm seeing these > errors in the postgresql logs: > > 2018-05-24 16:27:08.292 UTC ERROR: relation "provider_binding_host_id" > does not exist at character 15 > 2018-05-24 16:27:08.292 UTC QUERY: SELECT 1 FROM > provider_binding_host_id WHERE vds_id = v_vds_id FOR UPDATE > 2018-05-24 16:27:08.292 UTC CONTEXT: PL/pgSQL function > updatehostproviderbinding(uuid,character varying[],character varying[]) > line 3 at PERFORM > > Any suggestions ? > Thanks for having tested 4.2.4 RC1 and giving feedback! Adding Martin and Eli for further investigations. > > _______________________________________________ > Users mailing list -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org > > -- SANDRO BONAZZOLA ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D Red Hat EMEA <https://www.redhat.com/> sbonazzo(a)redhat.com <https://red.ht/sig> <https://redhat.com/summit>

It would be from the last 4.2.3 release in the ovirt-4.2-pre repositories I haven't got the logs unfortunately, I'll try to recreate the scenario over the weekend.

On 25 May 2018 at 12:09, Martin Perina <mperina(a)redhat.com&gt; wrote: > Hi, > > from which oVirt version are you upgrading to 4.2.4? Could you please > share with us complete upgrade logs from engine host? > > Thanks > > Martin > > > On Fri, May 25, 2018 at 10:38 AM, Sandro Bonazzola <sbonazzo(a)redhat.com&gt; > wrote: > >> >> >> 2018-05-25 9:41 GMT+02:00 Maton, Brett <matonb(a)ltresources.co.uk&gt;: >> >>> The 4.2.4 upgrade appears to have a database issue, i'm seeing these >>> errors in the postgresql logs: >>> >>> 2018-05-24 16:27:08.292 UTC ERROR: relation "provider_binding_host_id" >>> does not exist at character 15 >>> 2018-05-24 16:27:08.292 UTC QUERY: SELECT 1 FROM >>> provider_binding_host_id WHERE vds_id = v_vds_id FOR UPDATE >>> 2018-05-24 16:27:08.292 UTC CONTEXT: PL/pgSQL function >>> updatehostproviderbinding(uuid,character varying[],character >>> varying[]) line 3 at PERFORM >>> >>> Any suggestions ? >>> >> >> Thanks for having tested 4.2.4 RC1 and giving feedback! Adding Martin >> and Eli for further investigations. >> >> >> >>> >>> _______________________________________________ >>> Users mailing list -- users(a)ovirt.org >>> To unsubscribe send an email to users-leave(a)ovirt.org >>> >>> >> >> >> -- >> >> SANDRO BONAZZOLA >> >> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D >> >> Red Hat EMEA <https://www.redhat.com/> >> >> sbonazzo(a)redhat.com >> <https://red.ht/sig> >> <https://redhat.com/summit> >> > > > > -- > Martin Perina > Associate Manager, Software Engineering > Red Hat Czech s.r.o. >

Hi The provider_binding_host_id is a new table added recently , can you please attach the output of the following query on your database : select * from schema_version order by id desc; Thanks On Fri, May 25, 2018 at 2:30 PM, Maton, Brett <matonb(a)ltresources.co.uk&gt; wrote: > It would be from the last 4.2.3 release in the ovirt-4.2-pre repositories > > I haven't got the logs unfortunately, I'll try to recreate the scenario > over the weekend. > > On 25 May 2018 at 12:09, Martin Perina <mperina(a)redhat.com&gt; wrote: > >> Hi, >> >> from which oVirt version are you upgrading to 4.2.4? Could you please >> share with us complete upgrade logs from engine host? >> >> Thanks >> >> Martin >> >> >> On Fri, May 25, 2018 at 10:38 AM, Sandro Bonazzola <sbonazzo(a)redhat.com&gt; >> wrote: >> >>> >>> >>> 2018-05-25 9:41 GMT+02:00 Maton, Brett <matonb(a)ltresources.co.uk&gt;: >>> >>>> The 4.2.4 upgrade appears to have a database issue, i'm seeing these >>>> errors in the postgresql logs: >>>> >>>> 2018-05-24 16:27:08.292 UTC ERROR: relation >>>> "provider_binding_host_id" does not exist at character 15 >>>> 2018-05-24 16:27:08.292 UTC QUERY: SELECT 1 FROM >>>> provider_binding_host_id WHERE vds_id = v_vds_id FOR UPDATE >>>> 2018-05-24 16:27:08.292 UTC CONTEXT: PL/pgSQL function >>>> updatehostproviderbinding(uuid,character varying[],character >>>> varying[]) line 3 at PERFORM >>>> >>>> Any suggestions ? >>>> >>> >>> Thanks for having tested 4.2.4 RC1 and giving feedback! Adding Martin >>> and Eli for further investigations. >>> >>> >>> >>>> >>>> _______________________________________________ >>>> Users mailing list -- users(a)ovirt.org >>>> To unsubscribe send an email to users-leave(a)ovirt.org >>>> >>>> >>> >>> >>> -- >>> >>> SANDRO BONAZZOLA >>> >>> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D >>> >>> Red Hat EMEA <https://www.redhat.com/> >>> >>> sbonazzo(a)redhat.com >>> <https://red.ht/sig> >>> <https://redhat.com/summit> >>> >> >> >> >> -- >> Martin Perina >> Associate Manager, Software Engineering >> Red Hat Czech s.r.o. >> > >