Subject Re: Anyone know what this error means, isc_req_sync?
Author kshenes
--- In, Helen Borrie <helebor@t...>
> At 10:55 PM 26/07/2004 +0000, you wrote:
> >I am getting th error "isc_req_sync" a lot all of a sudden. I
> >find any mention of this in the Docs (at least the ones I know
> >or any mention of it on the internet. Can someone fill me in on
how to
> >avoid this error condition, and what it means.
> It is gdscode 335544364 req_sync Request synchronization error.
From hazy
> recollection, it occurs when the application requests a requery for
> select statement while the statement is still fetching or calls
rollback or
> commit on a transaction that has requests in this state.
> If so (no guarantees!!) then you could put the request in a retry
loop that
> catches this exception. If the queries are outside your control,
e.g. a
> user can request a SELECT * on a table with 5 million rows, you
> probably limit the number of retries before denying the request
> absolutely. There isn't currently a way to stop a runaway query.
> >I am running v1.0.3 on debian linux.
> Pleased to hear it!
> /heLen

This is very helpful, Thanks. Now an addition tidbit. I am
encountering this error when retrying an a select statement after
encountering a limbo transaction error. So does this mean the
transaction is out of limbo state and the query has proceeded before
I retry? What is the best way to handle limbo transactions errors
encountered during a query?