Re: DBD::Sybase finish and CT_CANCEL for my deadlocks

hi

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."

aaron


On Sat, Oct 01, 2005 at 07:16:36AM +0200, [email protected] wrote:
> Try calling $sth->cancel().
> 
> Michael
> 
> 
> 
> 
> Internet
> [email protected]@peppler.org - 30/09/2005 23:16
> 
> 
> Sent by:    [email protected]
> 
> 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 groups.google.com 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.
> 

-- 
http://www.vb-zone.com/upload/free/features/vbpj/1999/mckinney/mckinney1.asp
#1