Subject Re: I dont know why sweep is not doing clean
Author
Thanks for all answers!
I'm still with this problem, I would like to revisit the issue.
I've checked transactions in mon$ tables and I can't find the transaction in order to kill it.
For example, right now I have:

Oldest transaction 963037
Oldest active transaction 1552161
Oldest snapshot 1552161
Next transaction 1552165

mon$transactions contents:
DB_KEYMON$TRANSACTION_IDMON$ATTACHMENT_IDMON$STATEMON$TIMESTAMPMON$TOP_TRANSACTIONMON$OLDEST_TRANSACTIONMON$OLDEST_ACTIVEMON$ISOLATION_MODEMON$LOCK_TIMEOUTMON$READ_ONLYMON$AUTO_COMMITMON$AUTO_UNDOMON$STAT_ID
00000023:000000011553643377413119.03.2014, 18:50:50.9381553643963037
mon$statments contents:

DB_KEYMON$STATEMENT_IDMON$ATTACHMENT_IDMON$TRANSACTION_IDMON$STATEMON$TIMESTAMPMON$SQL_TEXTMON$STAT_ID
00000024:00000001690133774131554052119.03.2014, 18:51:51.384SELECT RDB$DB_KEY, MON$STATEMENT_ID, MON$ATTACHMENT_ID, MON$TRANSACTION_ID,
MON$STATE, MON$TIMESTAMP, MON$SQL_TEXT, MON$STAT_ID
FROM MON$STATEMENTS
5
00000024:0000000253259377413NULL0NULLSELECT RDB$DB_KEY, MON$TRANSACTION_ID, MON$ATTACHMENT_ID, MON$STATE,
MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION,
MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY,
MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID
FROM MON$TRANSACTIONS
6
I appreciate suggestions to find the transaction.
Thanks in advance!!

Vanina