Subject | Explanation of entry in Monitoring Tables |
---|---|
Author | slalom91 |
Post date | 2008-11-03T23:08:54Z |
I am seeing a record in the monitoring tables which looks suspicious
and would like some explanation, if possible. The query I am issuing
is:
Select *
from Mon$Statements ms
join mon$attachments ma on (ma.mon$attachment_id = ms.mon$Attachment_ID)
join mon$transactions mt on (mt.mon$attachment_id =
ms.mon$attachment_ID)
I am seeing a set of records with the same mon$attachment_id with an
SQL statement populated in Mon$SQL_Text, but the mon$transaction_id is
null and the mon$state is 0.
Shouln't there be an associated transaction with this record or is this
entry pointing to some other issue?
and would like some explanation, if possible. The query I am issuing
is:
Select *
from Mon$Statements ms
join mon$attachments ma on (ma.mon$attachment_id = ms.mon$Attachment_ID)
join mon$transactions mt on (mt.mon$attachment_id =
ms.mon$attachment_ID)
I am seeing a set of records with the same mon$attachment_id with an
SQL statement populated in Mon$SQL_Text, but the mon$transaction_id is
null and the mon$state is 0.
Shouln't there be an associated transaction with this record or is this
entry pointing to some other issue?