[Engine-devel] DataIntegrityViolationException when creating a new template

[Einav Cohen]

indeed, http://gerrit.ovirt.org/#/c/18453/ did the trick.
[I still cannot create the template, but that's due to a slow and 
problematic storage - I no longer see the exception that I originally 
reported]

Many thanks for your help!

----
Regards,
Einav

----- Original Message -----
> From: "Daniel Erez" <derez at redhat.com>
> To: "Einav Cohen" <ecohen at redhat.com>
> Cc: "engine-devel" <engine-devel at ovirt.org>
> Sent: Sunday, August 25, 2013 5:10:21 AM
> Subject: Re: [Engine-devel] DataIntegrityViolationException when creating a new	template
> 
> 
> 
> ----- Original Message -----
> > From: "Liron Aravot" <laravot at redhat.com>
> > To: "Omer Frenkel" <ofrenkel at redhat.com>
> > Cc: "engine-devel" <engine-devel at ovirt.org>
> > Sent: Sunday, August 25, 2013 11:37:49 AM
> > Subject: Re: [Engine-devel] DataIntegrityViolationException when creating a
> > new	template
> > 
> > 
> > 
> > ----- Original Message -----
> > > From: "Omer Frenkel" <ofrenkel at redhat.com>
> > > To: "Einav Cohen" <ecohen at redhat.com>
> > > Cc: "engine-devel" <engine-devel at ovirt.org>
> > > Sent: Sunday, August 25, 2013 11:23:55 AM
> > > Subject: Re: [Engine-devel] DataIntegrityViolationException when creating
> > > a
> > > new	template
> > > 
> > > 
> > > 
> > > ----- Original Message -----
> > > > From: "Einav Cohen" <ecohen at redhat.com>
> > > > To: "engine-devel" <engine-devel at ovirt.org>
> > > > Sent: Friday, August 23, 2013 10:54:07 PM
> > > > Subject: [Engine-devel] DataIntegrityViolationException when creating a
> > > > new
> > > > 	template
> > > > 
> > > > latest upstream, using development environment.
> > > > attempting to 'Make Template' results in an "internal engine error"
> > > > (see
> > > > attached screen-shot).
> > > > 
> > > > in engine.log, I see the following error:
> > > > org.springframework.dao.DataIntegrityViolationException:
> > > > CallableStatementCallback; SQL [{call insertvmdevice(?, ?, ?, ?, ?, ?,
> > > > ?,
> > > > ?,
> > > > ?, ?, ?, ?)}]; ERROR: null value in column "device_id" violates
> > > > not-null
> > > > constraint
> > > > [see attached engine.log, look for the 2013-08-23 15:40:04 time-stamp
> > > > to
> > > > see
> > > > the initial invocation of AddVmTemplateCommand, error above appears in
> > > > 2013-08-23 15:40:27]
> > > > 
> > > > ideas?
> > 
> > Seems like there's already a bug for that -
> > https://bugzilla.redhat.com/999951
> 
> As a quick workaround, detach the DirectLUN disks or apply:
> http://gerrit.ovirt.org/#/c/18453/
> 
> > > > 
> > > 
> > > did you remember to run "setup" in order to update your db?
> > > i just tried creating few templates and all worked ok
> > > 
> > > > Thanks in advance.
> > 
> > > > 
> > > > ----
> > > > Regards,
> > > > Einav Cohen Baum
> > > > RHEV-M Engineering - UX Team Manager
> > > > Red Hat, Inc.
> > > > 314 Littleton Road
> > > > Westford, MA 01886
> > > > T [internal]: (81) 31046
> > > > T [external]: (+1) 978 589 1046
> > > > IRC: ecohen @
> > > >  - RHAT [internal]: #rhev-dev #boston #westford #tlv
> > > >  - OFTC [external]: #ovirt
> > > > 
> > > > _______________________________________________
> > > > Engine-devel mailing list
> > > > Engine-devel at ovirt.org
> > > > http://lists.ovirt.org/mailman/listinfo/engine-devel
> > > > 
> > > _______________________________________________
> > > Engine-devel mailing list
> > > Engine-devel at ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/engine-devel
> > > 
> > _______________________________________________
> > Engine-devel mailing list
> > Engine-devel at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/engine-devel
> > 
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
> 
> 
>