| Subject | RE: [firebird-support] I dont know why sweep is not doing clean |
|---|---|
| Author | Leyne, Sean |
| Post date | 2013-11-02T17:41:19Z |
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: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
On Behalf Of sopranoeli@...
Sent: Saturday, November 02, 2013 1:34 PM
To: firebird-support@yahoogroups.com
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