|Subject||Re: [firebird-support] Unlock record|
- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).
- Opened the database with IB_SQL.
- Identified the record of MON$ATTACHMENTS table associated with my application.
- Try to delete this record.
- I got the error message "operation not supported".
Am I doing something wrong or I must do some other thing before deleting that record?
Asunto: Re: [firebird-support] Unlock record
De: Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firstname.lastname@example.org>
Para: email@example.com <firstname.lastname@example.org>
Fecha: 24/01/2015 11:50
>I saw the same as you, and made the following test:
>- Opened my application.
>- Executed the option which locks a record (executes a SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).
>- Opened the database with IB_SQL.
>- Looked in table MON$STATEMENTS. I found many records. Many of them with MON$SQL_TEXT null. Only one of them had MON$TIMESTAMP not null.
>- I deleted the only record with MON$TIMESTAMP not null.
>- I opened another instance of IB_SQL and verified that the record I locked at the first step was still locked.
>Am I undestanding something wrong or this doesn´t work?
>Another idea to manually unlock a record?
Finally got temporary access to a computer and can confirm that deleting from mon$statements is not enough when using WITH LOCK (I never use WITH LOCK myself). However, I did get access to this record (using Fb 2.5) by deleting from MON$ATTACHMENTS. There may or may not be other, less intrusive ways to get such access, though I failed when I tried MON$TRANSACTIONS.
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.