Hello! I'm having a problem which I don't undestand. I'm getting a deadlock
error in my app, but when I see the active transactions (I attach the select
I'm using) I see all read-only transactions active.
So, the question is: How can I get a deadlock error when I have just read-only
transactions active?
To solve the problem, I have to stop/restart Firebird.
Thanks!!
Sergio
---
select
ma.mon$attachment_id,
mt.mon$transaction_id,
ma.mon$server_pid,
ma.mon$state,
ma.mon$attachment_name,
ma.mon$user
from
mon$transactions mt
left join mon$attachments ma on ma.mon$attachment_id =
mt.mon$attachment_id
order by mt.mon$transaction_id
