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

[Michal Skrivanek]

> 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.

> 
>> 
>> 
>> _______________________________________________
>> 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
> 
>