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@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
