(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.
----- Original Message -----
From: "Yaniv Kaul" <ykaul@redhat.com> To: "devel" <devel@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
On 07 Jul 2016, at 08:54, Tomas Jelinek <tjelinek@redhat.com> wrote:
----- Original Message -----
From: "Yaniv Kaul" <ykaul@redhat.com> To: "devel" <devel@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
On Thu, Jul 7, 2016 at 10:05 AM, Michal Skrivanek < michal.skrivanek@redhat.com> wrote:
On 07 Jul 2016, at 08:54, Tomas Jelinek <tjelinek@redhat.com> wrote:
----- Original Message -----
From: "Yaniv Kaul" <ykaul@redhat.com> To: "devel" <devel@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
participants (3)
-
Michal Skrivanek -
Tomas Jelinek -
Yaniv Kaul