--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

>
> > --- In firebird-support@yahoogroups.com, "Alan McDonald"<alan@> wrote:
> >>
> >>>
> >>> Hi
> >>> i need to know if this limitation exists or not.
> >>> transaction enumeration in Firebird is max integer or unsigned integer?
> >>> and what happens when i reach 2^31=2147483648 transaction ID or if is
> >>> unsigned 2^32=4294967296 i read somewhere that in FB1.5 this corrupt
> >>> database - what about with 2.1.4 and new FB2.5, FB3.0?
> >>> Karol Bieniaszewski
> >>>
> >>
> >> In 32 bit positive range, at a rate of 1 transaction per 30 seconds average. That's 2,108 years between backup and restore cycles
> >>
> >> Alan
> >>
> >
> > Hi Alan,
> >
> > then you confirm that this limitation exists?
> > I yes i am in bad situation
> > because now i have ~18 000 000 transaction per day
> > this is ~200 transaction per second :/
> >
> > I see that i need to take off line my database after<4 month :/
> > This counter not restart self?
> > I really need to backup and restore cycle?
>
> This one here has been marked as fixed:
> http://tracker.firebirdsql.org/browse/CORE-2348
>
> Although I'm not sure what the fix exactly includes. Dmitry also
> mentions in the thread something about wrap und re-using numbers...
>
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>

I hope that indeed the problem was fixed.
I need to check yourself and see what happens ..

Karol Bieniaszewski