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: 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
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html