[one-users] oneacctd execution error

[Alberto Picón Couselo]

Hi everybody:

Please, can you help us with the following oneacctd error?. After 10 or 
15 minutes of oneacctd usage, oneacctd aborts dumping the following data 
in /var/log/one/acctd.log

Tue Jan 10 00:46:41 +0100 2012 OneWatch::VmMonitoring
Tue Jan 10 00:51:41 +0100 2012 OneWatch::VmMonitoring
Tue Jan 10 00:56:41 +0100 2012 OneWatch::VmMonitoring
Tue Jan 10 00:56:42 +0100 2012 OneWatch::HostMonitoring
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:175:in 
`query': Mysql::Error: Duplicate entry '37-0' for key 'PRIMARY' 
(Sequel::DatabaseError)
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:175:in 
`_execute'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/logging.rb:28:in 
`log_yield'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:175:in 
`_execute'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in 
`execute'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/connection_pool/threaded.rb:71:in 
`hold'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/connecting.rb:226:in 
`synchronize'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in 
`execute'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:71:in 
`execute_dui'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:639:in 
`execute_dui'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:333:in 
`execute_dui'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:321:in 
`update'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1197:in 
`_remove_all_samples'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1383:in 
`send'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1383:in 
`remove_all_associated_objects'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1212: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.28.0/lib/sequel/database/query.rb:231:in 
`_transaction'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:210:in 
`transaction'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/connection_pool/threaded.rb:84:in 
`hold'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/connecting.rb:226:in 
`synchronize'
         from 
/usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:208: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

We have noticed too that oneacct client dumps old data. We migrated from 
2.9.80 to 3.0.0 without problems, but accounting does not work correctly.

Thank you very much in advance,

Best Regards,
Alberto Picón


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20120110/b3e3ff9b/attachment-0002.htm>