[Engine-devel] DataIntegrityViolationException when creating a new template

[Daniel Erez]

----- 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
>