RE: [firebird-support] Transaction ID overflow
Thanks Mark. From: firebird-support@yahoogroups.com Sent: Tuesday, 1 May 2018 5:34 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Transaction ID overflow On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telstra.com<mailto:brian.duns...@health.telstra.com> [firebird-support] wrote: > Hi, > > We have a big customer here who processes large numbers of transactions into > a large database and plans to not backup and restore. They should plan for backups and tests restores. But if you reach the transaction limit, then there is really no choice but to backup and restore. > We are using Dialect 3. I think that means that the TID is 32 bits. I think > that means they get 4,294,967,296 transactions before overflow - I'm assuming > the TID is an unsigned integer. Is that correct? In Firebird 2.5 and earlier the transaction id is 32 bit. If I'm not mistaken, it is signed (so effectively 31 bits) with a maximum transaction id of 2^31 - 1. > If we move to dialect 3, does the TID become 64 bits? I assume you mean Firebird 3. In Firebird 3 the transaction id is 48 bits (unsiged), the maximum transaction id is 2^48. -- Mark Rotteveel
Re: [firebird-support] Transaction ID overflow
On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telstra.com [firebird-support] wrote: > Hi, > > We have a big customer here who processes large numbers of transactions into > a large database and plans to not backup and restore. They should plan for backups and tests restores. But if you reach the transaction limit, then there is really no choice but to backup and restore. > We are using Dialect 3. I think that means that the TID is 32 bits. I think > that means they get 4,294,967,296 transactions before overflow - I'm assuming > the TID is an unsigned integer. Is that correct? In Firebird 2.5 and earlier the transaction id is 32 bit. If I'm not mistaken, it is signed (so effectively 31 bits) with a maximum transaction id of 2^31 - 1. > If we move to dialect 3, does the TID become 64 bits? I assume you mean Firebird 3. In Firebird 3 the transaction id is 48 bits (unsiged), the maximum transaction id is 2^48. -- Mark Rotteveel
Re: [firebird-support] Transaction ID overflow
01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com [firebird-support] wrote: > If we move to dialect 3, does the TID become 64 bits? It is 48 bits in Firebird 3. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/