|Subject||Re: [firebird-support] lock conflict deadlock|
Definitely there should transaction which produces conflict, probably your query does not catch it.
You can track it with Monlogger - download HQbird, install it and register as trial (14 days), then connect with MonLogger to your database and at the moment of error message click get Snapshot.
MonLogger saves all data from MON% tables for the investigation in the folder, and on the tab Transaction it highlights with red color those transactions which are potentially conflict, so you can review which application runs it.
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