On Thu, Jul 21, 2011 at 10:10 PM, technisoft2005 <
preber@...> wrote:

>
>
> --- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...>
> wrote:
> >
> > The "tip" page is the Transaction Inventory Page - the place where
> > transaction state is maintained. There are several possible causes of
> > "cannot find tip page". One is that there have been more than 2**32
> > transactions since the database was created, but that should cause the
> > backup to fail as well.
>
> That is a scary situation. Does this mean that the database could run into
> this problem under normal operating conditions and would then be
> unrecoverable because backing up would be impossible?
>
> How does one recover from this situation?
>

Set the database to be read only and do a backup/restore. But it would take
many years under normal load to reach that threshold. At the time the limit
was created, it appeared to be "retirement proof" - unless my math is off,
it's about 10 transactions per second for 13.6 years.

Good luck,

Ann


[Non-text portions of this message have been removed]