[one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique

Wed Jan 8 08:11:00 PST 2014

Hi Tino,

     Thanks for the update. I'd prefer not to recompile so I'll wait for 
the next release.

     In the meantime, is there any way to lessen the logging. Would 
decreasing the frequency of monitoring help?

         Regards,
           Gerry

On 08/01/2014 14:10, Tino Vazquez wrote:
> Hi,
>
> This bug has been corrected on the development branch [1], so this
> will be fixed in future releases.
>
> Since the fix is done in the core, I am afraid you need to apply the
> patch and recompile OpenNebula.
>
> Regards,
>
> -Tino
>
> [1] http://dev.opennebula.org/issues/2544
> --
> OpenNebula - Flexible Enterprise Cloud Made Simple
>
> --
> Constantino Vázquez Blanco, PhD, MSc
> Senior Infrastructure Architect at C12G Labs
> www.c12g.com | @C12G | es.linkedin.com/in/tinova
>
> --
> Confidentiality Warning: The information contained in this e-mail and
> any accompanying documents, unless otherwise expressly indicated, is
> confidential and privileged, and is intended solely for the person
> and/or entity to whom it is addressed (i.e. those identified in the
> "To" and "cc" box). They are the property of C12G Labs S.L..
> Unauthorized distribution, review, use, disclosure, or copying of this
> communication, or any part thereof, is strictly prohibited and may be
> unlawful. If you have received this e-mail in error, please notify us
> immediately by e-mail at abuse at c12g.com and delete the e-mail and
> attachments and any copy from your system. C12G thanks you for your
> cooperation.
>
>
> On Wed, Jan 8, 2014 at 1:03 PM, Gerry O'Brien <gerry at scss.tcd.ie> wrote:
>> Hi,
>>
>>      Below are entries from /var/log/one/oned.log which report error: error:
>> columns vmid, last_poll are not unique. It looks like the monitoring of VM
>> 1638 and VM 1634. However, the SQL INSERT commands are the same which causes
>> the error. This also happens for host_moitoring. It is generating a lot of
>> error logging.
>>
>>      Any suggestions how I can avoid all this logging?
>>
>>          Regards,
>>            Gerry
>>
>>
>>
>>
>>
>> Tue Jan  7 23:21:24 2014 [ONE][E]: SQL command was: INSERT INTO
>> vm_monitoring (vmid, last_poll, body) VALUES
>> (1638,1389136884,'<VM><ID>1638</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>W7-64bit-VLabA_7</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>1389136884</LAST_POLL><STATE>3</STATE><LCM_STATE>3</LCM_STATE><RESCHED>0</RESCHED><STIME>1387303836</STIME><ETIME>0</ETIME><DEPLOY_ID>one-1638</DEPLOY_ID><MEMORY>3164828</MEMORY><CPU>3</CPU><NET_TX>2126958740</NET_TX><NET_RX>2767893019</NET_RX><TEMPLATE><AUTOMATIC_REQUIREMENTS><![CDATA[CLUSTER_ID
>> =
>> 100]]></AUTOMATIC_REQUIREMENTS><CPU><![CDATA[1]]></CPU><DISK><CLONE><![CDATA[NO]]></CLONE><CLUSTER_ID><![CDATA[100]]></CLUSTER_ID><DATASTORE><![CDATA[default]]></DATASTORE><DATASTORE_ID><![CDATA[1]]></DATASTORE_ID><DEV_PREFIX><![CDATA[hd]]></DEV_PREFIX><DISK_ID><![CDATA[0]]></DISK_ID><DRIVER><![CDATA[qcow2]]></DRIVER><IMAGE><![CDATA[W7-64bit-VLabA_7]]></IMAGE><IMAGE_ID><![CDATA[178]]></IMAGE_ID><IMAGE_UNAME><![CDATA[oneadmin]]></IMAGE_UNAME><PERSISTENT><![CDATA[YES]]></PERSISTENT><READONLY><![CDATA[NO]]></READONLY><SAVE><![CDATA[YES]]></SAVE><SOURCE><![CDATA[/var/lib/one/datastores/1/17e28fe1e8304845010656ef44e172f1]]></SOURCE><TARGET><![CDATA[hda]]></TARGET><TM_MAD><![CDATA[shared]]></TM_MAD><TYPE><![CDATA[FILE]]></TYPE></DISK><GRAPHICS><LISTEN><![CDATA[0.0.0.0]]></LISTEN><PORT><![CDATA[7538]]></PORT><TYPE><![CDATA[vnc]]></TYPE></GRAPHICS><INPUT><BUS><![CDATA[usb]]></BUS><TYPE><![CDATA[tablet]]></TYPE></INPUT><MEMORY><![CDATA[3072]]></MEMORY><NIC><BRIDGE><![CDATA[br0]]></BRI
>> DGE><CLUSTER_ID><![CDATA[100]]></CLUSTER_ID><IP><![CDATA[X.X.X.79]]></IP><IP6_LINK><![CDATA[fe80::400:86ff:fee2:3c4f]]></IP6_LINK><MAC><![CDATA[02:00:86:e2:3c:4f]]></MAC><NETWORK><![CDATA[oneadminNET
>> X.X.X.1-.X.X.X.250]]></NETWORK><NETWORK_ID><![CDATA[1]]></NETWORK_ID><NETWORK_UNAME><![CDATA[oneadmin]]></NETWORK_UNAME><NIC_ID><![CDATA[0]]></NIC_ID><VLAN><![CDATA[NO]]></VLAN></NIC><OS><ARCH><![CDATA[x86_64]]></ARCH><BOOT><![CDATA[hd]]></BOOT></OS><RAW><TYPE><![CDATA[kvm]]></TYPE></RAW><TEMPLATE_ID><![CDATA[132]]></TEMPLATE_ID><VCPU><![CDATA[4]]></VCPU><VMID><![CDATA[1638]]></VMID></TEMPLATE><USER_TEMPLATE></USER_TEMPLATE><HISTORY_RECORDS><HISTORY><OID>1638</OID><SEQ>0</SEQ><HOSTNAME>host011.scss.tcd.ie</HOSTNAME><HID>23</HID><CID>100</CID><STIME>1387303837</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>1387303837</PSTIME><PETIME>1387303837</PETIME><RSTIME>1387303837</RSTIME><RETIME>0</RETIME><ESTIME>0</ESTIME><EETIME>0</EETIME><REASON>0</REASON><ACTION>0</ACTION></HISTORY></HISTORY_RECORDS></VM>'),
>> error: columns vmid, last_poll are not unique
>> Tue Jan  7 23:21:24 2014 [VMM][D]: VM 1638 successfully monitored: STATE=a
>> USEDCPU=3.0 USEDMEMORY=3164828 NETRX=2767893019 NETTX=2126958740
>>
>>
>> Tue Jan  7 23:21:24 2014 [ONE][E]: SQL command was: INSERT INTO
>> vm_monitoring (vmid, last_poll, body) VALUES
>> (1638,1389136884,'<VM><ID>1638</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>W7-64bit-VLabA_7</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>1389136884</LAST_POLL><STATE>3</STATE><LCM_STATE>3</LCM_STATE><RESCHED>0</RESCHED><STIME>1387303836</STIME><ETIME>0</ETIME><DEPLOY_ID>one-1638</DEPLOY_ID><MEMORY>3164828</MEMORY><CPU>3</CPU><NET_TX>2126958740</NET_TX><NET_RX>2767893019</NET_RX><TEMPLATE><AUTOMATIC_REQUIREMENTS><![CDATA[CLUSTER_ID
>> =
>> 100]]></AUTOMATIC_REQUIREMENTS><CPU><![CDATA[1]]></CPU><DISK><CLONE><![CDATA[NO]]></CLONE><CLUSTER_ID><![CDATA[100]]></CLUSTER_ID><DATASTORE><![CDATA[default]]></DATASTORE><DATASTORE_ID><![CDATA[1]]></DATASTORE_ID><DEV_PREFIX><![CDATA[hd]]></DEV_PREFIX><DISK_ID><![CDATA[0]]></DISK_ID><DRIVER><![CDATA[qcow2]]></DRIVER><IMAGE><![CDATA[W7-64bit-VLabA_7]]></IMAGE><IMAGE_ID><![CDATA[178]]></IMAGE_ID><IMAGE_UNAME><![CDATA[oneadmin]]></IMAGE_UNAME><PERSISTENT><![CDATA[YES]]></PERSISTENT><READONLY><![CDATA[NO]]></READONLY><SAVE><![CDATA[YES]]></SAVE><SOURCE><![CDATA[/var/lib/one/datastores/1/17e28fe1e8304845010656ef44e172f1]]></SOURCE><TARGET><![CDATA[hda]]></TARGET><TM_MAD><![CDATA[shared]]></TM_MAD><TYPE><![CDATA[FILE]]></TYPE></DISK><GRAPHICS><LISTEN><![CDATA[0.0.0.0]]></LISTEN><PORT><![CDATA[7538]]></PORT><TYPE><![CDATA[vnc]]></TYPE></GRAPHICS><INPUT><BUS><![CDATA[usb]]></BUS><TYPE><![CDATA[tablet]]></TYPE></INPUT><MEMORY><![CDATA[3072]]></MEMORY><NIC><BRIDGE><![CDATA[br0]]></BRI
>> DGE><CLUSTER_ID><![CDATA[100]]></CLUSTER_ID><IP><![CDATA[X.X.X.79]]></IP><IP6_LINK><![CDATA[fe80::400:86ff:fee2:3c4f]]></IP6_LINK><MAC><![CDATA[02:00:86:e2:3c:4f]]></MAC><NETWORK><![CDATA[oneadminNET
>> X.X.X.1-X.X.X.250]]></NETWORK><NETWORK_ID><![CDATA[1]]></NETWORK_ID><NETWORK_UNAME><![CDATA[oneadmin]]></NETWORK_UNAME><NIC_ID><![CDATA[0]]></NIC_ID><VLAN><![CDATA[NO]]></VLAN></NIC><OS><ARCH><![CDATA[x86_64]]></ARCH><BOOT><![CDATA[hd]]></BOOT></OS><RAW><TYPE><![CDATA[kvm]]></TYPE></RAW><TEMPLATE_ID><![CDATA[132]]></TEMPLATE_ID><VCPU><![CDATA[4]]></VCPU><VMID><![CDATA[1638]]></VMID></TEMPLATE><USER_TEMPLATE></USER_TEMPLATE><HISTORY_RECORDS><HISTORY><OID>1638</OID><SEQ>0</SEQ><HOSTNAME>host011.scss.tcd.ie</HOSTNAME><HID>23</HID><CID>100</CID><STIME>1387303837</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>1387303837</PSTIME><PETIME>1387303837</PETIME><RSTIME>1387303837</RSTIME><RETIME>0</RETIME><ESTIME>0</ESTIME><EETIME>0</EETIME><REASON>0</REASON><ACTION>0</ACTION></HISTORY></HISTORY_RECORDS></VM>'),
>> error: columns vmid, last_poll are not unique
>> Tue Jan  7 23:21:24 2014 [VMM][D]: VM 1634 successfully monitored: STATE=a
>> USEDCPU=3.5 USEDMEMORY=3145728 NETRX=2319913244 NETTX=2766610850
>>
>> --
>> Gerry O'Brien
>>
>> Systems Manager
>> School of Computer Science and Statistics
>> Trinity College Dublin
>> Dublin 2
>> IRELAND
>>
>> 00 353 1 896 1341
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opennebula.org
>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org

-- 
Gerry O'Brien

Systems Manager
School of Computer Science and Statistics
Trinity College Dublin
Dublin 2
IRELAND

00 353 1 896 1341