Hi!
Sometimes I receive error message (during development and tests, of course):
deadlock
update conflict with concurret update
concurrent transaction number is 2926
Then I can find the other attachment with the long-running transaction using:
select a.mon$user, a.mon$attachment_name, a.mon$remote_address, a.*
from mon$transactions t
left join mon$attachments a on (t.mon$attachment_id=a.mon$attachment_id)
where t.mon$transaction_id=2926
I would like to see the long-running statement as well, but
MON$STATEMENTS.MON$TRANSACTION_ID is mostly empty (null) for almost all the
records.
Why is that? And is it possible to relate statements to the transactions?
Firebird 3.0.4.
Thx.
