I apologize, the deadlock was not happening on commit, it was
happening on the query.

BUT, often, Firebid cannod detect the deadlocks and all my clients
are just blocking on the query. I waited about 10 minutes for them to
unblock, they did not. Why does this happen?

I tried DEFAULT, as well as CONCURRENCY|WAIT,
READ_COMMITIED|NO_REC_VERSION|WAIT. I even tried CONCURRENCY|NOWAIT,
but it happens in this case as well.

any help would be appreciated.

thanks,

stan

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> Stan wrote:
> > This is a followup question to this topic.
> >
> > I am now encountering a situation where I get deadlocks on the
> > inserts,
>
> what transaction modes and options are you using?
>
> Regards,
>
>
> Ann
>