Comment 3 for bug 218388

Revision history for this message
Andreas Hasenack (ahasenack) wrote :

Client version is 0.16.0 and is gutsy

Some things that I don't know if are related or not, but look weird anyway:

- repeated mount points
landscape-test-layer-resource-1=# select * from mount_info where computer_id=236;
  id | computer_id | timestamp | device | mount_point | filesystem | total_space
------+-------------+---------------------+--------------------------------------------------------+---------------+------------+-------------
 1118 | 236 | 2007-10-29 18:21:10 | /dev/disk/by-uuid/0e60c4b6-2b1d-4dc3-81f7-a2f7a084a7f3 | / | ext3 | 18777
 1119 | 236 | 2007-10-29 18:21:10 | /dev/sda5 | /home | ext3 | 51630
 1120 | 236 | 2007-10-29 18:21:10 | /dev/sdb1 | /media/BACKUP | fuseblk | 238472
 2818 | 236 | 2007-12-11 17:22:45 | /dev/disk/by-uuid/0e60c4b6-2b1d-4dc3-81f7-a2f7a084a7f3 | / | ext3 | 18777
 2819 | 236 | 2007-12-11 17:22:45 | /dev/sda5 | /home | ext3 | 51630
 2820 | 236 | 2007-12-11 17:22:45 | /dev/sdb1 | /media/BACKUP | fuseblk | 238472

- some general statistics about those:
landscape-test-layer-resource-1=# select computer_id,mount_point,count(mount_point) as how_many from mount_info group by computer_id,mount_point having count(mount_point) > 1 order by computer_id desc limit 20;
 computer_id | mount_point | how_many
-------------+---------------------+----------
         986 | / | 3
         977 | / | 2
         972 | /backup | 2
         972 | /var | 2
         972 | / | 2
         972 | /mnt | 2
         965 | / | 4
         965 | /home/medias/Medias | 4
         964 | /home | 2
         964 | / | 2
         962 | /media/kvf-storage_ | 3
         962 | /media/kvf-storage | 7
         962 | /media/disk | 3
         962 | /boot | 2
         962 | / | 2
         961 | /home | 2
         961 | / | 2
         957 | / | 373
         955 | /boot | 228
         955 | / | 228
(20 rows)

landscape-test-layer-resource-1=# select computer_id,mount_point,count(mount_point) as how_many from mount_info group by computer_id,mount_point having count(mount_point) > 1 order by how_many desc limit 10;
 computer_id | mount_point | how_many
-------------+-------------+----------
         741 | / | 7369
         741 | /boot | 7369
         909 | / | 1393
         909 | /media/sda3 | 1393
         909 | /media/sda1 | 1393
         957 | / | 373
         955 | / | 228
         955 | /boot | 228
           4 | /mnt | 101
         702 | / | 21
(10 rows)

landscape-test-layer-resource-1=# select * from mount_info where computer_id=957 limit 10;
  id | computer_id | timestamp | device | mount_point | filesystem | total_space
-------+-------------+---------------------+--------------------------------------------------------+-------------+------------+-------------
 25910 | 957 | 2008-04-03 07:56:49 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 23978 | 957 | 2008-03-31 13:11:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 23982 | 957 | 2008-03-31 13:16:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 23988 | 957 | 2008-03-31 13:21:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24000 | 957 | 2008-03-31 13:26:10 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24006 | 957 | 2008-03-31 13:31:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24012 | 957 | 2008-03-31 13:36:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24017 | 957 | 2008-03-31 13:41:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24021 | 957 | 2008-03-31 13:46:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484
 24030 | 957 | 2008-03-31 13:51:08 | /dev/disk/by-uuid/f8cde8c6-c4ce-4dd5-8557-925c17308bbc | / | ext3 | 49484