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 = 2
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, this is a known bug:
http://tracker.firebirdsql.org/browse/CORE-3978--
Does this also apply to the output via the Trace API?
Thanks!
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
* Your email settings:
Individual Email | Traditional
* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
* To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
* Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/