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

Wed Jan 8 04:03:07 PST 2014

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]]></BRIDGE><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]]></BRIDGE><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