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: Good Times <aaron at rdu90 dot com>
Subject: Re: DBD::Sybase finish and CT_CANCEL for my deadlocks
Date: Oct 3 2005 4:21PM


tried that, didn't work

i'm still getting the "This routine cannot be called while results are pending for a command that has been sent to the server."


On Sat, Oct 01, 2005 at 07:16:36AM +0200, wrote:
> Try calling $sth->cancel().
> Michael
> Internet
> - 30/09/2005 23:16
> Sent by:
> To:    sybperl-l
> cc:
> Subject:    DBD::Sybase finish and CT_CANCEL for my deadlocks
> Hello everyone
> I have an application that runs every five minutes to execute a stored proc
> from time to time thoughout the day, it deadlocks
> i put some code in to catch the deadlock and re-execute the statement
> but I get a message telling me that I can't do that while results are
> pending for another request
> So, I added a finish() call on the statement handle, but that doesn't seem
> to help
> Looking through the archives and it seems what I need to
> do is call CT_CANCEL and when I look in Sybase::Simple I see that it does
> just that
> However, I'm a DBI man, and finish() according to the research I've done
> "can" call CT_CANCEL, which makes me think that it won't always
> I've tried this using syb_flush_finish set to true and false and still the
> same thing
> i'm using DBD::Sybase 1.05 and Sybase 12.5
> Is there a way to call CT_CANCEL? Or is there something else I could be
> doing?
> aaron
> --
> I don't know what you're talking about that he is obnoxious.  He was sweet
> as pie to me!
>       -Aileen
> This message and any attachments (the "message") is
> intended solely for the addressees and is confidential. 
> If you receive this message in error, please delete it and 
> immediately notify the sender. Any use not in accord with 
> its purpose, any dissemination or disclosure, either whole 
> or partial, is prohibited except formal approval. The internet
> can not guarantee the integrity of this message. 
> BNP PARIBAS (and its subsidiaries) shall (will) not 
> therefore be liable for the message if modified. 
>                 ---------------------------------------------
> Ce message et toutes les pieces jointes (ci-apres le 
> "message") sont etablis a l'intention exclusive de ses 
> destinataires et sont confidentiels. Si vous recevez ce 
> message par erreur, merci de le detruire et d'en avertir 
> immediatement l'expediteur. Toute utilisation de ce 
> message non conforme a sa destination, toute diffusion 
> ou toute publication, totale ou partielle, est interdite, sauf 
> autorisation expresse. L'internet ne permettant pas 
> d'assurer l'integrite de ce message, BNP PARIBAS (et ses
> filiales) decline(nt) toute responsabilite au titre de ce 
> message, dans l'hypothese ou il aurait ete modifie.