Changeset 20030 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

Timestamp:

Oct 9, 2008, 1:27:44 PM (18 years ago)

Author:

jhoblitt

Message:

change find_objects_with_unavailable_instances query to work on a temporary table instead of directly on the mountedvol table

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.70 2008-10-09 21:30:10 jhoblitt Exp $
+# $Id: SQL.pm,v 1.71 2008-10-09 23:27:44 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -293 +293 @@
             volume.name as volume_name,
             volume.host as volume_host,
-            count(mountedvol.vol_id) as available_instances,
-            count(mountedvol.vol_id) > 0 as recoverable,
+            count(mymountedvol.vol_id) as available_instances,
+            count(mymountedvol.vol_id) > 0 as recoverable,
             storage_object_xattr.value as copies
         FROM storage_object
@@ -303 +303 @@
         LEFT JOIN storage_object_xattr
             ON storage_object.so_id = storage_object_xattr.so_id
-        JOIN mountedvol
+        JOIN mymountedvol
             USING(vol_id)
-        WHERE mountedvol.available = 1
+        WHERE mymountedvol.available = 1
 --        WHERE storage_object_xattr.name = 'user.copies'
         GROUP BY so_id