>>>>> "PH" == Perrin Harkins <[EMAIL PROTECTED]> writes:
PH> Are you loading the Oracle driver in the parent process (with
PH> startup.pl)? I think I remember this sometimes causing problems
PH> with re-connecting.
No, but we did hand load it in a module called from perl.conf with
PerlModule. We had a good reason for that, too (to do with the Oracle
driver overloading alarm(), so that the second alarm in
alarm(20);
$dbh = DBI->connect("dbi:Oracle:...", ...);
alarm(0);
cleared a different type of alarm that the first call set ...)
PH> Another solution is to have the child process exit if the ping
PH> fails. You get one failed request, but you clear out the messed
PH> up processes quickly and replace them with new ones that can
PH> connect safely.
Yeah, good point. Although our poor little WAP service (for that is what
was for) gets so few hits, they'll all be getting failed if we do that ;>
- Adam
