Bug #957

oneacctd crashes when using MySQL-db

Added by Alain van Hoof over 8 years ago. Updated about 8 years ago.

Status:ClosedStart date:11/01/2011
Priority:NormalDue date:
Assignee:Daniel Molina% Done:

100%

Category:Core & System
Target version:Release 3.2
Resolution:fixed Pull request:
Affected Versions:OpenNebula 3.0

Description

oneacctd stops with error:

Tue Nov 01 11:14:50 +0100 2011 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 '1-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


Related issues

Related to Bug #986: oneacctd automatically stop Closed 11/17/2011

History

#1 Updated by Ruben S. Montero over 8 years ago

  • Category set to Core & System
  • Assignee set to Carlos Martín
  • Target version set to Release 3.4

#2 Updated by kawe demo over 8 years ago

Alain van Hoof wrote:

oneacctd stops with error:

Tue Nov 01 11:14:50 +0100 2011 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 '1-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

i also have same problem..

regard

kawe

#3 Updated by Ruben S. Montero over 8 years ago

  • Target version changed from Release 3.4 to Release 3.2 - Beta1

#4 Updated by Ruben S. Montero over 8 years ago

  • Assignee changed from Carlos Martín to Daniel Molina

#5 Updated by Daniel Molina about 8 years ago

The problem is related to the Host Monitoring, if you diable it in acct.conf (set STEP to 0), it should work.

I cannot reproduce this error. Let's try to find out the problem, would yo mind to send us the following information?

  • OpenNebula Version:
  • OS distribution and version:
  • Sequel and MySQL gem versions:
  • Content of the HostPool when acct fails (onehost list -x)
  • Output of the Host (onehost show 1 -x) that is causing the error, you can find its value in the error message:
    Mysql::Error: Duplicate entry '1-0' for key 'PRIMARY' (Sequel::DatabaseError)
    In this case the host ID is 1 "1-0"

Thanks

#6 Updated by Alain van Hoof about 8 years ago

When starting oneacctd Error occurred again:

Mysql::Error: Duplicate entry '1-0' for key 'PRIMARY' (Sequel::DatabaseError)

ON3: version 3.0.0
OS: Centos 6.0 (incl. roling updates)
GEM: sequel (3.28.0), mysql (2.8.1)
onehost list –x output: See below
There is no host 1 so output of onehost show 1 –x is empty!

NOTE! The acct tables are in the MySQL database of the OpenNebula database.

<HOST_POOL>
  <HOST>
    <ID>34</ID>
    <NAME>d-node19</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258567900</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6094496</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 34 : MONITOR FAILURE 34 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:16:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258567900]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node19.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6094496]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>39</ID>
    <NAME>d-node01</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>10487808</MEM_USAGE>
      <CPU_USAGE>800</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>257650768</FREE_MEM>
      <FREE_CPU>3193</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>7011628</USED_MEM>
      <USED_CPU>6</USED_CPU>
      <RUNNING_VMS>2</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 39 : MONITOR FAILURE 39 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:12:56 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3193.6]]></FREECPU>
      <FREEMEMORY><![CDATA[257650768]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node01.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[6.40000000000009]]></USEDCPU>
      <USEDMEMORY><![CDATA[7011628]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>28</ID>
    <NAME>d-node13</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258561852</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6100544</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 28 : MONITOR FAILURE 28 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258561852]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node13.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6100544]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>24</ID>
    <NAME>d-node09</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258556576</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6105820</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 24 : MONITOR FAILURE 24 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258556576]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node09.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6105820]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>29</ID>
    <NAME>d-node14</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258561008</FREE_MEM>
      <FREE_CPU>3196</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6101388</USED_MEM>
      <USED_CPU>3</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 29 : MONITOR FAILURE 29 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3196.8]]></FREECPU>
      <FREEMEMORY><![CDATA[258561008]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node14.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[3.19999999999982]]></USEDCPU>
      <USEDMEMORY><![CDATA[6101388]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>38</ID>
    <NAME>d-node03</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258552160</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6110236</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 38 : MONITOR FAILURE 38 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:16:11 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258552160]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node03.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6110236]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>36</ID>
    <NAME>d-node02</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047986</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258559208</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6103188</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 36 : MONITOR FAILURE 36 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:56 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258559208]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node02.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6103188]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>20</ID>
    <NAME>d-node05</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258553952</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6108444</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 20 : MONITOR FAILURE 20 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258553952]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node05.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6108444]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>30</ID>
    <NAME>d-node15</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258557916</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6104480</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 30 : MONITOR FAILURE 30 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258557916]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node15.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6104480]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>31</ID>
    <NAME>d-node16</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>254380768</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>10281628</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 31 : MONITOR FAILURE 31 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[254380768]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node16.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[10281628]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>21</ID>
    <NAME>d-node06</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258556252</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6106144</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 21 : MONITOR FAILURE 21 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258556252]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node06.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6106144]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>23</ID>
    <NAME>d-node08</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258557520</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6104876</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 23 : MONITOR FAILURE 23 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258557520]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node08.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6104876]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>22</ID>
    <NAME>d-node07</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258562412</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6099984</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 22 : MONITOR FAILURE 22 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258562412]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node07.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6099984]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>25</ID>
    <NAME>d-node10</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258562660</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6099736</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 25 : MONITOR FAILURE 25 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258562660]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node10.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6099736]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>26</ID>
    <NAME>d-node11</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047986</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258564604</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6097792</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 26 : MONITOR FAILURE 26 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258564604]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node11.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6097792]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>27</ID>
    <NAME>d-node12</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047986</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258565996</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6096400</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 27 : MONITOR FAILURE 27 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258565996]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node12.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6096400]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>33</ID>
    <NAME>d-node18</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047986</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>258596696</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6065700</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2127]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 33 : MONITOR FAILURE 33 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:17:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[258596696]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node18.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[6065700]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>32</ID>
    <NAME>d-node17</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>0</MEM_USAGE>
      <CPU_USAGE>0</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>254358840</FREE_MEM>
      <FREE_CPU>3200</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>10303556</USED_MEM>
      <USED_CPU>0</USED_CPU>
      <RUNNING_VMS>0</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 32 : MONITOR FAILURE 32 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:16:41 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3200.0]]></FREECPU>
      <FREEMEMORY><![CDATA[254358840]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node17.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[0.0]]></USEDCPU>
      <USEDMEMORY><![CDATA[10303556]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
  <HOST>
    <ID>19</ID>
    <NAME>d-node04</NAME>
    <STATE>2</STATE>
    <IM_MAD>im_kvm</IM_MAD>
    <VM_MAD>vmm_kvm</VM_MAD>
    <TM_MAD>tm_shared</TM_MAD>
    <LAST_MON_TIME>1322047971</LAST_MON_TIME>
    <HOST_SHARE>
      <DISK_USAGE>0</DISK_USAGE>
      <MEM_USAGE>2097152</MEM_USAGE>
      <CPU_USAGE>200</CPU_USAGE>
      <MAX_DISK>0</MAX_DISK>
      <MAX_MEM>264662396</MAX_MEM>
      <MAX_CPU>3200</MAX_CPU>
      <FREE_DISK>0</FREE_DISK>
      <FREE_MEM>257944840</FREE_MEM>
      <FREE_CPU>3193</FREE_CPU>
      <USED_DISK>0</USED_DISK>
      <USED_MEM>6717556</USED_MEM>
      <USED_CPU>6</USED_CPU>
      <RUNNING_VMS>2</RUNNING_VMS>
    </HOST_SHARE>
    <TEMPLATE>
      <ARCH><![CDATA[x86_64]]></ARCH>
      <CPUSPEED><![CDATA[2128]]></CPUSPEED>
      <ERROR>
        <MESSAGE><![CDATA[Error monitoring host 19 : MONITOR FAILURE 19 -
]]></MESSAGE>
        <TIMESTAMP><![CDATA[Fri Nov 18 08:16:11 2011]]></TIMESTAMP>
      </ERROR>
      <FREECPU><![CDATA[3193.6]]></FREECPU>
      <FREEMEMORY><![CDATA[257944840]]></FREEMEMORY>
      <HOSTNAME><![CDATA[node04.calligo.sara.nl]]></HOSTNAME>
      <HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
      <MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz]]></MODELNAME>
      <NETRX><![CDATA[0]]></NETRX>
      <NETTX><![CDATA[0]]></NETTX>
      <TOTALCPU><![CDATA[3200]]></TOTALCPU>
      <TOTALMEMORY><![CDATA[264662396]]></TOTALMEMORY>
      <USEDCPU><![CDATA[6.40000000000009]]></USEDCPU>
      <USEDMEMORY><![CDATA[6717556]]></USEDMEMORY>
    </TEMPLATE>
  </HOST>
</HOST_POOL>

#7 Updated by Daniel Molina about 8 years ago

I cannot reproduce this error.

Are you still experiencing it?
Do you get the same error with an empty DB?, maybe the DB got corrupted

#8 Updated by kawe demo about 8 years ago

i also have same problem and after create new database, the oneacctd daemon look fine but then automatically stop after 10minutes if using default configuration on acctd.conf.below all the details:

my error output

oneadmin@oneadmin:~$ cat /srv/cloud/one/var/oneacctd.log
Tue Dec 06 17:04:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:09:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:14:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:14:00 +0800 2011 OneWatch::HostMonitoring
/srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `query': Mysql::Error: Duplicate entry '0-0' for key 'PRIMARY' (Sequel::DatabaseError)
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `_execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/logging.rb:28:in `log_yield'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `_execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in `execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:71:in `hold'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in `synchronize'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in `execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:74:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/dataset/actions.rb:657:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:346:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:334:in `update'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1279:in `_remove_all_samples'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in `send'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in `remove_all_associated_objects'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1294:in `remove_all_samples'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:279:in `fix_size'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:449:in `flush'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:259:in `_transaction'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:228:in `transaction'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:84:in `hold'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in `synchronize'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:226:in `transaction'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:446:in `flush'
from /srv/cloud/one/lib/ruby/acct/monitoring.rb:31:in `insert'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:77:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:59:in `each'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:59:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:57:in `each'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:57:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:129
from /srv/cloud/one/lib/ruby/acct/acctd.rb:124:in `loop'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:124

my system use:

Opennebula ver 3.0
OS ubuntu 10.04 LTS 64bit
sequel 3.29.0 , mysql 2.8.1

Content of the HostPool when acct fails (onehost list -x)

oneadmin@oneadmin:~$ onehost list -x
<HOST_POOL>
<HOST>
<ID>0</ID>
<NAME>host01</NAME>
<STATE>3</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219000</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>196608</MEM_USAGE>
<CPU_USAGE>30</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8189396</MAX_MEM>
<MAX_CPU>400</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>7868980</FREE_MEM>
<FREE_CPU>390</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>320416</USED_MEM>
<USED_CPU>9</USED_CPU>
<RUNNING_VMS>3</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA1994]></CPUSPEED>
<ERROR>
<MESSAGE><![CDATA[Error monitoring host 0 : MONITOR FAILURE 0 -
]]></MESSAGE>
<TIMESTAMP><![CDATA[Wed Dec 7 08:50:00 2011]]></TIMESTAMP>
</ERROR>
<FREECPU><![CDATA[390.8]]></FREECPU>
<FREEMEMORY><![CDATA7868980]></FREEMEMORY>
<HOSTNAME><![CDATA[host01]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E5504 2.00GHz]]></MODELNAME>
<NETRX><![CDATA[0]]></NETRX>
<NETTX><![CDATA[0]]></NETTX>
<TOTALCPU><![CDATA[400]]></TOTALCPU>
<TOTALMEMORY><![CDATA[8189396]]></TOTALMEMORY>
<USEDCPU><![CDATA[9.19999999999999]]></USEDCPU>
<USEDMEMORY><![CDATA[320416]]></USEDMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>1</ID>
<NAME>ec2</NAME>
<STATE>4</STATE>
<IM_MAD>im_ec2</IM_MAD>
<VM_MAD>vmm_ec2</VM_MAD>
<TM_MAD>tm_dummy</TM_MAD>
<LAST_MON_TIME>1323054957</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>0</MEM_USAGE>
<CPU_USAGE>0</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8912896</MAX_MEM>
<MAX_CPU>500</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>8912896</FREE_MEM>
<FREE_CPU>500</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>0</USED_MEM>
<USED_CPU>0</USED_CPU>
<RUNNING_VMS>0</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<CPUSPEED><![CDATA[1000]]></CPUSPEED>
<FREECPU><![CDATA[500]]></FREECPU>
<FREEMEMORY><![CDATA[8912896.0]]></FREEMEMORY>
<HOSTNAME><![CDATA[ec2]]></HOSTNAME>
<HYPERVISOR><![CDATA[ec2]]></HYPERVISOR>
<TOTALCPU><![CDATA[500]]></TOTALCPU>
<TOTALMEMORY><![CDATA[8912896.0]]></TOTALMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>2</ID>
<NAME>oneadmin</NAME>
<STATE>2</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219180</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>65536</MEM_USAGE>
<CPU_USAGE>50</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>3983020</MAX_MEM>
<MAX_CPU>200</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>3667400</FREE_MEM>
<FREE_CPU>99</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>315620</USED_MEM>
<USED_CPU>100</USED_CPU>
<RUNNING_VMS>1</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA[2933]]></CPUSPEED>
<FREECPU><![CDATA[99.4]]></FREECPU>
<FREEMEMORY><![CDATA[3667400]]></FREEMEMORY>
<HOSTNAME><![CDATA[oneadmin]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Core(TM)2 Duo CPU E7500
2.93GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA200]></TOTALCPU>
<TOTALMEMORY><![CDATA3983020]></TOTALMEMORY>
<USEDCPU><![CDATA[100.6]]></USEDCPU>
<USEDMEMORY><![CDATA315620]></USEDMEMORY>
</TEMPLATE>
</HOST>
</HOST_POOL>
oneadmin@oneadmin:~$ onehost list -x more
Wrong number of arguments
No argument is required
oneadmin@oneadmin:~$ onehost list -x --more
invalid option: --more
oneadmin@oneadmin:~$ more onehost list -x
onehost: No such file or directory
list: No such file or directory
-x: No such file or directory
oneadmin@oneadmin:~$ onehost list -x
<HOST_POOL>
<HOST>
<ID>0</ID>
<NAME>host01</NAME>
<STATE>3</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219630</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>196608</MEM_USAGE>
<CPU_USAGE>30</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8189396</MAX_MEM>
<MAX_CPU>400</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>7868980</FREE_MEM>
<FREE_CPU>390</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>320416</USED_MEM>
<USED_CPU>9</USED_CPU>
<RUNNING_VMS>3</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA1994]></CPUSPEED>
<ERROR>
<MESSAGE><![CDATA[Error monitoring host 0 : MONITOR FAILURE 0 -
]]></MESSAGE>
<TIMESTAMP><![CDATA[Wed Dec 7 09:00:30 2011]]></TIMESTAMP>
</ERROR>
<FREECPU><![CDATA[390.8]]></FREECPU>
<FREEMEMORY><![CDATA7868980]></FREEMEMORY>
<HOSTNAME><![CDATA[host01]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E5504 2.00GHz]]></MODELNAME>
<NETRX><![CDATA[0]]></NETRX>
<NETTX><![CDATA[0]]></NETTX>
<TOTALCPU><![CDATA[400]]></TOTALCPU>
<TOTALMEMORY><![CDATA[8189396]]></TOTALMEMORY>
<USEDCPU><![CDATA[9.19999999999999]]></USEDCPU>
<USEDMEMORY><![CDATA[320416]]></USEDMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>1</ID>
<NAME>ec2</NAME>
<STATE>4</STATE>
<IM_MAD>im_ec2</IM_MAD>
<VM_MAD>vmm_ec2</VM_MAD>
<TM_MAD>tm_dummy</TM_MAD>
<LAST_MON_TIME>1323054957</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>0</MEM_USAGE>
<CPU_USAGE>0</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8912896</MAX_MEM>
<MAX_CPU>500</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>8912896</FREE_MEM>
<FREE_CPU>500</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>0</USED_MEM>
<USED_CPU>0</USED_CPU>
<RUNNING_VMS>0</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<CPUSPEED><![CDATA[1000]]></CPUSPEED>
<FREECPU><![CDATA[500]]></FREECPU>
<FREEMEMORY><![CDATA[8912896.0]]></FREEMEMORY>
<HOSTNAME><![CDATA[ec2]]></HOSTNAME>
<HYPERVISOR><![CDATA[ec2]]></HYPERVISOR>
<TOTALCPU><![CDATA[500]]></TOTALCPU>
<TOTALMEMORY><![CDATA[8912896.0]]></TOTALMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>2</ID>
<NAME>oneadmin</NAME>
<STATE>2</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219180</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>65536</MEM_USAGE>
<CPU_USAGE>50</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>3983020</MAX_MEM>
<MAX_CPU>200</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>3667400</FREE_MEM>
<FREE_CPU>99</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>315620</USED_MEM>
<USED_CPU>100</USED_CPU>
<RUNNING_VMS>1</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA[2933]]></CPUSPEED>
<FREECPU><![CDATA[99.4]]></FREECPU>
<FREEMEMORY><![CDATA[3667400]]></FREEMEMORY>
<HOSTNAME><![CDATA[oneadmin]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Core(TM)2 Duo CPU E7500
2.93GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA200]></TOTALCPU>
<TOTALMEMORY><![CDATA3983020]></TOTALMEMORY>
<USEDCPU><![CDATA[100.6]]></USEDCPU>
<USEDMEMORY><![CDATA315620]></USEDMEMORY>
</TEMPLATE>
</HOST>
</HOST_POOL>

Output of the Host (onehost show 0 -x)

oneadmin@oneadmin:~$ onehost show 0 -x
<HOST>
<ID>0</ID>
<NAME>host01</NAME>
<STATE>3</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323220260</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>196608</MEM_USAGE>
<CPU_USAGE>30</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8189396</MAX_MEM>
<MAX_CPU>400</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>7868980</FREE_MEM>
<FREE_CPU>390</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>320416</USED_MEM>
<USED_CPU>9</USED_CPU>
<RUNNING_VMS>3</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA1994]></CPUSPEED>
<ERROR>
<MESSAGE><![CDATA[Error monitoring host 0 : MONITOR FAILURE 0 -
]]></MESSAGE>
<TIMESTAMP><![CDATA[Wed Dec 7 09:11:00 2011]]></TIMESTAMP>
</ERROR>
<FREECPU><![CDATA[390.8]]></FREECPU>
<FREEMEMORY><![CDATA7868980]></FREEMEMORY>
<HOSTNAME><![CDATA[host01]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E5504 @ 2.00GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA400]></TOTALCPU>
<TOTALMEMORY><![CDATA8189396]></TOTALMEMORY>
<USEDCPU><![CDATA[9.19999999999999]]></USEDCPU>
<USEDMEMORY><![CDATA320416]></USEDMEMORY>
</TEMPLATE>
</HOST>

Cheers

Kawe

#9 Updated by kawe demo about 8 years ago

This is the correction:

I also have same problem and after create new database, the oneacctd daemon look fine but then automatically stop after 10minutes if using default configuration on acctd.conf. Below all the details:

my system use:
Opennebula ver 3.0
OS ubuntu 10.04 LTS 64bit
sequel 3.29.0 , mysql 2.8.1

for your information my host01 computer now in error states not because of configuration but the computer is use by others person and not connected to front-end.oneacctd error occur before i lend my host01 computer to my friend.(not because host error) and before i create ec2 host and oneadmin host.

my error output

oneadmin@oneadmin:~$ cat /srv/cloud/one/var/oneacctd.log
Tue Dec 06 17:04:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:09:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:14:00 +0800 2011 OneWatch::VmMonitoring
Tue Dec 06 17:14:00 +0800 2011 OneWatch::HostMonitoring
/srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `query': Mysql::Error: Duplicate entry '0-0' for key 'PRIMARY' (Sequel::DatabaseError)
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `_execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/logging.rb:28:in `log_yield'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:167:in `_execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in `execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:71:in `hold'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in `synchronize'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:23:in `execute'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:74:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/dataset/actions.rb:657:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:346:in `execute_dui'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/adapters/mysql.rb:334:in `update'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1279:in `_remove_all_samples'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in `send'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1465:in `remove_all_associated_objects'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/model/associations.rb:1294:in `remove_all_samples'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:279:in `fix_size'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:449:in `flush'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:259:in `_transaction'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:228:in `transaction'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/connection_pool/threaded.rb:84:in `hold'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/connecting.rb:225:in `synchronize'
from /srv/cloud/one/.gem/ruby/1.8/gems/sequel-3.29.0/lib/sequel/database/query.rb:226:in `transaction'
from /srv/cloud/one/lib/ruby/acct/watch_helper.rb:446:in `flush'
from /srv/cloud/one/lib/ruby/acct/monitoring.rb:31:in `insert'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:77:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:59:in `each'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:59:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:57:in `each'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:57:in `update'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:129
from /srv/cloud/one/lib/ruby/acct/acctd.rb:124:in `loop'
from /srv/cloud/one/lib/ruby/acct/acctd.rb:124

Content of the HostPool when acct fails (onehost list -x)

oneadmin@oneadmin:~$ onehost list -x
<HOST_POOL>
<HOST>
<ID>0</ID>
<NAME>host01</NAME>
<STATE>3</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219630</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>196608</MEM_USAGE>
<CPU_USAGE>30</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8189396</MAX_MEM>
<MAX_CPU>400</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>7868980</FREE_MEM>
<FREE_CPU>390</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>320416</USED_MEM>
<USED_CPU>9</USED_CPU>
<RUNNING_VMS>3</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA1994]></CPUSPEED>
<ERROR>
<MESSAGE><![CDATA[Error monitoring host 0 : MONITOR FAILURE 0 -
]]></MESSAGE>
<TIMESTAMP><![CDATA[Wed Dec 7 09:00:30 2011]]></TIMESTAMP>
</ERROR>
<FREECPU><![CDATA[390.8]]></FREECPU>
<FREEMEMORY><![CDATA7868980]></FREEMEMORY>
<HOSTNAME><![CDATA[host01]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E5504 2.00GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA400]></TOTALCPU>
<TOTALMEMORY><![CDATA8189396]></TOTALMEMORY>
<USEDCPU><![CDATA[9.19999999999999]]></USEDCPU>
<USEDMEMORY><![CDATA320416]></USEDMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>1</ID>
<NAME>ec2</NAME>
<STATE>4</STATE>
<IM_MAD>im_ec2</IM_MAD>
<VM_MAD>vmm_ec2</VM_MAD>
<TM_MAD>tm_dummy</TM_MAD>
<LAST_MON_TIME>1323054957</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>0</MEM_USAGE>
<CPU_USAGE>0</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8912896</MAX_MEM>
<MAX_CPU>500</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>8912896</FREE_MEM>
<FREE_CPU>500</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>0</USED_MEM>
<USED_CPU>0</USED_CPU>
<RUNNING_VMS>0</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<CPUSPEED><![CDATA1000]></CPUSPEED>
<FREECPU><![CDATA500]></FREECPU>
<FREEMEMORY><![CDATA[8912896.0]]></FREEMEMORY>
<HOSTNAME><![CDATA[ec2]]></HOSTNAME>
<HYPERVISOR><![CDATA[ec2]]></HYPERVISOR>
<TOTALCPU><![CDATA500]></TOTALCPU>
<TOTALMEMORY><![CDATA[8912896.0]]></TOTALMEMORY>
</TEMPLATE>
</HOST>
<HOST>
<ID>2</ID>
<NAME>oneadmin</NAME>
<STATE>2</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323219180</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>65536</MEM_USAGE>
<CPU_USAGE>50</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>3983020</MAX_MEM>
<MAX_CPU>200</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>3667400</FREE_MEM>
<FREE_CPU>99</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>315620</USED_MEM>
<USED_CPU>100</USED_CPU>
<RUNNING_VMS>1</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA2933]></CPUSPEED>
<FREECPU><![CDATA[99.4]]></FREECPU>
<FREEMEMORY><![CDATA3667400]></FREEMEMORY>
<HOSTNAME><![CDATA[oneadmin]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Core(TM)2 Duo CPU E7500 2.93GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA200]></TOTALCPU>
<TOTALMEMORY><![CDATA3983020]></TOTALMEMORY>
<USEDCPU><![CDATA[100.6]]></USEDCPU>
<USEDMEMORY><![CDATA315620]></USEDMEMORY>
</TEMPLATE>
</HOST>
</HOST_POOL>

Output of the Host (onehost show 0 -x)

oneadmin@oneadmin:~$ onehost show 0 -x
<HOST>
<ID>0</ID>
<NAME>host01</NAME>
<STATE>3</STATE>
<IM_MAD>im_kvm</IM_MAD>
<VM_MAD>vmm_kvm</VM_MAD>
<TM_MAD>tm_ssh</TM_MAD>
<LAST_MON_TIME>1323220260</LAST_MON_TIME>
<HOST_SHARE>
<DISK_USAGE>0</DISK_USAGE>
<MEM_USAGE>196608</MEM_USAGE>
<CPU_USAGE>30</CPU_USAGE>
<MAX_DISK>0</MAX_DISK>
<MAX_MEM>8189396</MAX_MEM>
<MAX_CPU>400</MAX_CPU>
<FREE_DISK>0</FREE_DISK>
<FREE_MEM>7868980</FREE_MEM>
<FREE_CPU>390</FREE_CPU>
<USED_DISK>0</USED_DISK>
<USED_MEM>320416</USED_MEM>
<USED_CPU>9</USED_CPU>
<RUNNING_VMS>3</RUNNING_VMS>
</HOST_SHARE>
<TEMPLATE>
<ARCH><![CDATA[x86_64]]></ARCH>
<CPUSPEED><![CDATA1994]></CPUSPEED>
<ERROR>
<MESSAGE><![CDATA[Error monitoring host 0 : MONITOR FAILURE 0 -
]]></MESSAGE>
<TIMESTAMP><![CDATA[Wed Dec 7 09:11:00 2011]]></TIMESTAMP>
</ERROR>
<FREECPU><![CDATA[390.8]]></FREECPU>
<FREEMEMORY><![CDATA7868980]></FREEMEMORY>
<HOSTNAME><![CDATA[host01]]></HOSTNAME>
<HYPERVISOR><![CDATA[kvm]]></HYPERVISOR>
<MODELNAME><![CDATA[Intel(R) Xeon(R) CPU E5504 @ 2.00GHz]]></MODELNAME>
<NETRX><![CDATA0]></NETRX>
<NETTX><![CDATA0]></NETTX>
<TOTALCPU><![CDATA400]></TOTALCPU>
<TOTALMEMORY><![CDATA8189396]></TOTALMEMORY>
<USEDCPU><![CDATA[9.19999999999999]]></USEDCPU>
<USEDMEMORY><![CDATA320416]></USEDMEMORY>
</TEMPLATE>
</HOST>

Cheers
Kawe

#10 Updated by Ruben S. Montero about 8 years ago

  • Target version changed from Release 3.2 - Beta1 to Release 3.2

#11 Updated by Ruben S. Montero about 8 years ago

  • Status changed from New to Assigned

#12 Updated by Daniel Molina about 8 years ago

  • Status changed from Assigned to Closed
  • % Done changed from 0 to 100
  • Resolution set to fixed

OK, I found out the problem. This patch should fix the problem.

http://dev.opennebula.org/projects/opennebula/repository/revisions/6176e07bac684135cbfe1cd46f9213cc8b41a371/diff/src/acct/watch_helper.rb

This patch is already included in 3.2-beta1 packages.

#13 Updated by Anonymous about 8 years ago

Hi,

Thank you for the path.

Howeverm we just installed and tested the patch and sadly it does not seem to solve the problem:

more /var/log/one/oneacctd.log
Fri Dec 23 09:04:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:09:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:14:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:14:54 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 09:19:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:24:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:29:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:29:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 09:34:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:39:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:44:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:44:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 09:49:54 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:49:55 +0100 2011 OneWatch::Accounting
Fri Dec 23 09:54:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:59:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 09:59:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 10:04:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:09:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:14:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:14:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 10:19:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:24:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:29:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:29:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 10:34:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:39:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:39:55 +0100 2011 OneWatch::Accounting
Fri Dec 23 10:44:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:44:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 10:49:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:54:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:59:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 10:59:55 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 11:04:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:09:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:14:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:17:00 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 11:19:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:24:55 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:29:56 +0100 2011 OneWatch::VmMonitoring
Fri Dec 23 11:32:13 +0100 2011 OneWatch::HostMonitoring
Fri Dec 23 11:34:26 +0100 2011 OneWatch::Accounting
/usr/lib/ruby/gems/1.8/gems/sqlite3-1.3.4/lib/sqlite3/database.rb:97:in `close': SQLite3::ConstraintException: columns vm_id
, timestamp are not unique (Sequel::DatabaseError)
from /usr/lib/ruby/gems/1.8/gems/sqlite3-1.3.4/lib/sqlite3/database.rb:97:in `prepare'
from /usr/lib/ruby/gems/1.8/gems/sqlite3-1.3.4/lib/sqlite3/database.rb:223:in `execute_batch'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/sqlite.rb:126: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/sqlite.rb:126: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/sqlite.rb:113:in `_execute'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/adapters/sqlite.rb:83: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/dataset/actions.rb:248:in `import'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:248:in `each'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:248:in `import'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/database/query.rb:209:in `transaction'
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/database/query.rb:208:in `transaction'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:248:in `import'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/dataset/actions.rb:398:in `multi_insert'
from /usr/lib/ruby/gems/1.8/gems/sequel-3.28.0/lib/sequel/model/base.rb:726:in `multi_insert'
from /usr/lib/one/ruby/acct/watch_helper.rb:402: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:401:in `flush'
from /usr/lib/one/ruby/acct/accounting.rb:75: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

Best regards,

Jhon

#14 Updated by Daniel Molina about 8 years ago

You have to use a new DB and apply the patch to fix the problem. BTW in your previous comments you were using MySQL backend in the last one the error shows an SQLite backend, maybe you are not using the right DB.

#15 Updated by Anonymous about 8 years ago

Hi,

Daniel Molina wrote:

You have to use a new DB and apply the patch to fix the problem. BTW in your previous comments you were using MySQL backend in the last one the error shows an SQLite backend, maybe you are not using the right DB.

Ok, I dropped and recreated the db.

And you were right about the sqlite, I started with the wrong config file.
That made it a bad test for this bug report, but it does indicate the at the sqlite db also has the problem.

However, as I said, acctd is now running with the patch, and a fresh mysql database.

Best regards,

Jhon

#16 Updated by Daniel Molina about 8 years ago

Are you still experiencing this error with OpenNebula 3.2.1?

Also available in: Atom PDF