PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: mcovic at lehman dot com (Mladen Covic)
Subject: Re: fyi re: sybperl memory issues [mpeppler@mbay.net: memleak in dblogin]
Date: Apr 29 1998 7:13PM

>From my experience, 512 bytes are leaking any time you execute DBlib sql command
($DBH->sql($sql_cmd))

Mladen

> 
> -----Forwarded message from Michael Peppler -----
> 
> From: Michael Peppler 
> Date: Tue, 28 Apr 1998 16:41:51 -0700 (PDT)
> To: SYBPERL-L@trln.lib.unc.edu
> Subject: memleak in dblogin
> 
> Mark Gibson writes:
>  > I think I've stumbled on a memory leak in dblogin. Running this will cause 
>  > the memory to grow:
>  > 
>  > while (1) {
>  >   $db = Sybase::DBlib->dblogin('login','password');
>  >   $db->dbclose();
>  > }
>  > 
>  > Im using sybperl 2.09,perl5 (5.0 patchlevel 4 subversion 4),Sybase 11.0.2
>  > and solaris 5.4.
>  > 
>  > 
> 
> This is actually a known problem. I guess it should make it into some
> sort of BUGS file in the distribution. I have not found the culprit -
> ie if it's my code or somewhere in perl's internals that the leak
> happens.
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> 
> 
> -----End of forwarded message-----
> -----Forwarded message from Ashutosh Joglekar -----
> 
> Date: Wed, 29 Apr 1998 08:30:17 -0400
> From: Ashutosh Joglekar 
> To: SYBPERL-L@trln.lib.unc.edu
> Subject: Re: memleak in dblogin
> 
> Michael Peppler wrote:
> 
> > I have not found the culprit - ie if it's my code or somewhere in perl's
> > internals that the leak
> > happens.
> 
>  I think the culprit is DBLibrary itself. I have noticed memory leaks in the
> dblogin call in C programs (i.e. no perl, just C DBlib) while Purifying them.
> (dbfcmd also leaks some memory by the way.)
> 
> dblogin also winds up calling some solaris system functions that don't close some
> file handles. (I might have the name wrong but I believe the function was called
> door something... man door turns up a rather interesting man page.)
> 
> Cheers,
> Ashu
> 
> -----End of forwarded message-----
>