|Subject||Re: [firebird-support] Unlock record|
|Author||Walter R. Ojeda Valiente|
On Thu, Jan 22, 2015 at 1:50 PM, Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firstname.lastname@example.org> wrote:
>I looked in a database, and in MON$STATEMENTS tabla I have the following fields:
>How can I detect which is the record I have to delete to unlock my record? This is the only table I have to modify?
I typically just look at the mon$sql_text with a mon$timestamp that seems to be the correct one.
-------- Mensaje original -------
>> May be I can modify or delete some record in any MON$ table or do some other thing?
>I typically locate and delete records from MON$STATEMENTS. Mind you, that is 2.5 and typically when I have a long-
>running query. Don't know whether deleting from this table is possible or safe with 2.1 or sensible WITH LOCK.