[thelist] CGI script causes secondary process lock-up in Apache

[Dean Mah]

Can you send me the script?  I'd like to see how you are calling the
external programs.  Not sure if it is the same in Windows but are you
forking a child and not handling the SIGCHLD?

Dean


Joel Lieberman writes:

> I have a Perl script that makes a system call to execute an Oracle
> schema export.  The script runs well when called from a DOS command
> prompt.
>
> When the script is run as a CGI executable by reference to its URL
> (in the browser) with a single argument passed in as
> .../cgi-bin/script.pl?arg it executes the Oracle system call and the
> export dmp file is produced, but the processes then dead-lock each
> other and cannot be killed (Win2000 platform).
>
> I also tried the same idea with a DOS batch file and got the same
> lock-up when it executes in the Apache cgi environment.
>
> The last experiment was to try calling the DOS bat file from the
> Perl script.  This combination worked fine if executed from a
> command prompt, but once again, it locked itself and the files up
> when executed as a cgi call.  I also tried placing explicit "exit"
> calls into the scripts but no change in behaviour.
>
> Any ideas why the scripts execute correctly but then lock up their
> files and co-processes when called as cgi?
>
> I can help people with Oracle if needed.