Thanks Dimitry for the super fast response. Yes you were correct the paths
were incorrect. I have corrected this and no longer get the error
message. Its still not replicating though.
Here's my new config
database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB
{
log_directory = D:\Apps\FB4\FB4Test\chlog
log_archive_directory = D:\Apps\FB4\FB4Test\archlog
log_archive_timeout = 10
verbose_logging = true
}
database = D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB
{
log_source_directory = D:\Apps\FB4\incominglogs
verbose_logging = true
}
Still no replication.log
I am now getting journal files. But no records are being replicated
archlog
FB4TEST.FDB.chlog-000000001
FB4TEST.FDB.chlog-000000002
chlog
FB4TEST.FDB.chlog-000000002
Regards
Peter
On Tue, 23 Feb 2021 at 06:49, Dmitry Yemanov <firebi...@yandex.ru> wrote:
> 23.02.2021 09:31, Peter Gore wrote:
>
> > As a test I have tried to get asynchronous replication working. Is this
> > even possible when Master and Replica is on the same Server?
>
> Sure. Even using a single FB instance for both.
>
> > I have two
> > databases; FB4Test.fdb and FB4TestReplica.fdb o the same (localhost)
> > server. The replica I created by copying theFB4Test.FDB whilst the
> > server was not running.
> >
> > I followed the release notes and changed the replication.conf as follows
> >
> > database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB
> > {
> > log_directory = /FB4Test/chlog
> > log_archive_directory = /FB4Test/archlog
>
> UNIX paths??? Your server is obviously on Windows, so it cannot work.
> I'd rather expect something like:
>
> log_directory = D:\Users\Peter\Documents\FB4Test\chlog
> log_archive_directory = D:\Users\Peter\Documents\FB4Test\archlog
>
> > database = D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB
> > {
> > log_source_directory = /incominglogs/
>
> Same here.
>
> > I also ran all the necessary DDL statements and run GFIX as prescribed
> >
> > *GFIX - Doc anomaly 2*
> > Release Notes
> > I found empirically that
> > Page 28
> > gfix -replica read-only <database>
> > should be
> > gfix -replica read_only <database>
> > Also page 137
> > gfix -replica read-only <database>
> > should be
> > gfix -replica read_only <database>
> > Probably references to read-write should be read_write but haven't tried
> > this.
>
> Noted to be fixed, thanks.
>
> > *GFIX - Returned error*
> > gfix -replica read_only
> D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB
> > Unable to perform operation
> > -System privilege USE_GFIX_UTILITY is missing
>
> You missed the -user switch, and the user must be DBA/owner.
>
> > When I modify data in the Master database the following error appears in
> > the Firebird.log
> >
> > TOSHPJGTue Feb 23 06:02:15 2021
> > Operating system call FindFirstFile failed. Error code 3
>
> I will improve the error reporting to be more user-friendly. This errors
> means non-existing "/FB4Test/chlog" directory.
>
>
> Dmitry
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
