[one-users] Re; Database errors ..

Sun Dec 8 10:09:27 PST 2013

Hi

This error is because just one monitoring value per time point. This is
just for the monitoring table so you can safely ignore this. Probably this
is happening because a rapid monitoring pace.

I've already filled a bug for this.

http://dev.opennebula.org/issues/2544

Cheers

Ruben

On Sun, Dec 8, 2013 at 3:28 AM, Gareth Bult <gareth at linux.co.uk> wrote:

> 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.”
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
>

-- 
-- 
Ruben S. Montero, PhD
Project co-Lead and Chief Architect
OpenNebula - Flexible Enterprise Cloud Made Simple
www.OpenNebula.org | rsmontero at opennebula.org | @OpenNebula
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20131208/46c20bbb/attachment-0002.htm>