--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

>
> > Is there something I can do to find out which user is locking a particular
> > record in a database? If I can use the transaction number to lookup the
> > user, then I may be able to simply ask that user to re-start his machine?
> > The server is running Firebird Superserver 2.1.4 on Windows.
> >
> > I am trying to delete some records in a table but the following message is
> > displayed:
> >
> > "lock conflict on no wait transaction deadlock update conflicts with
> > concurrent update concurrent transaction number is 7850179"
>
> If your database has an ODS of at least 11.1, then you can do:
>
> select
> a.*
> , t.*
> from
> mon$transactions t join mon$attachments a on (t.mon$attachment_id =
> a.mon$attachment_id)
> where
> mon$transaction_id = 7850179
>
>
> This will give the transaction and attachment information for this
> particular transaction id.
>

I am a bit confused. My application gives me a deadlock error and its transaction ID. That is of not much use imo, I already know it is my process which cannot access the record.
What I would like to know is which process/attachment holds the lock which stops me from working on that record. How can I get the transaction ID, or any other identifying data, of the other process?

Regards
Peter