<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    <font size="-1"><font face="Helvetica, Arial, sans-serif">Hi
        everybody:<br>
        <br>
        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<br>
        <br>
        Tue Jan 10 00:46:41 +0100 2012 OneWatch::VmMonitoring<br>
        Tue Jan 10 00:51:41 +0100 2012 OneWatch::VmMonitoring<br>
        Tue Jan 10 00:56:41 +0100 2012 OneWatch::VmMonitoring<br>
        Tue Jan 10 00:56:42 +0100 2012 OneWatch::HostMonitoring<br>
        /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)<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:175:in
        `_execute'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/logging.rb:28:in
        `log_yield'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:175:in
        `_execute'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in
        `execute'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/connection_pool/threaded.rb:71:in
        `hold'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/connecting.rb:226:in
        `synchronize'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in
        `execute'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:71:in
        `execute_dui'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:639:in
        `execute_dui'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:333:in
        `execute_dui'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/mysql.rb:321:in
        `update'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1197:in
        `_remove_all_samples'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1383:in
        `send'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1383:in
        `remove_all_associated_objects'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/associations.rb:1212:in
        `remove_all_samples'<br>
                from /usr/lib/one/ruby/acct/watch_helper.rb:279:in
        `fix_size'<br>
                from /usr/lib/one/ruby/acct/watch_helper.rb:449:in
        `flush'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:231:in
        `_transaction'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:210:in
        `transaction'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/connection_pool/threaded.rb:84:in
        `hold'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/connecting.rb:226:in
        `synchronize'<br>
                from
        /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:208:in
        `transaction'<br>
                from /usr/lib/one/ruby/acct/watch_helper.rb:446:in
        `flush'<br>
                from /usr/lib/one/ruby/acct/monitoring.rb:31:in `insert'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:77:in `update'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:59:in `each'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:59:in `update'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:57:in `each'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:57:in `update'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:129<br>
                from /usr/lib/one/ruby/acct/acctd.rb:124:in `loop'<br>
                from /usr/lib/one/ruby/acct/acctd.rb:124<br>
        <br>
        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.<br>
        <br>
        Thank you very much in advance,<br>
        <br>
        Best Regards,<br>
        Alberto Picón<br>
        <br>
        <br>
      </font></font>
  </body>
</html>