Subject RE: [firebird-support] I dont know why sweep is not doing clean
Author Leyne, Sean

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: [] 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.

Database info
ODS Version 11.2
Page Size 8192
Pages 2405824
Size on Disk 18.35GB
SQL Dialect 3
Default Character Set NONE
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