[ovirt-devel] (MASTER) exception on server.log: ERROR: insert or update on table "host_device" violates foreign key constraint "fk_host_device_parent_name"

[Yaniv Kaul]

On Thu, Jul 7, 2016 at 10:05 AM, Michal Skrivanek <
michal.skrivanek at redhat.com> wrote:

>
> > On 07 Jul 2016, at 08:54, Tomas Jelinek <tjelinek at redhat.com> wrote:
> >
> >
> >
> > ----- Original Message -----
> >> From: "Yaniv Kaul" <ykaul at redhat.com>
> >> To: "devel" <devel at ovirt.org>
> >> Sent: Sunday, July 3, 2016 12:59:29 PM
> >> Subject: [ovirt-devel] (MASTER) exception on server.log: ERROR: insert
> or update on table "host_device" violates
> >> foreign key constraint "fk_host_device_parent_name"
> >>
> >> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
> >> table "host_device" violates foreign key constraint
> >> "fk_host_device_parent_name"
> >> Detail: Key (host_id,
> >> parent_device_name)=(767142d5-6242-4bb1-bcbd-095595c3b7f1, scsi_host2)
> is
> >> not present in table "host_device".
> >> at
> >>
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
> >> at
> >>
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
> >> at
> >>
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> >> at
> >>
> org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:793)
> >> at
> >>
> org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:817)
> >> at
> >>
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:96)
> >>
> >>
> >> Seen on
> >>
> ovirt-engine-4.1.0-0.0.master.20160701111322.gitf1c9a5c.el7.centos.noarch
> >> Y.
> >
> > it is a known issue: https://bugzilla.redhat.com/show_bug.cgi?id=1315100
> (ugly stack trace but not dangerous by itself)
> > caused by underlying libvirt issue:
> https://bugzilla.redhat.com/show_bug.cgi?id=1306333
> > which seems to be hard to reproduce consistently and no one have found a
> good reproducer so far...
> > So, if you have faced this issue and know how did you get to it, please
> comment to the bug.
>
> Important thing to note would be if this is a real hw or lago/virtual
> host, and whether there is a history of adding/removing of a device on that
> host while running.
>

- I've seen it on Lago.
- We do perform hot add of disk and NIC in ovirt-system-tests, AFAIR.
Y.


> >
> >>
> >>
> >> _______________________________________________
> >> Devel mailing list
> >> Devel at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/devel
> > _______________________________________________
> > Devel mailing list
> > Devel at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/devel
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20160707/b6d2cebb/attachment-0001.html>