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

[Stephan Eberle]

Thank you,

but I sort of have only one other VM called "gentoo1" in the table. I just checked via sqlite3 command line utility.

Strange things happen here,
Stevie

Am 22. Aug 2011 um 15:12 schrieb Florin Antonescu <florinantonescu at gmail.com>:

> 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
>
>     _______________________________________________
>     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/74033868/attachment-0002.htm>