| Subject | Re: [firebird-support] Anyone know what this error means, isc_req_sync? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-07-27T03:33:26Z |
At 10:55 PM 26/07/2004 +0000, you wrote:
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.
/heLen
>I am getting th error "isc_req_sync" a lot all of a sudden. I cannotIt is gdscode 335544364 req_sync Request synchronization error. From hazy
>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.
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