| Subject | Re: [firebird-support] lock conflict deadlock |
|---|---|
| Author | |
| Post date | 2016-04-05T14:01:43Z |
sorry, I just copied a part of the select in the message. I do include that flag in the actual select.
Here it is the complete select. I'm sending '-1' in "in_trans"
select
ma.mon$attachment_id,
mt.mon$transaction_id,
ma.mon$server_pid,
ma.mon$state,
ma.mon$attachment_name,
ma.mon$user,
ma.mon$role,
ma.mon$remote_protocol,
ma.mon$remote_address,
ma.mon$remote_pid,
ma.mon$character_set_id,
ma.mon$timestamp,
ma.mon$garbage_collection,
ma.mon$remote_process,
ma.mon$stat_id,
mt.mon$read_only
from
mon$transactions mt
left join mon$attachments ma on ma.mon$attachment_id = mt.mon$attachment_id
where (mt.mon$transaction_id = :in_trans) or (:in_trans = -1)
order by mt.mon$transaction_id