[one-users] Exception in oneacct

[Daniel Molina]

Hi,

I found out the problem. This patch should fix the problem.

http://dev.opennebula.org/projects/opennebula/repository/revisions/6176e07bac684135cbfe1cd46f9213cc8b41a371/diff/src/acct/watch_helper.rb

This patch is already included in 3.2-beta1 packages.

Kind regards

On 21 December 2011 11:02, Humberto N. Castejon Martinez <humcasma at gmail.com
> wrote:

> Hi,
>
> I am running Openenebula 3.0 and have enabled the Accounting and
> Statistics module, using MySql (and have applied the patch indicated in the
> documentation). I can see the graphs with monitoring information in
> Sunstone, but from time to time oneacctd crashes. This is the content of
> the /var/log/one/onecacctd.log:
>
> Tue Dec 20 17:14:57 +0100 2011 OneWatch::VmMonitoring
> Tue Dec 20 17:19:57 +0100 2011 OneWatch::VmMonitoring
> Tue Dec 20 17:24:57 +0100 2011 OneWatch::VmMonitoring
> Tue Dec 20 17:24:57 +0100 2011 OneWatch::HostMonitoring
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in
> `query': Mysql::Error: Duplicate entry '1-0' for key 'PRIMARY'
> (Sequel::DatabaseError)
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in
> `_execute'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/logging.rb:28:in
> `log_yield'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in
> `_execute'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in
> `execute'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:71:in
> `hold'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in
> `synchronize'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in
> `execute'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:74:in
> `execute_dui'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/dataset/actions.rb:657:in
> `execute_dui'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:346:in
> `execute_dui'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:334:in
> `update'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1279:in
> `_remove_all_samples'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in
> `send'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in
> `remove_all_associated_objects'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1294:in
> `remove_all_samples'
> from /usr/lib/one/ruby/acct/watch_helper.rb:279:in `fix_size'
> from /usr/lib/one/ruby/acct/watch_helper.rb:449:in `flush'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:259:in
> `_transaction'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:228:in
> `transaction'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:84:in
> `hold'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in
> `synchronize'
> from
> /usr/lib/ruby/gems/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:226:in
> `transaction'
> from /usr/lib/one/ruby/acct/watch_helper.rb:446:in `flush'
> from /usr/lib/one/ruby/acct/monitoring.rb:31:in `insert'
> from /usr/lib/one/ruby/acct/acctd.rb:77:in `update'
> from /usr/lib/one/ruby/acct/acctd.rb:59:in `each'
> from /usr/lib/one/ruby/acct/acctd.rb:59:in `update'
> from /usr/lib/one/ruby/acct/acctd.rb:57:in `each'
> from /usr/lib/one/ruby/acct/acctd.rb:57:in `update'
> from /usr/lib/one/ruby/acct/acctd.rb:129
> from /usr/lib/one/ruby/acct/acctd.rb:124:in `loop'
> from /usr/lib/one/ruby/acct/acctd.rb:124
>
>  I guess there must be some bug hidden somewhere, or I did something
> wrong during the installation.
>
> Cheers,
> Humberto
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
>


-- 
Daniel Molina
Project Engineer
OpenNebula - The Open Source Toolkit for Data Center Virtualization
www.OpenNebula.org | dmolina at opennebula.org | @OpenNebula
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20111222/26ecba0e/attachment-0003.htm>