Hi, Did you started sweep manually? Or you wait for automatic sweep?
Regards, Karol Bieniaszewski ----- Reply message ----- Od: [email protected] Do: <[email protected]> Temat: [firebird-support] Re: I dont know why sweep is not doing clean Data: śr., mar 19, 2014 23:00 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_ID00000023:000000011553643377413119.03.2014, 18:50:50.9381553643963037mon$statments contents: DB_KEYMON$STATEMENT_IDMON$ATTACHMENT_IDMON$TRANSACTION_IDMON$STATEMON$TIMESTAMPMON$SQL_TEXTMON$STAT_ID00000024: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$STATEMENTS500000024: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$TRANSACTIONS6I appreciate suggestions to find the transaction. Thanks in advance!! Vanina
