Re: Weird issues using DBI + mod_perl

[email protected] (Felix Finch) Fri, 16 Aug 2019 18:18:32 -0700
Newsgroups perl.dbi.users
Message-ID <[email protected]>
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, 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 opened in the child process doing the work and get closed properly.
>
>With DBI in use you can use the variable DBI_TRACE to get extensive log. Google for that in combination with mod_perl.
>
>Just some hints.

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & wood chipper / [email protected]
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o