Re: [firebird-support] lock conflict deadlock

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
 
chow do you check that transaction is readonly?
in your select this field is not included
 
regards,
karol Bieniaszewski
 
 
W dniu 2016-04-05 15:29:11 użytkownik shg_siste...@yahoo.com.ar 
[firebird-support] <firebird-support@yahoogroups.com> napisał:
 
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