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

Timestamp:

Jun 23, 2010, 5:51:46 PM (16 years ago)

Author:

watersc1

Message:

Updates to add neb-migrate code, and to fix repeated "can't find device info" bug in nebdiskd.

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (1 diff)

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

@@ -266 +266 @@
             AND mountedvol.name = ?
             AND mountedvol.available = ?
+    },
+    get_ext_id_by_vol_name => qq{
+        SELECT
+            ext_id
+        FROM instance
+        JOIN storage_object
+            USING (so_id)
+        JOIN mountedvol
+            USING(vol_id)
+        JOIN volume
+            USING(vol_id)
+        WHERE volume.name = ?
+            AND mountedvol.available = ?
+        LIMIT ?
     },
     # volume handler