firebird icon indicating copy to clipboard operation
firebird copied to clipboard
verified publisher icon FirebirdSQL

Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert

Open hvlad opened this issue 1 year ago • 1 comments

The conditions:

  • replica database contains a table with Primary Key and at least one Unique Key
  • the record is being inserted and violates UK (not PK!)
  • the correct error is put into replication.log:
    ERROR: attempt to store duplicate value (visible to active transactions) in unique index <UK name>
    Problematic key value is (...)
  • after replication paused and resumed the same segment is applied again
  • bugcheck happens: ERROR: internal Firebird consistency check (wrong record length (183), file: vio.cpp line: 1450)

hvlad avatar Mar 12 '24 18:03 hvlad

Also, Firebird can't be stopped after such bugcheck happens

hvlad avatar Mar 12 '24 19:03 hvlad

QA note. Test name: functional/replication/test_bugcheck_in_rw_replica_after_conflicting_insert.py

pavel-zotov avatar Apr 12 '24 09:04 pavel-zotov