FireBird 4.0.1 Replication

[Omar Zelaya]

Hi,

 I have setup my DB  for Asynchronous replication. I have found that the journal_archive_directory(Master) contains thousands of journal files. Is this normal? isn't supposed that FB will delete them when no longer needed.

 Any hint?

 Thanks in advance

Omar Zelaya

[Сергей Волков]

Hi.

Master does not delete files in journal_archive_directory. Your command/script should delete files after successful copying to journal_source_directory on Slave.

пт, 26 авг. 2022 г. в 22:56, Omar Zelaya <mayoz...@gmail.com>:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/450befaa-56b2-4f4b-a164-8cf10e672755n%40googlegroups.com.

[Omar Zelaya]

Hi,

Any hint how to implement command/script?

Thanks in advance,

Omar Zelaya

[Omar Zelaya]

Hi,

If I understand corectly, Firebird should delete de segements that are nor more requiered.

thanks in advance,

Omar Zelaya

"About the LSS and OSS

LSS refers to the last replicated segment. OSS refers to the segment that started the earliest transaction that was incomplete at the time LSS was processed.

These markers control two things:

1. what segment must be replicated next and

2. when segment files can be safely deleted

Segments with numbers between the OSS and the LSS are preserved in case the journal needs replaying after the replicator disconnects from the replica database; for example, due to a replication error or an idle timeout.

If there are no active transactions pending and the LSS was processed without errors, all segments up to and including the LSS are deleted.

If a critical error occurs, replication is temporarily suspended and will be retried after the timeout."

[Dimitry Sibiryakov]

Omar Zelaya wrote 27.08.2022 22:48:
> If I understand corectly, Firebird should delete de segements that are nor more
> requiered.

Yes, but this happens on target side only. Source side has no way to know
when segments are not required.

--
WBR, SD.