If gbak's transaction extends TIP, it fails when store new record into RDB$PAGES - due to incorrect check for modifications of system tables (introduced in FB3).

Test case

Prepare database. In isql run

create database 'gh-7031.fdb' page_size 4096;

set term ^;
execute block
  returns (tranum integer)
as
declare last integer;
declare TransPerTIP integer;
begin
  tranum = current_transaction;
  suspend;

  -- trans per tip, should return 16304
  select (mon$page_size - 20) * 4 from mon$database
    into :TransPerTIP;

  last = (tranum/TransPerTIP + 1) * TransPerTIP - 1;

  while (tranum < last) do
   begin
     in autonomous transaction do
       tranum = current_transaction;
  end

  suspend;
end
^
set term ;^

commit;
exit;

Run gbak in embedded mode : gbak -b -v gh-7031.fdb gh-7031.fbk
It will report

gbak:readied database gh-7031.fdb for backup
gbak:creating file gh-7031.fbk
gbak:starting transaction
gbak: ERROR:invalid transaction handle (expecting explicit transaction start)
gbak:Exiting before completion due to errors

Check firebird.log, it contains error message(s)

internal Firebird consistency check (page in use during flush (210), file: cch.cpp line: 2761)

Uh oh!

gbak -b failed with "invalid transaction handle (expecting explicit transaction start)" #7031

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions