[one-users] Exception in oneacct

[Humberto N. Castejon Martinez]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20111221/3291c686/attachment-0002.htm>