$request->enqueue( [$dbname,$dataEntity{$dbname}] );
And the very down-level version of threads you are using is almost certainly the source of your problem.
You might be able to fix it without upgrading by changing the code to be:
use threads::shared;
...
for my $dbname (keys %dataEntity) {
my @args :shared = ( $dbname,$dataEntity{$dbname} );
$request->enqueue( \@args );
};
But I would still suggest upgrading threads, threads::shared and Thread::Queue ASAP.
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
| [reply] [d/l] [select] |
Thanks for reply and help Browser UK.
Need you help and opinion for disigning this collector.
Requirement: I will have many dataservers and host that will be divided in multiple groups( wil contain dataservers). We need to connect to each of dataserver/host and execute some commands/utility and process the data, bring back the data and write into a file. ex: DSA1,DSA2...DSAN
1. conenct to DSA1, process and get the data and write into a file
2. once we get the data back from DSA1, may be after 1/2 hour will need to conenct again and get back data...this will continue depending on interval time.
above step 1 and 2 should run for many servers ( may be 1000s). Do you think thread queue is best way for this requirement ?
is below code is the best way to move forward ? how will I run the job again for particular group or DSA on demand basis?
Thanks a lot for your help in advance. any suggestions/directions will help.
#!/usr/bin/perl
use strict;
use threads;
use Data::Dumper;
use Thread::Queue;
warn "Using threads $threads::VERSION";
warn "Using Thread::Queue $Thread::Queue::VERSION";
my $THREADS = 3;
my %dataEntity;
while(<>){
chomp;
next if !length($_);
my ($dsName,$passwd) = split /\|/, $_;
$dataEntity{$dsName} = $passwd;
}
my $request = Thread::Queue->new;
my $response = Thread::Queue->new;
# Submit all requests
for my $dbname (keys %dataEntity) {
$request->enqueue([$dbname,$dataEntity{$dbname}]);
};
# Tell each thread that we're done
for (1..$THREADS) {
$request->enqueue(undef);
};
# Launch our threads
for (1..$THREADS) {
async(\&getData);
};
sub getData {
##
my $idx = 1;
while (my $job = $request->dequeue()) {
my ($dbname, $credentials) = @$job;
#connect to DB, retrieve information
#my $dbh = getConn($dbname,$credentials);
my %results;
#my $resArrRef = $dbh->selectall_arrayref("select srvname,dbna
+me from syslogins",{ Slice => {} });
# package some dummy results
my $resArrRef = [
{ srvname => "server:$dbname:".$idx++, dbname => $dbname,
+},
{ srvname => "server:$dbname:".$idx++, dbname => $dbname,
+},
{ srvname => "server:$dbname:".$idx++, dbname => $dbname,
+},
{ srvname => "server:$dbname:".$idx++, dbname => $dbname,
+},
];
foreach my $row ( @$resArrRef ) {
$results{$row->{srvname}} = $row->{dbname};
}
$response->enqueue(\%results);
}
# tell our main thread we're done
$response->enqueue( undef );
##
}
while ($THREADS) {
while (my $payload = $response->dequeue()) {
print Dumper $payload;
};
$THREADS--
}
sub getConn {
my ($DB,$pwd) = @_;
return $dbh;
}
| [reply] [d/l] |
You have reposted the code I gave you in 859377. You will need to do some actual programming yourself. This is not a code writing service.
If you want to request servers repeatedly, put them into the queue repeatedly.
| [reply] |
1. conenct to DSA1, process and get the data and write into a file
- Connect:
What type of connection? DBI, SSH, tcp?
- Process:
Process locally (in your program), or remotely on the server?
How long will that processing run?
- Get the data:
How much data?
- Write to file:
Just read & write as is, or read, process locally and write?
- Connect again may be after 1/2 hour:
Exactly half an hour? Or as quickly as possible after all other servers have been serviced?
What determines the frequency of reconnection? How important is the timing? Must it be done to the second, or is 'best endevours' good enough?
- should run for many servers ( may be 1000s):
You don't yet know? How many 1000s?
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
| [reply] |
Well, I use the following versions:
Using threads 1.73 at tmp.pl line 6.
Using Thread::Queue 2.11 at tmp.pl line 7.
So maybe just upgrading Thread::Queue or upgrading threads, or upgrading both might help. The posted code works for me, that's all I can say. | [reply] [d/l] |