#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Posts
    25
    Rep Power
    0

    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?
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Lightbulb In firebird <3.0 is 2^31-1 , 3.0 2^64-1


    Originally Posted by srayner
    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.co...td4230210.html

    Trunk is the ongoing development branch (formerly known as HEAD in CVS),
    i.e. transaction IDs are already unsigned long in FB 3.0.
    Last edited by mariuz; March 12th, 2012 at 04:06 PM.
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    5
    @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.

IMN logo majestic logo threadwatch logo seochat tools logo