Now I'm at a loss, how did you successfully create a pool of DBI handles with multiple children? I have a pool set, but as soon as my first child ends, DBI tries to clean itself up and kills all my other DBI handles with "end-of-file on communication channel during global destruction" error.

My code (trimmed down):

my %pool;
my %dbhs;

$MAX = 5;

$pm->run_on_start(\&_child_start);
$pm->run_on_finish(\&_child_finish);

my @dbhs = start_dbh();
   %pool = map { $_ => 1 } @dbhs;

foreach $i ( @is ) {
  ($next) = grep ( defined($pool{$_}), @dbhs );
  $pid = $pm->start($next) and next;
  
  $sys->set_dbh($dbhs{$next});
  sleep(rand(10));
  $pm->finish;
}

sub start_dbh() {
  %dbhs = map {
               $_ => DBI::Connect();
             } 0 .. $MAX;

  return keys %dbhs;
}

Sys::set_dbh() {
  my $this = shift;
  $this->{'_dbh-child'} = shift;
}

sub _child_start() {
 my ($pid, $ident) = @_;
 delete($pool{$ident});
 print "**** STARTED: child with PID $pid";
}

sub _child_finish(){
  my ($pid, $exit, $ident) = @_;
  print "**** FINISHED: child with PID $pid exit cide $exit";
  $pool{$ident} = 1;
}

[download]

And as soon as the first child dies all my DBI handlers spew out: DBD::Oracle::db DESTROY failed: ORA-03113: end-of-file on communication channel (DBD Error: OCISessionEnd) during global destruction.

-- philip
We put the 'K' in kwality!

In reply to Re^2: Parallel::ForkManager using up Resources? by guice
in thread Parallel::ForkManager eating up Resources? by guice

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.