Comment 1 for bug 1495064

Revision history for this message
Peter Grandi (pg-8) wrote :

BTW as described in an AskUbuntu related question I have checked the MAAS db directly and summarizing it with:

select
  l.ip as "lease",
  l.mac as "Ethernet",
  w.name as "network",
  n.hostname as "node",
  n.storage as "storage",
  n.power_parameters as "WoL"
from
  maasserver_dhcplease as l
    inner join maasserver_macaddress as m
    on l.mac = m.mac_address
      left join maasserver_macaddress_networks as m2n
      on m.id = m2n.macaddress_id
        left join maasserver_network as w
        on m2n.network_id = w.id
      left join maasserver_node as n
      on m.node_id = n.id
order by
  n.hostname

(a query which may of general usefulness) the output looks consistent and complete, so the upgrade does not seem to have damaged the database. However the storage size for the 12 nodes reported is different for some, when they are all identical nodes. Some report 916913 and most report 1408. I can't easily related either to the size of the '/' filetree (800G) or the total storage (around 24TB).