Changeset 13251 for trunk/Nebulous-Server/lib/Nebulous/Server.pm

Timestamp:

May 4, 2007, 1:36:46 PM (19 years ago)

Author:

jhoblitt

Message:

rework the getmountedvol() stored procedure to attempt to work around what appears to be some nasty transacational isolation leak throught that was causing getmountedvol() to randomly hang when nebdiskd changed the mount table.

File:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: Server.pm,v 1.37 2007-05-04 20:46:29 jhoblitt Exp $
+# $Id: Server.pm,v 1.38 2007-05-04 23:36:46 jhoblitt Exp $
 
 package Nebulous::Server;
@@ -930 +930 @@
     my $query;
     eval {
-        {
-            # ask the db to generate the table of mounted Nebulous volume 
-            my $query = $db->prepare_cached("call getmountedvol()");
-            $query->execute();
-        }
-
-        $log->debug("generated mountedvol table");
-
         if ($vol_name) {
             $query = $db->prepare_cached( $sql->get_object_instances_by_vol_name );
@@ -1114 +1106 @@
     my ($vol_id, $vol_path);
     eval {
-        {
-            # ask the db to generate the table of mounted Nebulous volume 
-            my $query = $db->prepare_cached("call getmountedvol()");
-            $query->execute();
-        }
-
         # TODO cache this?
         my $query;