Hi Humberto, This is a bug that I cannot reproduce. Would yo mind to send us the database schema and the content of the host_timestamps and vm_timestamps tables?
Thanks. On 21 December 2011 11:02, Humberto N. Castejon Martinez <humca...@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@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 | dmol...@opennebula.org | @OpenNebula
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org