What version are you running? We saw a very similar problem in 3.0
and they say it is fixed in the latest release candidate.
Steve Timm
On Tue, 10 Jan 2012, Alberto Picón Couselo wrote:
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
--
------------------------------------------------------------------
Steven C. Timm, Ph.D (630) 840-8525
[email protected] http://home.fnal.gov/~timm/
Fermilab Computing Division, Scientific Computing Facilities,
Grid Facilities Department, FermiGrid Services Group, Group Leader.
Lead of FermiCloud project.
_______________________________________________
Users mailing list
[email protected]
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
