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.
From: email@example.com [mailto:firstname.lastname@example.org]
On Behalf Of sopranoeli@...
Sent: Saturday, November 02, 2013 1:34 PM
Subject: [firebird-support] I dont know why sweep is not doing clean
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.
ODS Version 11.2
Page Size 8192
Size on Disk 18.35GB
SQL Dialect 3
Default Character Set NONE
Page Buffers 2048
Sweep Interval 20000
Forced Writes Reserve Space
Oldest transaction 709004
Oldest active transaction 1767830
Oldest snapshot 1767830
Next transaction 1767835