--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

cannot

> >find any mention of this in the Docs (at least the ones I know

about).

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

a

> 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

should

> 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?

Thanks
Kevin