ptopgen.in 73.3 KB
Newer Older
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1
#!/usr/bin/perl -w
Leigh B. Stoller's avatar
Leigh B. Stoller committed
2 3 4

#
# EMULAB-COPYRIGHT
5
# Copyright (c) 2000-2012 University of Utah and the Flux Group.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
6 7 8
# All rights reserved.
#

9 10
use English;
use Getopt::Std;
11
use Math::BigInt;
12
use List::Util 'shuffle';
Leigh B. Stoller's avatar
Leigh B. Stoller committed
13

14 15
use lib "@prefix@/lib";
use libdb qw(TBGetSiteVar);
16
use libadminctrl;
17
use libptop;
18
use EmulabFeatures;
19

20 21
my @SAVEARGV = @ARGV;

22 23
my $top = libptop->Create();

24 25
my $PGENISUPPORT = @PROTOGENI_SUPPORT@;

26 27
$NO_GENI = "0";
$V_0_1 = "0.1";
28
$V_0_2 = "0.2";
29
$V_2 = "2";
30
$V_3 = "3";
31

32 33 34
$emulabns = "http://www.protogeni.net/resources/rspec/ext/emulab/1";
# XXX: This needs to be changed
$emulaburl = "http://www.protogeni.net/resources/rspec/ext/emulab/1/ptop_extension.xsd";
35 36
$sharedns = "http://www.geni.net/resources/rspec/ext/shared-vlan/1";
$sharedurl = "http://www.geni.net/resources/rspec/ext/shared-vlan/1/ad.xsd";
37 38
$stitchns = "http://hpn.east.isi.edu/rspec/ext/stitch/0.1/";
$stitchurl = "http://hpn.east.isi.edu/rspec/ext/stitch/0.1/stitch-schema.xsd";
39

40 41 42 43
if ($PGENISUPPORT) {
  require GeniHRN;
}

44 45
sub usage()
{
Leigh B. Stoller's avatar
Leigh B. Stoller committed
46
    print("Usage: ptopgen [-v] [-s switch] [-p pid [-e eid]] [-m factor] " .
47
	  "[-n c/e] [-x] [-g (0.1 | 2)] [-c component-name]".
48
	  "[-l type-limit-file] [-z]\n" .
49
	  "       -p include nodes the project has permission to use\n".
50
	  "       -e include given experiments resources\n" .
51 52
	  "          in the ptopfile (as if they were free)\n" .
	  "       -v Include stuff for topologies with virtual nodes\n".
53
	  "       -r Include stuff for topologies with widearea nodes\n".
54
#	  "       -s Include stuff for topologies with simulated nodes\n".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
55
	  "       -h Include stuff for topologies with shared nodes\n".
56
	  "       -a Include even reserved nodes\n".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
57
	  "       -m Override multiplex_factor\n".
58
	  "       -u Prune unused interfaces of allocated nodes (-e)\n".
59
	  "       -c Delay capacity override\n".
60
	  "       -n Add in modelnet core and edge node features\n".
61
	  "       -x Output into the new xml ptop format\n".
62
	  "       -g version With -x, geni version. Must be '0', '0.1' or '2'\n".
63
	  "       -l specifies the location of the type limit file\n" .
64 65 66
          "       -1 Print an rspec containing only the node component-name\n" .
	  "       -z Randomize node output order\n" .
	  "       -Z Force old ptopgen\n");
67
        exit(-1);
68
}
69

70
my $optlist = "s:e:m:vp:rSan:c:uxg:h1:l:zZ";
71
my $mfactor;
72
my $virtstuff = 0;
73
my $widearea  = 0;
74
my $simstuff  = 0;
75
my $allnodes  = 0;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
76 77
my $mnetcores = 0;
my $mnetedges = 0;
78
my $prune     = 0;
79
my $do_xml    = 0;
80
my $genimode  = $NO_GENI;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
81
my $useshared = 0;
82
my $component_name = undef;
83
my $randomize = 0;
84

85
my $OURDOMAIN = "@OURDOMAIN@";
86
my $MAINSITE  = @TBMAINSITE@;
87
my $cmuuid = TBGetSiteVar('protogeni/cm_uuid');
88 89 90 91
my $cmurn = "";
if ($PGENISUPPORT) {
    $cmurn = GeniHRN::Generate($OURDOMAIN, "authority", "cm");
}
92

93
my $default_long = undef;
94
TBGetSiteVar('general/default_longitude', \$default_long);
95
my $default_lat = undef;
96
TBGetSiteVar('general/default_latitude', \$default_lat);
97
my $default_country = undef;
98
TBGetSiteVar('general/default_country', \$default_country);
99

100
my $delaycap_override;
101

102 103 104 105
#
# Turn off line buffering on output
#
$| = 1;
106 107 108 109 110 111 112 113 114 115 116 117

# Settings - Change these to your particular network.

#
# Also bogus. The interfaces table does not hold entries for the switch
# side of each link. It will have to at some point, when we have something
# other than 100Mbs ports (say, gbit ports).
#
# Speed in in Kbs!
#
my $default_switchport_speed    = 100000;

118 119 120 121 122 123
#
# Yet more bogosity - we hardcode this weight, which is given to wide-area
# (primarily plab) nodes to prefer spreading across sites
#
my $site_weight = 0.99;

124 125
######################################################################

126
my $TBROOT = "@prefix@";
127
use lib '@prefix@/lib';
128
require exitonwarn;
129
use libdb;
Kevin Atkinson's avatar
Kevin Atkinson committed
130
use libtblog;
131
use Experiment;
132
use Node;
133
use NodeType;
134
use Lan;
Kevin Atkinson's avatar
Kevin Atkinson committed
135 136

tblog_stop_capture('stdout');
Leigh B. Stoller's avatar
Leigh B. Stoller committed
137

138 139
my $TRACK_INTERSWITCH_BANDWIDTH = "@TRACK_INTERSWITCH_BANDWIDTH@";

140 141
my %switches	  = ();
my %permissions   = ();
142 143
my %typemap       = ();
my %auxtypemap    = ();
Timothy Stack's avatar
 
Timothy Stack committed
144
my %areamap       = ();
145
my %globalcounts  = ();
Leigh B. Stoller's avatar
Leigh B. Stoller committed
146
my %interfacestate= ();
147
my %vinterfaces   = ();
Leigh B. Stoller's avatar
Leigh B. Stoller committed
148
my %rusagedata    = ();
149

150 151 152
my $DEADPID = NODEDEAD_PID();
my $DEADEID = NODEDEAD_EID();

153
my $pid;
154
my $exempt_eid;
155
my $switchtouse;
156
my $experiment;
157

158 159
my $typelimitfile = "";

160 161
sub fatal($);

162 163 164 165 166 167 168 169 170 171 172 173 174 175
#
# Parse command arguments. Once we return from getopts, all that should be
# left are the required arguments.
#
%options = ();
if (! getopts($optlist, \%options)) {
    usage();
}
if (@ARGV) {
    usage();
}
if (defined($options{"s"})) {
    $switchtouse = $options{"s"};
}
176 177 178
if (defined($options{"m"})) {
    $mfactor = $options{"m"};
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
179 180 181
if (defined($options{"h"})) {
    $useshared = 1;
}
182 183 184
if (defined($options{"v"})) {
    $virtstuff = 1;
}
185 186 187
if (defined($options{"r"})) {
    $widearea = 1;
}
188 189 190
if (defined($options{"S"})) {
    $simstuff = 1;
}
191 192 193
if (defined($options{"p"})) {
    $pid = $options{"p"};
}
194 195 196
if (defined($options{"a"})) {
    $allnodes = 1;
}
197 198 199
if (defined($options{"u"})) {
    $prune = 1;
}
200 201 202
if (defined($options{"c"})) {
    $delaycap_override = $options{"c"};
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
203 204 205 206 207 208 209 210 211
if (defined($options{"n"})) {
    if ($options{"n"} =~ /(\d*),(\d*)/) {
	$mnetcores = $1;
	$mnetedges = $2;
    }
    else {
	usage();
    }
}
212
if (defined($options{"e"})) {
213 214 215
    $exempt_eid = $options{"e"};
    usage()
	if (!defined($pid));
216
    $experiment = Experiment->Lookup($pid, $exempt_eid);
217 218
    die("Could not look up experiment $pid,$exempt_eid\n")
	if (!defined($experiment));
219
}
220
if (defined($options{"x"})) {
221 222 223 224 225
    if (defined($options{"g"}) && $PGENISUPPORT) {
	$useshared = 1;
	$virtstuff = 1;
	$genimode = $options{"g"};
    }
226 227
    $do_xml = 1;
}
228 229 230
if (defined($options{"l"})) {
    $typelimitfile = $options{"l"};
}
231 232 233
if (defined($options{"1"})) {
    $component_name = $options{"1"};
}
234 235 236
if (defined($options{"z"})) {
    $randomize = 1;
}
237

238
usage()
239
    if ($prune && !defined($exempt_eid)
240 241 242
	|| ($genimode ne $NO_GENI
	    && $genimode ne $V_0_1
	    && $genimode ne $V_0_2
243 244
	    && $genimode ne $V_2
	    && $genimode ne $V_3));
245

246
if (defined($pid) && ! defined($options{"Z"})) {
247 248
    my $group = Group->Lookup($pid, $pid);
    if (defined($group)) {
249
	$EmulabFeatures::verbose = 0;
250 251 252
	my $newptopgen = EmulabFeatures->FeatureEnabled("NewPtopgen", undef,
							$group, undef);
	if ($newptopgen) {
253
	    my $newpath = "$TBROOT/libexec/ptopgen_new";
254 255
	    print STDERR "Invoking new ptopgen from $newpath\n"
		if (!$genimode);
256 257 258 259 260 261 262
	    exec $newpath, @SAVEARGV;
	    die("*** $0:\n".
		"    Could not exec $newpath: $!");
	}
    }
}

263 264
$fake_inet_switch = "internet";
$fake_inet_iface = "(null)";
265 266 267
$fake_air_switch = "airswitch";
$fake_air_iface = "(null)";
if ($genimode ne $NO_GENI) {
268
    $fake_inet_iface = "border";
269
    $fake_air_iface = "air";
270 271
}

272
my %nodetointerface;
273 274
my %interfaceroles = ();
my %interfacetypes = ();
275
my %interfaceips = ();
276 277

# Read interfaces
278
my $result =
279
    DBQueryFatal("SELECT node_id,card,port,iface,interface_type,role,IP" .
280 281
		 " from interfaces where logical=0 " .
		 ($genimode ne $NO_GENI ? "and role!='gw'" : ""));
282
		 
283
while (($node,$card,$port,$iface,$type,$role,$ip) = $result->fetchrow_array) {
284 285 286 287 288
    push @{ $nodetointerface{"$node"} }, $iface;
    $interfacemap{"$node:$card:$port"} = $iface;
    if ((defined $type) && ($type ne "")) {
	$interfacetypes{"$node:$card:$port"} = $type;
    }
289 290 291
    if ((defined $role) && ($role ne "")) {
	$interfaceroles{"$node:$iface"} = $role;
    }
292 293 294
    if ((defined $ip) && ($ip ne "")) {
	$interfaceips{"$node:$iface"} = $ip;
    }
295 296
}

297
my %external_nodes;
298
my %external_managers;
299
my %external_ifaces;
300
my %external_links;
301 302 303 304 305
my %contact_nodes;
my %contact_ifaces;

$result = DBQueryFatal("select w.node_id1, w.card1, w.port1, i1.iface, ".
		       "w.node_id2, w.card2, w.port2, i2.iface, ".
306 307
		       "w.external_interface, w.external_wire, ".
		       "e.node_id, e.min_vlan, e.max_vlan, e.external_manager ".
308 309 310 311 312 313 314
		       "from wires as w ".
		       "left join external_networks as e ".
		       "on w.node_id1=e.node_id or w.node_id2=e.node_id ".
		       "left join interfaces as i1 on w.node_id1=i1.node_id and w.card1=i1.card and w.port1=i1.port ".
		       "left join interfaces as i2 on w.node_id2=i2.node_id and w.card2=i2.card and w.port2=i2.port ".
		       "where e.node_id is not null");
while (my ($cnode, $ccard, $cport, $ciface, $enode, $ecard, $eport, $eiface,
315 316
	   $external_iface_urn, $external_link_urn, $external, $minLan,
	   $maxLan, $external_manager_urn) = $result->fetchrow_array) {
317 318 319 320 321 322 323 324 325 326 327 328 329 330
    if ($external eq $cnode) {
	my $temp;
	$temp = $cnode; $cnode = $enode; $enode = $temp;
	$temp = $ccard; $ccard = $ecard; $ecard = $temp;
	$temp = $cport; $cport = $eport; $eport = $temp;
	$temp = $ciface; $ciface = $eiface; $eiface = $temp;
    }
    if (! defined($eiface)) {
	$eiface = "$ecard.$eport";
    }
    if (! defined($ciface)) {
	$ciface = "$ccard.$cport";
    }
    $external_nodes{$enode} = "$minLan-$maxLan";
331 332 333
    $external_managers{"$cnode:$enode"} = $external_manager_urn;
    $external_ifaces{"$cnode:$enode"} = $external_iface_urn;
    $external_links{"$cnode:$enode"} = $external_link_urn;
334 335 336 337
    $contact_nodes{$cnode} = $enode;
    $contact_ifaces{"$cnode:$enode"} = $ciface;
}

338 339
print_header();

340 341 342 343
my %nodetouuid;
my %nodetoavailable;

$result = DBQueryFatal("SELECT n.node_id, n.eventstate, n.role, n.uuid, " .
344
		       "nt.isremotenode, " .
345
		       "dedicated_wa_types.attrvalue, b.erole, " .
346
		       "n.reserved_pid, b.eid " .
347 348 349 350 351 352 353 354 355 356
		       "from nodes as n " .
		       "left join reserved as b on n.node_id=b.node_id " .
		       "left join node_types as nt on nt.type=n.type " .
		       "left outer join " .
		       "  (select type, attrvalue " .
		       "   from node_type_attributes " .
		       "   where attrkey='dedicated_widearea' " .
		       "   group by type) as dedicated_wa_types " .
		       "  on nt.type=dedicated_wa_types.type " .
		       "where nt.isvirtnode = 0 or nt.isvirtnode is null;");
357
while (($node,$eventstate, $role, $uuid, $isremotenode,
358
	$wa_attrvalue, $erole,
359
	$reserved_pid, $reserved_eid) = $result->fetchrow_array) {
360 361 362 363
    if (defined($uuid) && $uuid ne "")
    {
	$nodetouuid{$node} = $uuid;
    }
364 365 366 367
    my $islocal = $role eq 'testnode'
	&& ((! defined($isremotenode) || $isremotenode == 0)
	    || (defined($wa_attrvalue) && $wa_attrvalue == 1));
    my $isup = defined($eventstate)
368 369 370 371
	&& ($eventstate eq TBDB_NODESTATE_ISUP
	    || $eventstate eq TBDB_NODESTATE_PXEWAIT
	    || $eventstate eq TBDB_NODESTATE_POWEROFF
	    || $eventstate eq TBDB_NODESTATE_ALWAYSUP);
372 373
    my $isshared = (defined($erole)
		    && $erole eq "sharedhost"
374 375 376 377
		    && $useshared
		    && $isup);
    my $isreserved = (defined($reserved_eid)
		      || (defined($reserved_pid)
Leigh B. Stoller's avatar
Leigh B. Stoller committed
378
			  && (! defined($pid) || $pid ne $reserved_pid)));
379 380 381
    my $isfree = (!$islocal
		  || (! $isreserved && $isup)
		  || $isshared);
382 383 384
    $nodetoavailable{$node} = $isfree;
}

385
# Read class/type maps
386
$result =
387 388 389
    DBQueryFatal("select class,type,isvirtnode from node_types");

while (my ($class,$type,$isvirt) = $result->fetchrow_array) {
390 391 392
    $map = {};
    $map->{'CLASS'}    = $class;
    $map->{'ISVIRT'}   = $isvirt;
393 394 395 396 397 398 399 400 401
    my $typeinfo       = NodeType->Lookup($type);
    $map->{'DELAYCAP'} = $typeinfo->delay_capacity();
    $map->{'VIRTCAP'}  = $typeinfo->virtnode_capacity();
    $map->{'SIMCAP'}   = $typeinfo->simnode_capacity();
    $map->{'SPEED'}    = $typeinfo->frequency();
    $map->{'RAM'}      = $typeinfo->memory();
    $map->{'OSID'}     = $typeinfo->default_osid();
    $map->{'IMAGEABLE'}= $typeinfo->imageable();
    $map->{'TRIVSPEED'}= $typeinfo->trivlink_maxspeed();
Leigh B. Stoller's avatar
Leigh B. Stoller committed
402
    $map->{'SHARED'}   = $typeinfo->shared();
403
    $map->{'TYPEINFO'} = $typeinfo;
404 405
    $map->{'FEATURES'} = [];
    $map->{'AUXTYPES'} = {};
406
    $map->{'OSLIST'} = [];
407
    $typemap{$type} = $map;
408 409 410 411 412 413

    # Default is permission to use all types,classes. 
    $permissions{$class} = 1;
    $permissions{$type}  = 1;
}

Timothy Stack's avatar
 
Timothy Stack committed
414 415
# Read node_startloc
$result = DBQueryFatal("select node_id,building from node_startloc");
Timothy Stack's avatar
 
Timothy Stack committed
416
while (($node,$building) = $result->fetchrow_array) {
417 418 419 420
    # TODO: This screws up the meaning of the @features list. Now it
    # is not just a list of feature strings, but a list of strings
    # which might themselves be space-delimited lists of feature
    # strings. Fix this.
Timothy Stack's avatar
 
Timothy Stack committed
421
    $areamap{$node} .= " area-$building:0";
Timothy Stack's avatar
 
Timothy Stack committed
422 423
}

424 425 426 427 428
#
# Read the features table for each type.
# 
$result = DBQueryFatal("select type, feature, weight from node_type_features");
while (my ($type, $feature, $weight) = $result->fetchrow()) {
429 430 431 432 433 434 435 436 437 438
    push(@{$typemap{$type}->{'FEATURES'}}, "$feature:$weight");
}

#
# Read the auxtypes for each type.
# 
$result = DBQueryFatal("select auxtype,type from node_types_auxtypes");
while (my ($auxtype,$type) = $result->fetchrow()) {
    $typemap{$type}->{'AUXTYPES'}->{$auxtype} = 1;
    $auxtypemap{$auxtype} = $type;
439 440
}

441 442 443 444 445 446 447 448 449 450 451 452
#
# Read the features table for each individual node
#
$result = DBQueryFatal("select node_id, feature, weight from node_features");
while (my ($node_id, $feature, $weight) = $result->fetchrow()) {
    if (! defined($features{$node_id})) {
	$features{$node_id} = ["$feature:$weight"];
	next;
    } else {
	push @{$features{$node_id}}, "$feature:$weight";
    }
}
453 454 455 456 457 458 459 460 461
#
# Read in the node_auxtypes table for each node.
#
$result = DBQueryFatal("select node_id, type, count from node_auxtypes");
while (my ($node_id, $type, $count) = $result->fetchrow()) {
    if (! defined($auxtypes{$node_id})) {
	$auxtypes{$node_id} = ["$type:$count"];
	next;
    }
462
    push @{$auxtypes{$node_id}}, "$type:$count";
463
}
464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483
#
# Read the permission table if given a pid. If there is an entry in
# the table for a type/class, then permission is granted only if there
# is a record with the pid. If not, remove the permission granted above.
# 
if (defined($pid)) {
    $result =
	DBQueryFatal("select type from nodetypeXpid_permissions");
    
    while (my ($type) = $result->fetchrow_array) {
	$permissions{$type} = 0;
    }
    
    $result =
	DBQueryFatal("select type from nodetypeXpid_permissions ".
		     "where pid='$pid'");
    
    while (my ($type) = $result->fetchrow_array) {
	$permissions{$type} = 1;
    }
484 485
}

486 487 488 489 490 491 492
#
# Read the table of which image types are supported on which hardware - we
# limit this to global images and ones that match the PID (if given) We do this
# limiting for two reasons:
# 1) To avoid an explosion in the number of features for nodes
# 2) To avoid information leaks, allowing projects to see each other's images
# 
493
my $osidquery = "select distinct o.osid, oi.type, o.osname, o.pid, o.OS, o.version, o.description,o.protogeni_export from os_info as o " .
494
	"left join osidtoimageid as oi on o.osid = oi.osid " .
495
        "left join images as i on oi.imageid = i.imageid ";
496
if ($pid) {
497 498 499 500 501 502 503
    $osidquery .= "left join image_permissions as p1 on p1.imageid=i.imageid and p1.permission_type='group' ".
	"left join groups as g on p1.permission_idx=g.gid_idx ";
}
$osidquery .= "where i.global = 1 ";
if ($pid) {
    $osidquery .= " or i.pid='$pid' ".
	" or (g.pid is not null and g.pid='$pid')";
504 505
}

506 507 508 509
my $defaultosidquery = 'select distinct o.osid, t.type, o.osname, o.pid, o.OS, o.version, o.description, o.protogeni_export '.
    'from os_info as o left join node_type_attributes as t '.
    'on (o.osid=t.attrvalue) where t.attrkey="default_osid"';

510 511 512 513
#
# For subOS support (i.e., vnode OSes running atop vhost OSes), we have to
# check both the subosid and all the parent_osid it can run on.
#
514
my $subosidquery = "select distinct o.osid,o.parent_osid from os_submap as o " .
515 516 517 518
	"left join osidtoimageid as oi1 on o.osid = oi1.osid " .
	"left join osidtoimageid as oi2 on o.parent_osid = oi2.osid " .
	"left join images as i1 on oi1.imageid = i1.imageid ".
	"left join images as i2 on oi2.imageid = i2.imageid ".
519
	"where (i1.imageid is null or i1.global = 1";
520 521 522 523 524 525 526 527 528
if ($pid) {
    $subosidquery .= " or i1.pid='$pid'";
}
$subosidquery .= ") and (i2.global = 1";
if ($pid) {
    $subosidquery .= " or i2.pid='$pid'";
}
$subosidquery .= ")";

529 530 531 532 533 534 535 536 537 538 539 540
our %node_type_osids;
our %osid_node_types;
our %osid_subosids;
our %osid_name;
our %osid_pid;
our %osid_os;
our %osid_version;
our %osid_description;
our %node_countries;
our %node_latitudes;
our %node_longitudes;

541
$result = DBQueryFatal($osidquery);
542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576
processOs($result);

$result = DBQueryFatal($defaultosidquery);
processOs($result);

sub processOs
{
    my $result = shift(@_);
    while (my ($osid,$type,$osname,$ospid,$osos,
	       $osversion,$osdescription,$geni) = $result->fetchrow()) {
	if ($typemap{$type}) {
	    my $default = $typemap{$type}->{'OSID'};
	    if ($geni eq 1 ||
		(defined($default) && $default eq $osid)) {
		push(@{ $typemap{$type}->{'OSLIST'} }, $osid);
		$osid_name{$osid} = $osname;
		$osid_pid{$osid} = $ospid;
		$osid_os{$osid} = $osos;
		$osid_version{$osid} = $osversion;
		$osid_description{$osid} = $osdescription;
	    }
	}
	if ($node_type_osids{$type}) {
	    push @{$node_type_osids{$type}}, $osid;
	} else {
	    $node_type_osids{$type} = [$osid];
	}
	#
	# We have to maintain a data structure telling us which types an OSID could
	# be on for use below with generic OSIDs
	#
	if ($osid_node_types{$osid}) {
	    push @{$osid_node_types{$osid}}, $type;
	} else {
	    $osid_node_types{$osid} = [$type];
577
	}
578 579
    }
}
580 581 582 583 584 585 586 587 588 589 590
#
# XXX Note below that for now, subosids cannot redirect to other subosids.
#
$result = DBQueryFatal($subosidquery);
while (my ($subosid,$osid) = $result->fetchrow()) {
    if ($osid_subosids{$osid}) {
	push @{$osid_subosids{$osid}}, $subosid;
    } else {
	$osid_subosids{$osid} = [$subosid];
    }
}
591 592 593 594 595

#
# We also have to resolve the 'generic' OSIDs, which use the nextosid field to
# redirect to another OSID
#
596
$result = DBQueryFatal("select osid from os_info where " .
597
    "nextosid is not null");
598
while (my ($osid) = $result->fetchrow()) {
599 600 601
    #
    # Check to see if they were allowed to use the real OSID
    #
602
    my $realosid = TBResolveNextOSID($osid, $pid, $exempt_eid);
603
    if (defined($realosid) && $osid_node_types{$realosid}) {
604
	foreach my $type (@{$osid_node_types{$realosid}}) {
605 606 607 608 609
	    push @{$node_type_osids{$type}}, $osid;
	}
    }
}

610
# Print switches
611
if (defined($switchtouse) && ! defined($component_name)) {
612 613 614
    # Should probably get the last four args out of the database, but I don't
    # think we ever actually use this case...
    print_switch($switchtouse,undef,undef,undef,undef);
615 616
    $switches{$switchtouse} = 1;
}
617
elsif (! defined($component_name)) {
618
    $result =
619 620 621 622 623 624 625 626
	DBQueryFatal("select n.node_id,n.uuid,country,latitude,longitude ".
                     "   from nodes as n ".
		     "left join widearea_nodeinfo as wn ".
                     "     on n.node_id=wn.node_id " .
		     "left join node_types as nt on ".
		     "     nt.type=n.type ".
		     "where role='testswitch' or role='widearea_switch' or ".
		     "      (role='testnodefoo' and nt.isswitch=1)");
627

628 629 630
    while (($switch, $uuid, $country, $latitude, $longitude) =
            $result->fetchrow_array) {
	print_switch($switch, $uuid, $country, $latitude, $longitude);
631 632
	$switches{$switch} = 1;
    }
633
}
634

635 636 637 638 639 640
#
# Get the global counts.
#
$result =
    DBQueryFatal("select phys_nodeid,count(phys_nodeid) from reserved as r ".
		 "left join nodes as n on n.node_id=r.node_id ".
641 642 643 644
		 "where n.node_id!=n.phys_nodeid ".
		 (defined($exempt_eid) ?
		  "and not (pid='$pid' and eid='$exempt_eid') " : " ") .
		 "group by phys_nodeid");
645 646 647 648
while (my ($node_id,$count) = $result->fetchrow_array) {
    $globalcounts{$node_id} = $count;
}

649
# Find available nodes.
650
#
651 652
# This first query deals with just local nodes. Local nodes can host
# virtnodes, according to the delay_capacity in the types table. 
653
#
654

655
# the ordinary free condition for a local node.
656 657
my $free_condition = "(b.node_id is null and ".
                     " (np.eventstate='" . TBDB_NODESTATE_ISUP . "' or ".
658
                     "  np.eventstate='" . TBDB_NODESTATE_PXEWAIT . "' or ".
659
                     "  np.eventstate='" . TBDB_NODESTATE_POWEROFF . "' or ".
660
                     "  np.eventstate='" . TBDB_NODESTATE_ALWAYSUP . "')) ";
661

662 663 664 665 666
if (defined($pid)) {
    $free_condition = "($free_condition and ".
	"(np.reserved_pid is null or np.reserved_pid='$pid'))";
}

667 668 669 670
# if the user has specified an exempt pid/eid, 
# then view any node which is reserved to that experiment as available.
if (defined($exempt_eid)) {
    $free_condition = "($free_condition or ".
671
	"(b.pid='$pid' and b.eid='$exempt_eid'))"; 
672
}
Chad Barb's avatar
Chad Barb committed
673

674 675 676
# In shared mode, allow allocated nodes whose sharing_mode is set.
if ($useshared) {
    $free_condition = "($free_condition or ".
677
	"(b.node_id is not null && b.erole='sharedhost' && ".
678 679 680
	" np.eventstate='" . TBDB_NODESTATE_ISUP . "'))";
}

681 682 683 684 685 686
# If the user wants all nodes, we consider everything to be free (this
# overrides the other possible free conditions
if ($allnodes) {
    $free_condition = "1";
}

687 688 689 690 691 692 693 694 695 696 697 698 699 700 701
# By default, include no wide area nodes when setting up the data structures.
#$free_condition = "($free_condition and ".
#    "(t.isremotenode=0 or ".
#    "dedicated_wa_types.attrvalue=1))";

# But if they have asked for widearea, we want this prepass to include
# these nodes.
#if ($widearea) {
#    $free_condition = "($free_condition or ".
#	"(t.isremotenode=1 and ".
#	"t.isvirtnode=0 and t.type!='pcfedphys' and ".
#	"dedicated_wa_types.attrvalue is NULL))";
#}


702
# In genimode exclude nodes with exclusion attribute.
703
if ($genimode ne $NO_GENI) {
704 705 706 707
    $free_condition = "($free_condition and ".
	"(nat1.attrvalue is null or nat1.attrvalue=0))";
}

708 709 710 711
if (defined($component_name)) {
    $free_condition = "(a.node_id = \"$component_name\")";
}

712
$result =
713
    DBQueryFatal("select a.node_id,a.type,a.phys_nodeid,t.class,t.issubnode," .
Leigh B. Stoller's avatar
Leigh B. Stoller committed
714
		 "a.def_boot_osid,(b.pid is not null and b.eid is not null), ".
715
		 "  np.reserved_pid is not null,np.eventstate, ".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
716 717
		 "  np.battery_percentage,np.uuid,b.sharing_mode, ".
		 "  ru.load_1min, ru.load_5min, ru.status_timestamp, ".
718
		 "  a.def_boot_osid, nat2.attrvalue, wn.country, " .
719
                 "  wn.latitude, wn.longitude, t.isremotenode ".
720
		 "from nodes as a ".
721 722
		 "left join reserved as b on a.node_id=b.node_id ".
		 "left join reserved as m on a.phys_nodeid=m.node_id ".
723
		 "left join nodes as np on a.phys_nodeid=np.node_id ".
724
		 "left join node_types as t on t.type=a.type ".
725 726 727 728 729 730
		 "left join node_attributes as nat1 on ".
		 "     nat1.node_id=a.node_id and ".
		 "     nat1.attrkey='protogeni_exclude' ".
		 "left join node_attributes as nat2 on ".
		 "     nat2.node_id=a.node_id and ".
		 "     nat2.attrkey='shared_weight' ".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
731
		 "left join node_rusage as ru on ru.node_id=a.node_id ".
732 733 734 735 736 737
		 "left outer join ". 
		 "  (select type,attrvalue ".
		 "   from node_type_attributes ".
		 "   where attrkey='dedicated_widearea' ".
		 "   group by type) as dedicated_wa_types ".
		 "  on t.type=dedicated_wa_types.type ".
738
                 "left join widearea_nodeinfo as wn on a.node_id=wn.node_id ".
739
		 "where $free_condition and ".
740 741 742
#		 "      a.role='testnode'"
		 "   (a.role='testnode' and (t.isremotenode=0 or ".
		 "                           dedicated_wa_types.attrvalue=1))");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
743

744 745 746
#
# Scan the results, checking permissions and adding to the list
# You get to use a node type if no pid was specified (that is, you get
747 748 749
# to use all nodes), or if there is no entry in the perms table for
# the type/class of node.
#
Timothy Stack's avatar
 
Timothy Stack committed
750
while (($node,$type,$physnode,$class,$issubnode,$def_boot_osid,$reserved,
Leigh B. Stoller's avatar
Leigh B. Stoller committed
751
	$prereserved,$eventstate,$battery_perc,$uuid,$sharing_mode,
752
	$load_1min,$load_5min,$load_tstamp,$osid,$weight,$country,$latitude,
753 754 755 756 757 758 759 760
        $longitude,$isremote) = $result->fetchrow_array) {
    my $current = $top->CreateNode($node);
    $current->SetSubnode($physnode, $issubnode);
    $current->SetRemote($isremote);

#    next
#	if ($isremote);

761 762 763
    $nodes{$node} = $type
	if (!defined($pid) ||
	    ($permissions{$type} && $permissions{$class}));
764
    $node_def_boot_osid{$node} = $def_boot_osid;
765 766 767 768 769 770

    if ($reserved) {
	$is_reserved{$node} = 1;
    } else {
	$is_reserved{$node} = 0;
    }
771
    if ($useshared && $sharing_mode) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
772 773 774
	$sharing_mode{$node} = { "load_1min"   => $load_1min,
				 "load_5min"   => $load_5min,
				 "load_tstamp" => $load_tstamp,
775 776
				 "osid"        => $osid,
				 "weight"      => $weight};
Leigh B. Stoller's avatar
Leigh B. Stoller committed
777 778 779 780
    }
    else {
	$sharing_mode{$node} = 0;
    }
Timothy Stack's avatar
 
Timothy Stack committed
781 782

    $is_prereserved{$node} = $prereserved;
783 784 785

    $curr_state{$node} = $eventstate;
    $curr_batt{$node} = $battery_perc;
786 787 788 789

    $node_countries{$node} = $country;
    $node_latitudes{$node} = $latitude;
    $node_longitudes{$node} = $longitude;
790
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
791

792 793 794 795 796
#
# Find out which nodes are connected to which, so that we can add some special
# features
#
$result = DBQueryFatal("SELECT DISTINCT node_id1, node_id2 " .
797
                       "  FROM wires where logical=0 and type!='Unused'");
798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813
my %connections = ();
while (my ($node_id1, $node_id2) = $result->fetchrow()) {
    foreach my $nodes ([$node_id1, $node_id2], [$node_id2, $node_id1]) {
        my ($node1, $node2) = @$nodes;
        if ($connections{$node1}) {
            # Check to see if we've already added this one (possible if the
            # nodes appeared in node1,node2 order, then node2,node1
            if (!grep(/^$node2$/, @{$connections{$node1}})) {
                push @{$connections{$node1}}, $node2;
            }
        } else {
            $connections{$node1} = [$node2];
        }
    }
}

814 815 816 817 818 819
@nodenames = keys(%nodes);
if ($randomize)
{
    @nodenames = shuffle(@nodenames);
}

820 821 822
#
# Loop through and print out all nodes
#
823
foreach $node (@nodenames) {
824 825 826 827 828 829
    my $current = $top->nodes()->{$node};

    # Wide area nodes are handled below
#    next
#	if ($current->is_remote());

830 831 832
    my $type  = $nodes{$node};
    my $class = $typemap{$type}->{'CLASS'};
    my $delay_capacity = $typemap{$type}->{'DELAYCAP'};
833
    my $simnode_capacity = $typemap{$type}->{'SIMCAP'};
834 835
    my $cpu_speed = $typemap{$type}->{'SPEED'};
    my $ram = $typemap{$type}->{'RAM'};
836
    my $trivspeed = $typemap{$type}->{'TRIVSPEED'};
837
    my $uuid = $nodetouuid{$node};
838
    
839
    my @types = ("$type:1");
840
    my @features = ();
841
    my @flags;
842
    my $needvirtgoo = 0;
843

844 845
    my ($latitude, $longitude, $country);

846 847 848 849 850
    # XXX temporary hack until node reboot avoidance 
    # is available. Nodes running the FBSD-NSE image
    # will have a feature def-osid-fbsd-nse 0.0
    # This is used by assign to prefer these pnodes
    # first before using others.
851 852
    if($node_def_boot_osid{$node} && ($node_def_boot_osid{$node} eq 
	TBOSID(TB_OPSPID, "FBSD-NSE"))) { 
853 854 855
	push(@features, "FBSD-NSE:0.0");
    }

856 857 858 859 860 861 862 863 864
    #
    # XXX: Temporary hack - don't march switches that are testnodes
    # as having class 'switch' - assign treats those specially. We
    # use the knowledge that 'real' switches don't hit this point!
    #
    if ($class eq "switch") {
	$class = $type;
    }
        
865
    # Might be equal, which assign would sum as two, not one!
866 867
    if ($type ne $class) {
	push(@types, "$class:1");
868 869
    }

870
    if (defined($delay_capacity) && $delay_capacity > 0) {
871 872 873 874 875 876
	# Comes from the NS file;
	$delay_capacity = $delaycap_override
	    if (defined($delaycap_override) &&
		$delaycap_override > 0 &&
		$delaycap_override < $delay_capacity);
	
877
	push @types, "delay:$delay_capacity";
878
	push @types, "delay-${type}:$delay_capacity";
879
    }
880

Leigh B. Stoller's avatar
Leigh B. Stoller committed
881 882 883 884 885 886 887 888 889 890
    #
    # Prototype shared mode.
    #
    if ($sharing_mode{$node}) {
	#
	# Add a feature that says this node should not be picked
	# unless the cooresponding desire is in the vtop. This
	# allows the node to be picked, subject to other type constraints.
	#
	push(@features, "pcshared:1.0");
891

892 893 894
	#
	# Add a first-free feature which spreads VMs amongs shared nodes.
	#
895
	push(@features, "*&spreadshared:0.6");
896

897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940
	#
	# The pool daemon may override the share weight.
	#
	if (defined($sharing_mode{$node}->{"weight"})) {
	    my $weight = $sharing_mode{$node}->{"weight"};
	    
	    push(@features, "shareweight:$weight");
	}
	else {
	    #
	    # The point of this feature is to have assign favor shared nodes
	    # that already have nodes on them, so that they are well packed.
	    # Shared nodes with just a few vnodes on them are avoided so that
	    # they will free up eventually. 
	    #
	    my $maxvnodes = 10;
	    my $weight    = 0.5;
	    my $gcount    = $globalcounts{$node} || 0.0;

	    foreach my $auxinfo (@{$auxtypes{$node}}) {
		my ($auxtype,$count) = split(":", $auxinfo);
		
		if ($auxtype eq "pcvm") {
		    $maxvnodes = $count;
		    last;
		}
	    }
	    #
	    # No point in the feature if no room left. 
	    #
	    if ($maxvnodes > $gcount) {
		my $factor = ($gcount / $maxvnodes);
		if ($factor < 0.25) {
		    $weight = 0.8;
		}
		elsif ($factor > 0.75) {
		    $weight = 0.1;
		}
		else {
		    $weight = 0.3;
		}
		#push(@features, "shareweight:$weight");
	    }
	}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
941 942
    }

943 944 945
    #
    # Add any auxiliary types
    #
Leigh B. Stoller's avatar