Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Infinite loop calling error handler
Date: Jun 11 2004 4:01PM

On Fri, 2004-06-11 at 17:47, Avis, Ed wrote:
> When using DBD::Sybase to call a stored procedure I found that my
> program would hang and very rapidly start chewing up memory.  This
> didn't happen for every call but only for one which failed (a
> raiserror and negative exit status from the stored procedure).  It may
> also be relevant that I had two statement handles open, one querying
> a table and one running the proc.
> I got some way to debugging this but then it mysteriously stopped
> being reproducible.  However I did find out that the error handler was
> being called again and again, and probably recursively since the
> memory usage of the program rapidly rose to 1600 megabytes and CPU
> use was at 100% when I killed it.  My program looks like

It's too bad that you weren't able to run this with a DBI->trace(3).
That would have given me a lot more information.

I'll try to see if I can reproduce this.

Michael Peppler                              Data Migrations, Inc.             
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions -