Hi,

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"

I cannot shutdown and restart the database at the moment, as it is during
production hours.


Regards
Marius J. Labuschagne
N Dip CDP, B Com (Strategy and IT), IMM Marketing, PPIM, PRINCE2 Certified

Turnkey Information Systems cc