Groups | Search | Server Info | Login | Register

Groups > perl.dbi.users > #3389

Re: Weird issues using DBI + mod_perl

Show all headers | View raw

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 / felix@crowfix.com
  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

Back to perl.dbi.users | Previous | Next — Previous in thread | Find similar

Thread

AW: Weird issues using DBI + mod_perl andreas.mock@web.de ("Andreas Mock") - 2019-08-16 23:47 +0200
  Re: Weird issues using DBI + mod_perl felix@crowfix.com (Felix Finch) - 2019-08-16 18:18 -0700

csiph-web