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

Tino Vazquez cvazquez at c12g.com
Tue Jan 14 06:12:33 PST 2014


Hi Gerry,

You are right, the default in 4.4 is 60 seconds.

Best 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 1:38 PM, Gerry O'Brien <gerry at scss.tcd.ie> wrote:
> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org



More information about the Users mailing list