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

Owner: Nobody in particular
Requestors: nathan.eaves [...]

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/ 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 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 infrastructure.

Please report any issues with to