laziness, impatience, and hubris | |
PerlMonks |
Re: scope and undefby pilcrow (Sexton) |
on Aug 29, 2007 at 01:43 UTC ( [id://635707]=note: print w/replies, xml ) | Need Help?? |
the expected result is that once i undef the $self->{dbo} variable, it would fall out of scope and the database connection would be implicitly released. What does DBI->trace reveal? That will show whether the underlying DBI handles are themselves actually destroyed or not. IIRC, the DBD::Oracle driver under high tracing will dump OCI calls -- so you should see DESTROYs followed by OCISessionEnd (I think) on successful implicit disconnects. Is InactiveDestroy set to true on the DBI handles? Does netstat/lsof/whatever confirm that your process has redundant DB connections open? Your suspicion may be correct, but the symptoms are also consistent with at least a bug holding on to DBI handles, undesirable "Activeness" attributes, or a faulty proxy (circuit or DB-aware) between the daemon and the DB.
In Section
Seekers of Perl Wisdom
|
|