Changeset 18434

Timestamp:

Jul 7, 2008, 1:37:48 PM (18 years ago)

Author:

jhoblitt

Message:

change find_objects_with_unavailable_instances query to only count volumes marked as 'available'

Location:

trunk/Nebulous-Server

Files:

• Changes (modified) (1 diff)
• lib/Nebulous/Server/SQL.pm (modified) (2 diffs)

trunk/Nebulous-Server/Changes

@@ -2 +2 @@
 
 0.13
+    - change find_objects_with_unavailable_instances query to only count
+      volumes marked as 'available'
     - fix nebdiskd so it doesn't removed volumes as being successful stat()'d
       even when the stat() failed under --debug

trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.61 2008-07-03 21:56:33 jhoblitt Exp $
+# $Id: SQL.pm,v 1.62 2008-07-07 23:37:48 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -307 +307 @@
         JOIN mountedvol
             USING(vol_id)
+        WHERE mountedvol.available = 1
 --        WHERE storage_object_xattr.name = 'user.copies'
         GROUP BY so_id