Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 38586
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: nathan.eaves [...] datavail.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.22
Fixed in: 1.23



When connecting to multiple instances, if the second connection fails, the first connection is damaged. Any additional activities to the first connection will result in the following error: OCIHandleAlloc(OCI_HTYPE_STMT) failed at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBD/Oracle.pm line 276. First connection: my $dbh = DBI->connect( "dbi:Oracle:host=$Server;sid=$SID;port=$Port", $User,$Passwd, { PrintError => 0, RaiseError => 1 } ); Second connection: eval { # local $SIG{ALRM} = sub {die "Connection Timeout\n";}; my $h = set_sig_handler( 'ALRM' ,sub { die "Instance Connection Timeout" ; } ); alarm( $connectionTimeout ); $rdbh = DBI->connect ( "dbi:Oracle:host=$rhost;sid=$rSID;port=$rport", $rUser,$Password, { PrintError => 0, RaiseError => 0 } ); alarm( 0 ); }; This is perl, v5.8.5 built for i386-linux-thread-multi rhel5 linux. Problem occurs when second connection is remote. If the second connection succeeds, then problem does not occur.
Download (untitled) / with headers
text/plain 181b
I finally found the issue and fixed it in trunk which can be found here http://svn.perl.org/modules/dbd-oracle/trunk seems I was a little over aggressive in my cleanup of handels


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.