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: Patch to DBD::SYbase 1.01 for nsql deadlock retry logic
Date: Nov 12 2003 6:27PM

On Wed, 2003-11-12 at 08:55, Phil.Moore@morganstanley.com wrote:
> Mike --
> 
> Please apply this patch to the next release of DBD::Sybase.  The
> nsql() implementation has a critical flaw in the deadlock retry logic
> upon which many of us depend.
> 
> When a failure occurs the errors is stashed in $err, and if that error
> is a deadlock (Message 1205), and the application has configured the
> various retry attributes, then the SQL is resubmitted correctly.
> 
> However, if a subsequent execute succeeds, the $err variable still has
> the value from the previous failure, and the code then returns no
> data.  $err needs to be reset per invocation od the DEADLOCK block.

Ouch!

Thanks - applied.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html