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