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

[Tomas Jelinek]

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

> 
> 
> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel