Replication Error - 5.0.1

[slalom91]

We are encountering the following error on the replica side:

ERROR: cannot update old BLOB At segment 14297, offset 48

This error is not recoverable. There is no way to purge the transaction file which contains this error to allow for replication to continue.

Please advise what further details are required to troubleshoot and correct this issue.

[dyemanov]

Could you please answer whether any of the replicated tables contain multiple blob fields? And if so, is it possible that those multiple blob columns may share the same blob contents for some record(s) (e.g. col1 = :my_blob, col2 = :my_blob)?

[slalom91]

Hi Dmitry,

Yes, there are dozens of tables and several dozens of Blobs. Although I can’t say for sure, it is certainly architecturally possible that some blob contents could be the same.

/PD

From: Dmitry Yemanov @.> Sent: Tuesday, December 10, 2024 12:51 AM To: FirebirdSQL/firebird @.> Cc: Phillip M. Day @.>; Author @.> Subject: Re: [FirebirdSQL/firebird] Replication Error - 5.0.1 (Issue #8317)

Could you please answer whether any of the replicated tables contain multiple blob fields? And if so, is it possible that those multiple blob columns may share the same blob contents for some record(s) (e.g. col1 = :my_blob, col2 = :my_blob)?

— Reply to this email directly, view it on GitHubhttps://github.com/FirebirdSQL/firebird/issues/8317#issuecomment-2530589080, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BM44DA7CLS4YRIQFMU5XZ4L2E2FO3AVCNFSM6AAAAABRWK5K7WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKMZQGU4DSMBYGA. You are receiving this because you authored the thread.Message ID: @.@.>>

[hvlad]

This has been fixed by #8350, most likely