Changeset 19792

Timestamp:

Sep 30, 2008, 4:06:17 PM (18 years ago)

Author:

jhoblitt

Message:

fix getmountedvol() stored proc to not add volumes to the mountedvol table that are not available

Location:

trunk/Nebulous-Server

Files:

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

trunk/Nebulous-Server/Changes

@@ -8 +8 @@
       monitoring and then only for paths that actually have volumes mounted on
       them
+    - fix getmountedvol() stored proc to not add volumes to the mountedvol
+      table that are not available
 
 0.15 Thu Sep 11 13:00:59 HST 2008

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.64 2008-09-22 21:22:52 jhoblitt Exp $
+# $Id: SQL.pm,v 1.65 2008-10-01 02:06:17 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -523 +523 @@
                 (SELECT *, INSTR(pathvar, mountpoint) = 1 as substring
                 FROM mount
+                HAVING substring = 1
                 ORDER BY substring DESC, LENGTH(mountpoint) DESC
                 LIMIT 1) as bar;