tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

Firebird database with more than 2^32 transactions

1 May 2020 1 mins Firebird

Firebird 3 added support for transaction ID to go over, originally, 231 and later 232, all the way up to the 248. Although a great improvement it might become a problem if the client library can’t properly handle that in a few places where these numbers are surfaced.

Because I needed to try this with FirebirdClient too, I needed such database. There isn’t much room for shortcuts (to be really sure it’s a valid database), rather the machine needs to do the work. It took a while to get over 232, which I suppose would be limit most people are interested in. The database I’m providing here (and also archiving it for me in case I need to revisit some code 😃) has Next transaction at 7_595_278_038 aka 3_300_310_742 over the 232. It’s not a backup of database, but the database file itself, simply because doing backup & restore resets the transaction counter.

Hope it speeds up some of your testing.

Profile Picture Jiří Činčura is an independent developer focusing on data and business layers, language constructs, parallelism and databases. Specifically Entity Framework, asynchronous and parallel programming, cloud and Azure. He's Microsoft Most Valuable Professional and you can read his articles, guides, tips and tricks at