Hi,

We have a problem with DBD::Sybase appearing to hang using mod_perl with perl 
5.8.5 under multiple processes.  When I run it using the -X flag 
(single-process), everything is fine, but when I don't use -X and it forks 
children it hangs the sybase processes.  The Oracle processes still respond.

DBD::Oracle-1.15 works fine in both multi-mode and single-mode.

        DBD::Sybase-1.04 
        perl-5.8.5  
        mod_perl-1.29 
        apache-1.3.27 
        linux

Attached are the perl config and the loaded modules lists from 
admin/perl-status.

I don't know if this helps, (this may be normal behaviour...), but the parent 
process appears to be doing this:

        strace -p 29080
        select(0, NULL, NULL, NULL, {0, 280000}) = 0 (Timeout)
        time(NULL)                              = 1100073030
        wait4(-1, 0xbffec77c, WNOHANG, NULL)    = 0
        select(0, NULL, NULL, NULL, {1, 0})     = 0 (Timeout)
        time(NULL)                              = 1100073031
        wait4(-1, 0xbffec77c, WNOHANG, NULL)    = 0
        select(0, NULL, NULL, NULL, {1, 0})     = 0 (Timeout)
        time(NULL)                              = 1100073032
        wait4(-1, 0xbffec77c, WNOHANG, NULL)    = 0

Various of the original child processes appear to be doing this:

        strace -p 29087
        accept(16,

And the most recent child process appears to be sitting on a read:

        strace -p 29236
        read(5,

Anyone have any bright ideas, please?

Ciao
Richard Foley

http://www.oreilly.com/catalog/perldebugpr/ 
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  The sender therefore 
does not accept liability for any errors or omissions in the contents 
of this message which arise as a result of e-mail transmission.  If 
verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities or 
related financial instruments.

Reply via email to