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"

2016-07-07 Thread Yaniv Kaul 
On Thu, Jul 7, 2016 at 10:05 AM, Michal Skrivanek <
michal.skriva...@redhat.com> wrote:

>
> > On 07 Jul 2016, at 08:54, Tomas Jelinek  wrote:
> >
> >
> >
> > - Original Message -
> >> From: "Yaniv Kaul" 
> >> To: "devel" 
> >> 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.2016070322.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
> >
> >
>
>
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

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"

2016-07-07 Thread Michal Skrivanek 

> On 07 Jul 2016, at 08:54, Tomas Jelinek  wrote:
> 
> 
> 
> - Original Message -
>> From: "Yaniv Kaul" 
>> To: "devel" 
>> 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.2016070322.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
> 
> 

___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

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"

2016-07-07 Thread Tomas Jelinek 


- Original Message -
> From: "Yaniv Kaul" 
> To: "devel" 
> 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.2016070322.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
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel