> 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. You can also look up the statements associated to this transaction id by executing: select * from mon$statements where mon$transaction_id = 7850179 > I cannot shutdown and restart the database at the moment, as it is during > production hours. It shouldn't be necessary. It's also possible to kill a particular statement by executing a DELETE statement on the MON$STATEMENTS table. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/ > Regards > Marius J. Labuschagne > N Dip CDP, B Com (Strategy and IT), IMM Marketing, PPIM, PRINCE2 Certified > > Turnkey Information Systems cc
