|Subject||lock conflict deadlock|
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.
left join mon$attachments ma on ma.mon$attachment_id = mt.mon$attachment_id
order by mt.mon$transaction_id