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

> On 07 Jul 2016, at 08:54, Tomas Jelinek <tjelinek(a)redhat.com&gt; wrote: > > > > ----- Original Message ----- >> From: "Yaniv Kaul" <ykaul(a)redhat.com&gt; >> To: "devel" <devel(a)ovirt.org&gt; >> 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(a)ovirt.org >> http://lists.ovirt.org/mailman/listinfo/devel > _______________________________________________ > Devel mailing list > Devel(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/devel > >