Subject RE: [firebird-support] Two transactions can have the same TID?
Author Leyne, Sean

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Sunday, September 08, 2013 3:55 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Two transactions can have the same TID?

 

With recent FB version*, the engine will stop processing new transactions to prevent you from exceeding the Integer limit -- you will be required to back/restore the database.

 

<SL> I have confirmed that this change was made in v2.5.0+

 

Sean

 

* If you are not sure your version supports this check the most recent release notes for you version (i.e. v.2.1.x check the 2.1.5 release notes – they are inclusive for the all previous version updates).

 

** If this feature is NOT MENTIONED, then you need to pro-actively manage the database TID’s, otherwise you will experience database corruption!!!

 

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of W O
Sent: Sunday, September 08, 2013 3:32 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Two transactions can have the same TID?

 



Hello everybody

 

The TID (Transaction Identificator) is of type INTEGER, so when the last TID is 2.147.483.647 the next TID will be 1, right?

 

But, what happens if there was a transaction with the number 1?

 

The two transactions will have the same number?

 

Greetings.

 

Walter.