<div dir="ltr">Hi<div><br></div><div>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.</div>
<div><br></div><div>I've already filled a bug for this.</div><div><br></div><div><a href="http://dev.opennebula.org/issues/2544">http://dev.opennebula.org/issues/2544</a><br></div><div><br></div><div>Cheers</div><div>
<br></div><div>Ruben</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Dec 8, 2013 at 3:28 AM, Gareth Bult <span dir="ltr"><<a href="mailto:gareth@linux.co.uk" target="_blank">gareth@linux.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:12pt;font-family:trebuchet ms,sans-serif"><div>Hi Guys,</div><div><br></div><div>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</div>
<div>using MySQL as opposed to SQlite .. not sure how much you need to look at this, but here's a sample entry;</div><div><p><span style="font-family:'courier new',courier,monaco,monospace,sans-serif">Fri Dec 6 06:55:23 2013 [ONE][E]: <strong>SQL command was: INSERT INTO vm_monitoring (vmid, last_poll, body) VALUES</strong> (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= <a href="mailto:oddjob@squizzey.linux.co.uk" target="_blank">oddjob@squizzey.linux.co.uk</a>]]></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>'), <strong>error 1062 : Duplicate entry '1212-1386312923' for key 'PRIMARY'</strong></span></p>
</div><div>Everything else is working, but I guess I'm missing some logging ??</div><div><br></div><div><span name="x"></span><div><div><span size="2" style="font-size:small">--</span></div><div><span class="HOEnZb"><font color="#888888"></font></span><table>
<tbody><tr><td><img></td><td><b style="font-family:verdana,Helvetica,sans-serif;font-size:11px;line-height:14px">Gareth Bult</b><br><span color="#666666" style="color:#666666"><span face="verdana, Helvetica, sans-serif" style="font-family:verdana,Helvetica,sans-serif"><span style="font-size:11px;line-height:14px">“The odds of hitting your target go up dramatically when you aim at it.”</span></span></span><span color="#666666" style="color:#666666"><br>
</span><span color="#666666" style="color:#666666"><br></span><span color="#666666" style="color:#666666"><br></span></td></tr></tbody></table></div></div><span name="x"></span><br></div></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</a><br>
<a href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org" target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div><div>-- <br></div></div>Ruben S. Montero, PhD<br>Project co-Lead and Chief Architect<div>OpenNebula - Flexible Enterprise Cloud Made Simple<br>
<a href="http://www.OpenNebula.org" target="_blank">www.OpenNebula.org</a> | <a href="mailto:rsmontero@opennebula.org" target="_blank">rsmontero@opennebula.org</a> | @OpenNebula</div></div>
</div>