Subject Re: [firebird-support] Anyone know what this error means, isc_req_sync?
Author Helen Borrie
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!