Changeset 20030 for trunk/Nebulous-Server/bin/neb-admin

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/bin/neb-admin (modified) (2 diffs)

trunk/Nebulous-Server/bin/neb-admin

@@ -3 +3 @@
 # Copyright (C) 2005-2008  Joshua Hoblitt
 #
-# $Id: neb-admin,v 1.9 2008-09-30 21:55:44 jhoblitt Exp $
+# $Id: neb-admin,v 1.10 2008-10-09 23:27:44 jhoblitt Exp $
 
 use strict;
@@ -70 +70 @@
 
 # so_id, ext_id, instances, available_instances, need_recovery, recoverable
+{
+    my $query = $dbh->prepare("CREATE TEMPORARY TABLE mymountedvol LIKE mountedvol");
+    $query->execute;
+}
+
+{
+    my $query = $dbh->prepare("INSERT INTO mymountedvol SELECT * FROM mountedvol");
+    $query->execute;
+}
+
 my $query = $dbh->prepare( $sql->find_objects_with_unavailable_instances
         . " LIMIT $limit" );
 $query->execute;
+
+$dbh->do("DROP TABLE IF EXISTS mymountedvol");
 
 my @rows;