[firebird-support] Re: Lock conflict on no wait transaction - finding the user.

[Alexandre Vinhaes - DBA - TIC [e-mail] [firebird-support]]

Hi all,
how to query transactions/users in "waiting for lock" ? It would be usefull
in time of problems. In other words, I would like to have the related query
to execute via isql and identify users waiting another transactions
blocking row or range of rows.


Thanks.


Atenciosamente.
Alexandre Vinhaes
[phone]
Administrador de Banco de Dados - Setor Informática




2016-12-06 13:20 GMT-02:00 Alexandre Vinhaes - DBA - TIC <

Hi all,
how to query transactions/users in "waiting for lock" ? It would be
usefull in time of problems. In other words, I would like to have the
related query to execute via isql and identify users waiting another
transactions blocking row or range of rows.
Thanks.
Alexandre.