Hi guys

Our system used to do a force users off and do a nightly backup/restore. Seems that when our IT moved to offsite continuous data warehousing, the backup/restore caused a significant increase in the data being warehoused and so they stopped doing it.
2^31 (0x7FFFFFFF) might be big but restoring a day old database from the warehouse showed transaction numbers only a 1000 or so below that.

A backup/restore fixed that and shrunk the database. will need to get it scheduled again, even if not nightly.

Why it caused the server memory problem is another issue.

Thanks for the advice.

--- In firebird-support@yahoogroups.com, Alexey Kovyazin <ak@...> wrote:
>
> Hello Michael,
>
> > Alexey Kovyazin schrieb am 21.05.2012 um 15:04 (+0400):
> > >
> > > You have hit transaction limit of Firebird.
> > > To prevent it, make backup/restore more often.
> >
> > What makes you think so?
> >
>
> I saw diagnostics log from IBFirstAID Diagnostician.
> :)
>
> >And why would that make the memory usage rise to nearly 100% ?
>
> This is another issue actually.
>
> >Also, the limit is 2**64, that's pretty high.
>
> No, limit is 2^31.
>
>
> Regards,
> Alexey Kovyazin
> IBSurgeon
>
>
>
> [Non-text portions of this message have been removed]
>