Hi Bruce,

 

thank you for the feedback.

 

Have you posted it under "#use" ? :-))))

 

Best regards

Andreas

 

 

Von: Bruce Johnson <john...@pharmacy.arizona.edu> 
Gesendet: Dienstag, 3. September 2019 18:36
An: Andreas Mock <andreas.m...@web.de>
Cc: dbi users <dbi-us...@perl.org>; mod_perl list <modperl@perl.apache.org>
Betreff: Re: Weird issues using DBI + mod_perl

 

Just a follow up…it was embarrassingly stupid. You know how you can stare at an 
error in a line dozens of times and not see it? Like the ‘#' commenting out 
"use Apache::DBI” in your startup.pl file ... 





On Aug 16, 2019, at 2:47 PM, Andreas Mock <andreas.m...@web.de 
<mailto:andreas.m...@web.de> > 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.

Best regards
Andreas

 

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

 

Reply via email to