Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread Alexey Kovyazin
Hi, Oldest transaction 15230691 Oldest active 15230692 Oldest snapshot 15230692 Next transaction16644907 You have long-running active transaction. Use MON$ tables to identify who is holding it and stop. Regards, Alexey Kovyazin

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread marcus
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping?

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread Thomas Steinmaurer
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping? Yes. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check,

[firebird-support] Garbage collection / sweep not happening on super classic

2014-01-06 Thread rmcginty
Using 2.5.2 64 bit on Windows - Super Classic model. We have a large database around 20 gb that we have backup/restored successfully several times now via gbak. After the restore, everything is good, but over time, the transactions awaiting sweep starts to grow and never goes back to