[one-users] Error creating VM: Error: [VirtualMachineAllocate] Error trying to CREATE VM Can not insert VM in the database.

[Florin Antonescu]

Check that VM name is unique.

On Mon, Aug 22, 2011 at 2:56 PM, Stephan Eberle <steviee at me.com> wrote:

> Hi,
>
> I just stumbled over this log entry:
>
> Mon Aug 22 13:52:02 2011 [ONE][E]: SQL command was: INSERT INTO vm_pool
> (oid,uid,name,last_poll,
> state,lcm_state,stime,etime,deploy_id,memory,cpu,net_tx,net_rx,last_seq,
> template) VALUES
> (7,0,'vssvn',0,1,0,1314013922,0,'',0,0,0,0,-1,'<TEMPLATE><CPU><![CDATA[0.8]]></CPU><DISK><CLONE><![CDATA[no]]></CLONE><DISK_ID><![CDATA[0]]></DISK_ID><DRIVER><![CDATA[raw]]></DRIVER><READONLY><![CDATA[no]]></READONLY><SAVE><![CDATA[yes]]></SAVE><SOURCE><![CDATA[/home/images/vs-svn-serv.img]]></SOURCE><TARGET><![CDATA[hda]]></TARGET><TYPE><![CDATA[disk]]></TYPE></DISK><FEATURES><ACPI><![CDATA[no]]></ACPI></FEATURES><GRAPHICS><KEYMAP><![CDATA[de]]></KEYMAP><LISTEN><![CDATA[xx.xx.xx.xx]]></LISTEN><PASSWD><![CDATA[falcon1]]></PASSWD><PORT><![CDATA[2]]></PORT><TYPE><![CDATA[vnc]]></TYPE></GRAPHICS><MEMORY><![CDATA[512]]></MEMORY><NAME><![CDATA[vssvn]]></NAME><NIC><BRIDGE><![CDATA[virbr0]]></BRIDGE><IP><![CDATA[192.168.122.2]]></IP><MAC><![CDATA[02:00:c0:a8:7a:02]]></MAC><NETWORK><![CDATA[external]]></NETWORK><NETWORK_ID><![CDATA[0]]></NETWORK_ID></NIC><OS><ARCH><![CDATA[i686]]></ARCH><BOOT><![CDATA[hd]]></BOOT></OS><PUBLIC><![CDATA[YES]]></PUBLIC><RAW><TYPE><![CDATA[kvm]]></TYPE></RAW><TYPE><![CDATA[KVM]]></TYPE><VCPU><![CDATA[1]]></VCPU><VMID><![CDATA[8]]></VMID><VMID><![CDATA[7]]></VMID></TEMPLATE>'),
> error: PRIMARY KEY must be unique
> Mon Aug 22 13:52:02 2011 [ONE][E]: Can not insert VM in the database.
> Mon Aug 22 13:52:02 2011 [ReM][E]: [VirtualMachineAllocate] Error trying to
> CREATE VM Can not insert VM in the database.
>
>
> Any idea of how to fix this!?
>
> Best regards,
> Stevie
>
>
> Am 22. Aug 2011 um 12:28 schrieb Stephan Eberle <steviee at me.com>:
>
> Hi,
>
> I'm currently trying to add a pre-existing qemu-image to my newly installed
> ONE service via
>
> onevm create ./vs-svn-serv.tpl
>
> and I'm getting this message:
>
> Error: [VirtualMachineAllocate] Error trying to CREATE VM Can not insert VM
> in the database.
>
> Is this due to some missing arguments in the template? What's the cause?
>
> Thank's in advance,
> Stevie
>
>
>
> PS: My template looks like this:
>
>
> #---------------------------------------
> # VM definition example
> #---------------------------------------
>
> NAME = "vs-svn-serv-1"
>
> CPU    = 0.8
> MEMORY = 512
> PUBLIC = YES
>
> # --- disks ---
>
> DISK = [
>   source   = "/home/images/vs-svn-serv.img",
>   target   = "hda",
>   driver   = "raw",
>   readonly = "no" ]
>
> # --- 1 NIC ---
>
> NIC = [ NETWORK="external"]
>
> FEATURES=[ acpi="no" ]
>
> # --- VNC server ---
>
> GRAPHICS = [
>   type    = "vnc",
>   listen  = "xx.xx.xx.xx",
>   port    = "5902"]
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfocgi/users-opennebula.org<http://lists.opennebula.org/listinfo.cgi/users-opennebula.org>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20110822/9b30b102/attachment-0003.htm>