Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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 ab...@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 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 ab...@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 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
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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 ab...@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 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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-1638316482832126958740276789301916380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'),
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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 ab...@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 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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-163831648283212695874
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-1638316482832126958740276789301916380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-1638316482832126958740276789301916380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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 -- 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 -- Gerry O'Brien Systems Manager School of Computer Science and Statistics Trinity College Dublin Dublin 2 IRELAND 00 353 1 896 1341 _
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019>> >>> DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), >>> 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019>> >>> DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), >>> 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 > > > > -- > Gerry O'Brien > > Systems Manager > School of Computer Science and Statistics > Trinity College Dublin > Dublin 2 > IRELAND > > 00 353 1 896 1341 > > > ___ > Users mail
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-1638316482832126958740276789301916380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-1638316482832126958740276789301916380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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 -- 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
Re: [one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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 ab...@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 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019 DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), > 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019 DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), > 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 ___ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
[one-users] V4.4 sqlite bug? error: columns vmid, last_poll are not unique
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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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,'163800oneadminoneadminW7-64bit-VLabA_711000138913688433013873038360one-16383164828321269587402767893019DGE>16380host011.scss.tcd.ie2310013873038370kvmdummyshared/var/lib/one//datastores01387303837138730383713873038370'), 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