Multiple open transactions in idle instance

XMLWordPrintable

      When using SQLServer 2008 database there is a number of open transactions reported by the database engine on idle Crucible instance.
      This can be easily reproduced by starting clean Crucible instance and running following queries:

      SELECT at.transaction_id, 
       at.transaction_begin_time, 
       at.transaction_state,
       at.transaction_status,
       at.transaction_status2,
       at.dtc_state,
       at.dtc_status,
       st.session_id,
       STH.text
FROM sys.dm_tran_active_transactions at
LEFT JOIN sys.dm_tran_session_transactions st 
LEFT JOIN sys.dm_exec_connections CN ON CN.session_id = st.session_id
    ON at.transaction_id = st.transaction_id
CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS STH
ORDER BY transaction_begin_time;

SELECT count(*) FROM sys.sysprocesses t where t.open_tran=1;

      Similar behaviour can be observed on Postgres DB, using following queries:

      select * from pg_stat_activity;
select count(*) from pg_locks;

            Assignee:
            Piotr Swiecicki
            Reporter:
            Piotr Swiecicki
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: