Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Tim_Green at mercer dot com
Subject: Re: Sybperl and fork ()
Date: Aug 19 1998 10:33PM

     I've had a child process use a connection originally opened by the 
     parent with great success, though others have claimed bad things can 
     happen.  On our platform things work fine (perl5.003, sybperl 2.05, 
     HPUX 10.20), except for some memory leaks which I don't believe are 
     related to the forked processes at all.  We've been in production with 
     a system that does this since March, 1997, with hundreds, maybe even 
     thousands, of child processes spawned a day.
     In our situation we _are_ careful that the parent and child never 
     attempt to use the connection at the same time which I think has 
     caused some people grief.
     If anyone else can comment about why others have found such problems 
     with this I'd like to know too.

______________________________ Reply Separator _________________________________
Subject: Sybperl and fork()
Author: at uucp
Date:    8/19/98 10:34 AM

I believe this was covered before, but what happens to a DBLibrary 
connection after a fork()?  My gut feeling is to close the connection in 
the child proc immediately after the fork, and open a new one, and to 
leave the process in the parent process alone.
Is this correct?
Steven Wechsler/Sybase DBA/Sanford C. Bernstein & Co., Inc. 
"Never underestimate the power of human stupidity" - Lazarus Long 
Support the Anti-SPAM amendment: