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