[one-users] Re; Database errors ..

Sat Dec 7 18:28:06 PST 2013

Hi Guys, 

I'm using 4.4 from the Ubuntu repo's on 13.10 .. I seem to be seeing a lot of duplicate key errors in oned.log, I'm 
using MySQL as opposed to SQlite .. not sure how much you need to look at this, but here's a sample entry; 

Fri Dec 6 06:55:23 2013 [ONE][E]: SQL command was: INSERT INTO vm_monitoring (vmid, last_poll, body) VALUES (1212,1386312923,'<VM><ID>1212</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>VMs x 120</NAME><PERMISSIONS><OWNER_U>1</OWNER_U><OWNER_M>1</OWNER_M><OWNER_A>0</OWNER_A><GROUP_U>0</GROUP_U><GROUP_M>0</GROUP_M><GROUP_A>0</GROUP_A><OTHER_U>0</OTHER_U><OTHER_M>0</OTHER_M><OTHER_A>0</OTHER_A></PERMISSIONS><LAST_POLL>1386312923</LAST_POLL><STATE>3</STATE><LCM_STATE>3</LCM_STATE><RESCHED>0</RESCHED><STIME>1386291942</STIME><ETIME>0</ETIME><DEPLOY_ID>one-1212</DEPLOY_ID><MEMORY>1048576</MEMORY><CPU>1</CPU><NET_TX>293484</NET_TX><NET_RX>3240611</NET_RX><TEMPLATE><AUTOMATIC_REQUIREMENTS><![CDATA[!(PUBLIC_CLOUD = YES)]]></AUTOMATIC_REQUIREMENTS><CONTEXT><DISK_ID><![CDATA[1]]></DISK_ID><ETH0_DNS><![CDATA[8.8.8.8]]></ETH0_DNS><ETH0_GATEWAY><![CDATA[193.111.184.1]]></ETH0_GATEWAY><ETH0_IP><![CDATA[193.111.184.23]]></ETH0_IP><ETH0_MAC><![CDATA[02:00:c1:6f:b8:17]]></ETH0_MAC><ETH0_MASK><![CDATA[255.255.255.0]]></ETH0_MASK><ETH0_NETWORK><![CDATA[193.111.184.0]]></ETH0_NETWORK><HOSTNAME><![CDATA[ubuntu]]></HOSTNAME><NETWORK><![CDATA[YES]]></NETWORK><SSH_PUBLIC_KEY><![CDATA[ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEAyE9S5uFGAZtah0vpxtY9LN8g0004rqSU/QEvm6OFdB3RUN8hE2MT229nNveVm/xpk2kfV8dXyWZuLQg2QP+0b41DZmDPauRo3cWo80mwoM54hkNaVWlHCHaiag90U4mPPEyFlpcETijBtMkIoC3TEe09X/WcKDbGh4Spw466Cyk= oddjob at squizzey.linux.co.uk]]></SSH_PUBLIC_KEY><TARGET><![CDATA[hda]]></TARGET><VDC_CACHE_SIZE><![CDATA[1G]]></VDC_CACHE_SIZE></CONTEXT><CPU><![CDATA[0.1]]></CPU><DISK><CACHE><![CDATA[writethrough]]></CACHE><CLONE><![CDATA[YES]]></CLONE><CLONE_TARGET><![CDATA[SYSTEM]]></CLONE_TARGET><DATASTORE><![CDATA[data2]]></DATASTORE><DATASTORE_ID><![CDATA[109]]></DATASTORE_ID><DEV_PREFIX><![CDATA[sd]]></DEV_PREFIX><DISK_ID><![CDATA[0]]></DISK_ID><DRIVER><![CDATA[raw]]></DRIVER><IMAGE><![CDATA[Ubuntu 13.10 - NP2]]></IMAGE><IMAGE_ID><![CDATA[84]]></IMAGE_ID><IO><![CDATA[native]]></IO><LN_TARGET><![CDATA[SYSTEM]]></LN_TARGET><READONLY><![CDATA[NO]]></READONLY><SAVE><![CDATA[NO]]></SAVE><SIZE><![CDATA[514]]></SIZE><SOURCE><![CDATA[/var/lib/one//datastores/109/9223f9298b062fdcaaeaf82620998d5e]]></SOURCE><TARGET><![CDATA[sda]]></TARGET><TM_MAD><![CDATA[vdc]]></TM_MAD><TYPE><![CDATA[FILE]]></TYPE></DISK><FEATURES><ACPI><![CDATA[yes]]></ACPI><PAE><![CDATA[no]]></PAE></FEATURES><GRAPHICS><LISTEN><![CDATA[0.0.0.0]]></LISTEN><PORT><![CDATA[7112]]></PORT><TYPE><![CDATA[VNC]]></TYPE></GRAPHICS><MEMORY><![CDATA[1024]]></MEMORY><NIC><BRIDGE><![CDATA[public]]></BRIDGE><IP><![CDATA[193.111.184.23]]></IP><IP6_LINK><![CDATA[fe80::400:c1ff:fe6f:b817]]></IP6_LINK><MAC><![CDATA[02:00:c1:6f:b8:17]]></MAC><MODEL><![CDATA[virtio]]></MODEL><NETWORK><![CDATA[Public IP Range]]></NETWORK><NETWORK_ID><![CDATA[8]]></NETWORK_ID><NIC_ID><![CDATA[0]]></NIC_ID><VLAN><![CDATA[NO]]></VLAN></NIC><OS><ARCH><![CDATA[x86_64]]></ARCH><BOOT><![CDATA[hd]]></BOOT><GUESTOS><![CDATA[debian5_64Guest]]></GUESTOS></OS><RAW><DATA><![CDATA[undefined]]></DATA><DATA_VMX><![CDATA[undefined]]></DATA_VMX><TYPE><![CDATA[undefined]]></TYPE></RAW><TEMPLATE_ID><![CDATA[25]]></TEMPLATE_ID><VCPU><![CDATA[2]]></VCPU><VMID><![CDATA[1212]]></VMID></TEMPLATE><USER_TEMPLATE><SCHED_MESSAGE><![CDATA[Fri Dec 6 01:15:21 2013 : No host with enough capacity to deploy the VM]]></SCHED_MESSAGE></USER_TEMPLATE><HISTORY_RECORDS><HISTORY><OID>1212</OID><SEQ>0</SEQ><HOSTNAME>node1</HOSTNAME><HID>40</HID><CID>-1</CID><STIME>1386292525</STIME><ETIME>0</ETIME><VMMMAD>kvm</VMMMAD><VNMMAD>dummy</VNMMAD><TMMAD>shared</TMMAD><DS_LOCATION>/var/lib/one//datastores</DS_LOCATION><DS_ID>0</DS_ID><PSTIME>1386292525</PSTIME><PETIME>1386293498</PETIME><RSTIME>1386293498</RSTIME><RETIME>0</RETIME><ESTIME>0</ESTIME><EETIME>0</EETIME><REASON>0</REASON><ACTION>0</ACTION></HISTORY></HISTORY_RECORDS></VM>'), error 1062 : Duplicate entry '1212-1386312923' for key 'PRIMARY' 
Everything else is working, but I guess I'm missing some logging ?? 

-- 
	Gareth Bult 
“The odds of hitting your target go up dramatically when you aim at it.” 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20131208/f49a96c5/attachment.htm>