Just thought I'd report on a puzzling bug ... for us it was caused by a
firewall, but I can imagine you'd get the same behaviour if packets to
your Oracle box starting falling into a hole.
Symptom:
Apache children hanging for almost exactly 12 minutes on DB
transactions, usually early weekday
Apache::DBI's ping check worked fine, but when the dbh was ejected from
the cache (and so went out of scope), something in the DESTROY stack
was blocking, and holding the child up for 12m. I'm guesing the
underlying DBD::Oracle code was trying to do a nice shutdown on the
dbh, but
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.
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