The sweep is not working because there is still an active (uncommitted) transaction, which an application/connection hasn’t committed/closed.
You can use the MON$Attachments and MON$Transactions tables to try to identify the source. Sean From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, November 02, 2013 1:34 PM To: [email protected] Subject: [firebird-support] I dont know why sweep is not doing clean Hi, Thank you for your help. I dont understand why sweep is not doing clean. I use Super Server 2.5. I try also to run sweep manually and it ends immediatelly without doing clean. Database info ODS Version 11.2 Page Size 8192 Pages 2405824 Size on Disk 18.35GB SQL Dialect 3 Default Character Set NONE Settings Page Buffers 2048 Sweep Interval 20000 Forced Writes Reserve Space Read-Only False Transaction info Oldest transaction 709004 Oldest active transaction 1767830 Oldest snapshot 1767830 Next transaction 1767835 TIA Vanina
