I'll second that. Try being hyper-paranoid about handles -- explicitly finish
them at the earliest opportunity. Close everything before a fork. I have had
too many lapses of sanitary etiquette bite me in weird ways.
On 20190816, Andreas Mock wrote:
Hi Bruce,
I'm just guessing
Also make sure you set AutoInactiveDestroy, which would be default if not
for back compat, otherwise a fork that doesn't even use the handle may
close your connections.
Making sure connections are specific to one process can be tedious,
especially when you are not controlling the processes, one
Hi Bruce,
I'm just guessing, but this sounds much like reusing or double using of Oracle
db handles, context handles or statement handles.
You have to have a look at the bookkeeping of the handles per request. Also
forking of the childs may byte you.
You must ensure that db handles are ONLY
So I’ve built a site using mod_perl in CGI mode, with DBI and Oracle as my
database back end.
Everything works fine for a while but then I get intermittent weird errors that
start happening for every page load, which is resulting in non-functional pages
and error messages “Something happened