because i found sometime my client application (in C and using ODBC
API library) takes longer time to complete and sometime fast. I don't
know whether my query that send from my application is in deadlock or
not.

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

> Chooi-Ting wrote:
>
> >how do we know that database deadlock has happenned ? by using
> >command gstat ? or gds_lock_print ?
> >
> When one process has been waiting for a lock for 10 seconds, the
> database walks the lock graph, looking for deadlocks. If it finds

one,

> it sends a failure notification to one of the participants. Why

do you

> ask?
>
> Regards,
>
>
> Ann