[one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
Gerry O'Brien
gerry at scss.tcd.ie
Thu Jan 9 04:38:15 PST 2014
Hi Tino,
My default 4.4 oned.conf has the setting below.
Gerry
#MANAGER_TIMER = 30
MONITORING_INTERVAL = 60
MONITORING_THREADS = 50
#HOST_PER_INTERVAL = 15
#HOST_MONITORING_EXPIRATION_TIME = 43200
#VM_PER_INTERVAL = 5
#VM_MONITORING_EXPIRATION_TIME = 14400
On 09/01/2014 11:54, Tino Vazquez wrote:
> Hi Gerry,
>
> You can set it in /etc/one/oned.conf,
>
> MONITORING_INTERVAL=10
>
> The default is 10 seconds. You need to restart OpenNebula after making
> the change.
>
> Regards,
>
> -Tino
>
> --
> 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 Thu, Jan 9, 2014 at 11:52 AM, Gerry O'Brien <gerry at scss.tcd.ie> wrote:
>> Hi Tino,
>>
>> Where can I set the monitoring interval?
>>
>> Gerry
>>
>>
>> On 09/01/2014 09:53, Tino Vazquez wrote:
>>> Hi Gerry,
>>>
>>> This is an error message, so it cannot be disabled. A lower monitoring
>>> interval value would help, but the monitoring information won't be as
>>> precise.
>>>
>>> Regards,
>>>
>>> -Tino
>>>
>>> --
>>> 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 5:11 PM, Gerry O'Brien <gerry at scss.tcd.ie> wrote:
>>>> 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
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>> _______________________________________________
>> 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
More information about the Users
mailing list