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 ?
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 <https://www.redhat.com/> sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
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 <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
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 <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
On Fri, May 25, 2018 at 1: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.
Please try and share upgrade logs. I've just quickly tried the upgrade from 4.2.3.7 to 4.2.4 and db upgrade was OK. Thanks Martin
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 <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
-- 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@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 <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
I rebuilt that environment, I'll try to recreate the scenario and provide the information requested. On 27 May 2018 at 09:17, Eli Mesika <emesika@redhat.com> wrote:
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 <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
participants (4)
-
Eli Mesika -
Martin Perina -
Maton, Brett -
Sandro Bonazzola