How high can the next transaction id go?

How high can the next transaction id go?

My database increases the next trasaction id by about 1million each working day. The database crashes after about three weeks and we have to backup/restore to recover it.

(see previous thread)

I'm just interested in how high the next transaction id can go before it reaches its limit. Then what happens, does it restart at zero?

In firebird <3.0 is max is 2^31-1 ,
in 3.0 max is 2^64-1 = 4294967295
See this thread for a discussion
http://firebird.1100200.n4.nabble.c...-td4230210.html

@srayner: With your load, this means 21 mio transactions in three weeks, which doesn't overflow the mentioned transaction id limit. According to your previous thread, you simply have a problem in your client transaction management code. Possibly:

* Some kind of auto commit mode using CommitRetaining behind the scene etc. without doing a hard commit from time to time
* Using Read_Write transactions when you also can use Read_Only transactions

etc.

Deeper analysis is sometimes hard in public forums, so if you are interesting in getting support/services on a commercial base, let me know.