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 [email protected] http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
