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

[Stephan Eberle]

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 <stev...@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@lists.opennebula.org
http://lists.opennebula.org/listinfocgi/users-opennebula.org

_______________________________________________
Users mailing list
Users@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org