<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jul 7, 2016 at 10:05 AM, Michal Skrivanek <span dir="ltr">&lt;<a href="mailto:michal.skrivanek@redhat.com" target="_blank">michal.skrivanek@redhat.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5"><br>
&gt; On 07 Jul 2016, at 08:54, Tomas Jelinek &lt;<a href="mailto:tjelinek@redhat.com">tjelinek@redhat.com</a>&gt; wrote:<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; ----- Original Message -----<br>
&gt;&gt; From: &quot;Yaniv Kaul&quot; &lt;<a href="mailto:ykaul@redhat.com">ykaul@redhat.com</a>&gt;<br>
&gt;&gt; To: &quot;devel&quot; &lt;<a href="mailto:devel@ovirt.org">devel@ovirt.org</a>&gt;<br>
&gt;&gt; Sent: Sunday, July 3, 2016 12:59:29 PM<br>
&gt;&gt; Subject: [ovirt-devel] (MASTER) exception on server.log: ERROR: insert or update on table &quot;host_device&quot; violates<br>
&gt;&gt; foreign key constraint &quot;fk_host_device_parent_name&quot;<br>
&gt;&gt;<br>
&gt;&gt; Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on<br>
&gt;&gt; table &quot;host_device&quot; violates foreign key constraint<br>
&gt;&gt; &quot;fk_host_device_parent_name&quot;<br>
&gt;&gt; Detail: Key (host_id,<br>
&gt;&gt; parent_device_name)=(767142d5-6242-4bb1-bcbd-095595c3b7f1, scsi_host2) is<br>
&gt;&gt; not present in table &quot;host_device&quot;.<br>
&gt;&gt; at<br>
&gt;&gt; org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)<br>
&gt;&gt; at<br>
&gt;&gt; org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)<br>
&gt;&gt; at<br>
&gt;&gt; org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)<br>
&gt;&gt; at<br>
&gt;&gt; org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:793)<br>
&gt;&gt; at<br>
&gt;&gt; org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:817)<br>
&gt;&gt; at<br>
&gt;&gt; org.jboss.jca.adapters.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:96)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Seen on<br>
&gt;&gt; ovirt-engine-4.1.0-0.0.master.20160701111322.gitf1c9a5c.el7.centos.noarch<br>
&gt;&gt; Y.<br>
&gt;<br>
&gt; it is a known issue: <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1315100" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=1315100</a> (ugly stack trace but not dangerous by itself)<br>
&gt; caused by underlying libvirt issue: <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1306333" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=1306333</a><br>
&gt; which seems to be hard to reproduce consistently and no one have found a good reproducer so far...<br>
&gt; So, if you have faced this issue and know how did you get to it, please comment to the bug.<br>
<br>
</div></div>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.<br></blockquote><div><br></div><div>- I&#39;ve seen it on Lago.</div><div>- We do perform hot add of disk and NIC in ovirt-system-tests, AFAIR.</div><div>Y.</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br>
&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Devel mailing list<br>
&gt;&gt; <a href="mailto:Devel@ovirt.org">Devel@ovirt.org</a><br>
&gt;&gt; <a href="http://lists.ovirt.org/mailman/listinfo/devel" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/devel</a><br>
&gt; _______________________________________________<br>
&gt; Devel mailing list<br>
&gt; <a href="mailto:Devel@ovirt.org">Devel@ovirt.org</a><br>
&gt; <a href="http://lists.ovirt.org/mailman/listinfo/devel" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/devel</a><br>
&gt;<br>
&gt;<br>
<br>
</div></div></blockquote></div><br></div></div>