Re: DBD::Oracle / Instant Client segfaults
- From: marko.asplund@xxxxxxxxxxxx (Marko Asplund)
- Date: Sat, 28 Jan 2006 21:48:17 +0200
hi
I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. When I configure Perl without -Dusemymalloc everything works fine. The issue doesn't appear with Oracle10g full client on RHEL 3 or with OIC on RHEL 4, Solaris 8 or HP-UX 11i v1.
I've reported this issue to Oracle but does anyone have clues on what is causing this or suggestions on how to get this fixed on the Perl side? I'd really need to use -Dusemymalloc and Oracle Instant Client.
br. aspa
On 2005-12-29, at 14.26, Marko Asplund wrote:
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
.
- Prev by Date: Re: REG: dbi::errstr error.
- Next by Date: Fetchrow_hashref failure with postgres array data type
- Previous by thread: Reg: auto_increment issue.
- Next by thread: Fetchrow_hashref failure with postgres array data type
- Index(es):
Relevant Pages
|
