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@ltresources.co.uk> 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@redhat.com> 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@redhat.com> wrote:

2018-05-25 9:41 GMT+02:00 Maton, Brett <matonb@ltresources.co.uk>:

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@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org

--

SANDRO BONAZZOLA

ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D

Red Hat EMEA

sbonazzo@redhat.com   

--

Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.