Subject | [firebird-support] Transaction statistics issue |
---|---|
Author | Paul Beach |
Post date | 2014-02-11T13:08:08Z |
<<I found a strange issue when sweep is executed.
I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits.
I first execute "SHOW DATABASE" in isql:
PAGE_SIZE 16384
Number of DB pages allocated = 524480
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 26483174
Transaction - oldest active = 26483175
Transaction - oldest snapshot = 26483171
Transaction - Next = 26483367
Shortly after, I do a manual sweep to the same database. This lines
appear in firebird.log:
Sweep is started by SYSDBA
Database "path_to_databse.fdb"
OIT 26489872, OAT 26489873, OST 26489873, Next 140660205433875
As you can see, it seems to be a huge gap between next transaction and
the other values.
I guess that is not true, as just some minutes went on from measured
points.
Is it a normal behaviour?>>
No its a bug
http://tracker.firebirdsql.org/browse/CORE-3978
Regards
Paul
I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits.
I first execute "SHOW DATABASE" in isql:
PAGE_SIZE 16384
Number of DB pages allocated = 524480
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 26483174
Transaction - oldest active = 26483175
Transaction - oldest snapshot = 26483171
Transaction - Next = 26483367
Shortly after, I do a manual sweep to the same database. This lines
appear in firebird.log:
Sweep is started by SYSDBA
Database "path_to_databse.fdb"
OIT 26489872, OAT 26489873, OST 26489873, Next 140660205433875
As you can see, it seems to be a huge gap between next transaction and
the other values.
I guess that is not true, as just some minutes went on from measured
points.
Is it a normal behaviour?>>
No its a bug
http://tracker.firebirdsql.org/browse/CORE-3978
Regards
Paul