11.02.2014 16:49, Juan Pedro Lopez Saez wrote:
>
> 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, this is a known bug:
http://tracker.firebirdsql.org/browse/CORE-3978


Dmitry





------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo Groups is subject to:
    http://info.yahoo.com/legal/us/yahoo/utos/terms/

Reply via email to