|Subject||Re: [firebird-support] Long running transactions|
> Database header page information:Yes.
> Flags 0
> Checksum 12345
> Generation 398712
> Page size 16384
> ODS version 11.0
> Oldest transaction 330499
> Oldest active 330500
> Oldest snapshot 330498
> Next transaction 398706
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jun 9, 2008 11:09:24
> Variable header data:
> Sweep interval: 20000
> Given the above information, I have some questions:
> - The transaction number 330500 is still active and keeping the sweep
> from running?
> - Since the interval is much bigger than 20000 and counting, whatThe automatic sweep will run when OAT-OIT > 20000 which is not the case
> happens to the automatic sweep? Is it triggered every time the Next
> transaction is raised?
according to your statistics.
> - Is there always at least one active transaction per connected userI will leave that to others. I think it depends a bit on the toolset you
> or users can be connected without any active transactions?
Btw, you are running your database with FORCED WRITES = OFF.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and