Re: finishing sth using Childhandles

Ah! I think I know what happens...

You probably have the syb_flush_finish attribute turned on - which means
that DBD::Sybase will try to fetch all the results that are pending for the
active sth.

I'm going to have to look at the code to see how that could be invalidated
(or fixed!)

Michael




Extranet
henri@xxxxxxxxxxxxx - 29/08/2006 15:56

To: dbi-users

cc:


Subject: Re: finishing sth using Childhandles




On Aug 29, 2006, at 2:08 PM, michael.peppler@xxxxxxxxxxxxxx wrote:


As you see this calls the DESTROY for the sth (which cancels the
query),
and then calls the DESTROY for the dbh (which closes the
connection). There
is no special code in DBD::Sybase to handle this case AFAIK.


Thanks, I didn't have easy access to a DBI-enabled machine today :-)
However, the dbh undef calls the sth DESTROY which calls the sth
finish(), and the sth finish can, in some cases, throw an error such
as the one I had that says :
dbih_setup_fbav: invalid number of fields: -1, NUM_OF_FIELDS
attribute probably not set right

The "in some cases" above is after a signal interrupt, when the sth
is potentially a bad state.
So how do I clear the sth when I know it's in a bad state, without
calling finish() that expects the sth to be in a workable state?

H




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.

.

Relevant Pages

  • Re: finishing sth using Childhandles
    ... active sth. ... dbh or sth, I can update the dbh to turn off syb_flush_finish, which is quite logical and should be done by the client ... at that time the dbh may well be in a bad state since it's right after a signal interrupt. ... Toute utilisation de ce ...
    (perl.dbi.users)
  • Re: finishing sth using Childhandles
    ... is no special code in DBD::Sybase to handle this case AFAIK. ... However, the dbh undef calls the sth DESTROY which calls the sth finish, and the sth finish can, in some cases, throw an error such as the one I had that says: ...
    (perl.dbi.users)