Increase transaction Id's artificially

[Eduardo Álvarez]

Hi there, I have a Firebird 2.5 database, I want to increase the transaction Id's to the max (2^32) so it's no longer possible to connect to the database. This for testing purposes.

Any hints on how can I do this artificially, i.e., by running some isql command(s) in a batch loop. Or, I could also write a small C# program to try this, just need some pointers on what command or sentence to run please.

Thanks for any insight.

-Ed

[Dimitry Sibiryakov]

Eduardo Álvarez wrote 08.11.2021 20:05:
> Any hints on how can I do this artificially, i.e., by running some isql
> command(s) in a batch loop.

execute block as
declare i integer = 0;
begin
while (i < 4000000000) do
begin
in autonomous transaction do something;
i = i+1;
end;
end;

--
WBR, SD.

[Eduardo Álvarez]

Than you very much, it worked nicely.

-Ed