> --- 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!