hi

I'm having problems with DBD::Oracle built with Oracle Instant Client on Linux (RHEL 3 U6). Occasionally when i run my application from the command line the process receives a segmentation fault and sometimes it terminates with an 'Out of memory' message.

I've been able to reproduce the issue with a simple script that just connects to the database and does nothing else:

use strict;
use DBI;
my $dbdsn;
#use Digest::SHA1;
$dbdsn = 'dbi:Oracle:host=foo.bar.com;sid=devel5';
my $dbuser = 'baz';
my $dbpass = 'baz';
my $dbh = DBI->connect("$dbdsn", "$dbuser/$dbpass", '');
print "dbh: $dbh\n";
1;

When i run the script with the 'use Digest::SHA1;' line commented the process occasionally terminates with a message like the following:

Out of memory during request for 964 bytes, total sbrk() is 1320960 bytes!

but segmentation faults don't seem to occur. The process seems to be reserving quite a bit of memory for a simple script according to the above message. The strace includes over 69000 brk() calls (the strace attachment files don't seem to come through to this list).

When I load the Digest::SHA1 module segmentation faults occur once in a while. The frequency changes but here's how many times i had to run the script until i received the segmentation fault on 5 separate runs: 83, 47, 51, 173, 5.

I've tested this on another machine with Red Hat Enterprise Linux 4 U2 and after over 4000 runs i haven't seen a single out of memory error or segfault.

I've built DBD::Oracle 1.16 (DBI 1.42) with Oracle Instant Client 10gR2 on Red Hat Enterprise Linux 3.0 (update 6). The build procedure followed the build recipe described by Tim Barrass and posted on dbi- users earlier (the recipe includes setting up the IC directory structure in a similar manner as with normal Oracle client installation and a Makefile.PL patch). I've installed the following IC packages:

        instantclient-basic-linux32-10.2.0.1-20050713.zip
        instantclient-sdk-linux32-10.2.0.1-20050713.zip
        instantclient-sqlplus-linux32-10.2.0.1-20050713.zip

The problem doesn't appear on the same RHEL 3 machine with DBD::Oracle built with the full Oracle10g R2 client (tested with over 3000 runs).

Is anyone having similar problems with DBD::Oracle built with the Oracle Instant Client? Any ideas on how to resolve this problem?


br. aspa

Reply via email to