Re: [Firebird-devel] Firebird 4 replication
http://tracker.firebirdsql.org/browse/CORE-6497 Thanks On Wed, Feb 24, 2021 at 12:36 PM Dmitry Yemanov wrote: > 24.02.2021 18:14, Lucas Schatz wrote: > > > Can someone reproduce it too? If yes, I'll open a report > > I can, thanks. Please post to the tracker. > > > 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
Re: [Firebird-devel] Firebird 4 replication
24.02.2021 18:14, Lucas Schatz wrote: Can someone reproduce it too? If yes, I'll open a report I can, thanks. Please post to the tracker. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4 replication
Can someone reproduce it too? If yes, I'll open a report
Environment: Centos 8 64bits, SELinux disabled fresh install
replication.conf:
database = /db/primary.fdb
{
sync_replica = SYSDBA:***@localhost:/db/replica.fdb
}
// My script for testin
systemctl stop firebird
mkdir /db
chown firebird. /db
rm /db/primary.fdb /db/replica.fdb -f
systemctl start firebird
echo "create database 'localhost:/db/primary.fdb';ALTER DATABASE ENABLE
PUBLICATION; ALTER DATABASE INCLUDE ALL TO PUBLICATION;quit;" |
/opt/firebird/bin/isql
systemctl stop firebird
cp -a primary.fdb replica.fdb
gfix -replica read_write /db/replica.fdb
systemctl start firebird
echo "show table;quit;" | /opt/firebird/bin/isql localhost:/db/primary.fdb
echo "show table;quit;" | /opt/firebird/bin/isql localhost:/db/replica.fdb
echo "create table tb1 (a integer not null, constraint tb1_pk primary key
(a));commit;quit;" | /opt/firebird/bin/isql localhost:/db/primary.fdb
pkill -9 firebird; pkill -9 isql
//Table created at both databases
echo "show table;quit;" | /opt/firebird/bin/isql localhost:/db/primary.fdb
echo "show table;quit;" | /opt/firebird/bin/isql localhost:/db/replica.fdb
Thanks
On Wed, Feb 24, 2021 at 10:05 AM Dmitry Yemanov wrote:
> 24.02.2021 15:55, Lucas Schatz wrote:
> >
> > Hi, I was experiencing this hanging here too, when using local
> > synchronous replication the server hangs during the disconnection, maybe
> > open a bug report?
>
> If you have a reproducible scenario - sure, feel free.
>
>
> 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
Re: [Firebird-devel] Firebird 4 replication
24.02.2021 15:55, Lucas Schatz wrote: Hi, I was experiencing this hanging here too, when using local synchronous replication the server hangs during the disconnection, maybe open a bug report? If you have a reproducible scenario - sure, feel free. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4 replication
On Wed, Feb 24, 2021 at 8:15 AM Martin Wong wrote:
> Yes I missed applying these:
> ALTER DATABASE ENABLE PUBLICATION;
>
> After applying it, replication done correctly and the replica database
> updated directly, but now firebird hangs after master database
> disconnected, but that did not happen when using flamerobin, so I will
> check my firebird client library first.
>
> Hi, I was experiencing this hanging here too, when using local synchronous
replication the server hangs during the disconnection, maybe open a bug
report?
Thanks for your reply.
>
> On Wed, 24 Feb 2021 at 16:22, Dmitry Yemanov wrote:
>
>> 24.02.2021 11:13, Martin Wong wrote:
>> >
>> > I am trying to test the new Firebird 4 synchronous replication on
>> > windows 7 64bit machine with the following configurations:
>> >
>> > #databases.conf
>> > master = d:\fb4\master.fdb
>> > replica = d:\fb4\replica.fdb
>> >
>> > #replication.conf
>> > database = master
>> > {
>> > sync_replica = sysdba:masterkey@localhost:replica
>> >
>> > log_directory = d:\fb4\log\
>>
>> This line is not needed to synchronous replication.
>>
>> IIRC, we already discussed to replace "log" with "journal" (or
>> "changelog" or whatever) in these configuration settings. Currently it's
>> confusing whether we speak about replication segment files or
>> replication.log file.
>>
>> > log_errors = true
>> > verbose_logging = true
>> > }
>> >
>> > I create a new database from script,(master.fdb) and then shutdown
>> > firebird server, copy the database to the new file name (replica.fdb)
>> > and mark the it as replica database via gfix like this:
>> >
>> > C:\Program Files\Firebird\Firebird_4_0>gfix -replica read_write
>> > d:\fb4\replica.fdb -user sysdba -pass masterkey
>> >
>> > And after starting the firebird server again and connecting and writing
>> > to the master database, nothing changed on the replica database, and
>> > also the replication.log wasn't created in the log path ( d:\fb4\log\ ).
>>
>> replication.log is located in the same directory as firebird.log.
>>
>> > After that I tried to monitor the firebird server via Sysinternals
>> > Process Monitor, and found that the firebird server accessed the master
>> > database file and the replication,conf file, but never accessed or
>> > connected to the replica database file or the replication.log.
>>
>> Did you run:
>>
>> ALTER DATABASE INCLUDE ALL TO PUBLICATION;
>> ALTER DATABASE ENABLE PUBLICATION;
>>
>> ?
>>
>>
>> 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
>
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4 replication
Yes I missed applying these:
ALTER DATABASE ENABLE PUBLICATION;
After applying it, replication done correctly and the replica database
updated directly, but now firebird hangs after master database
disconnected, but that did not happen when using flamerobin, so I will
check my firebird client library first.
Thanks for your reply.
On Wed, 24 Feb 2021 at 16:22, Dmitry Yemanov wrote:
> 24.02.2021 11:13, Martin Wong wrote:
> >
> > I am trying to test the new Firebird 4 synchronous replication on
> > windows 7 64bit machine with the following configurations:
> >
> > #databases.conf
> > master = d:\fb4\master.fdb
> > replica = d:\fb4\replica.fdb
> >
> > #replication.conf
> > database = master
> > {
> > sync_replica = sysdba:masterkey@localhost:replica
> >
> > log_directory = d:\fb4\log\
>
> This line is not needed to synchronous replication.
>
> IIRC, we already discussed to replace "log" with "journal" (or
> "changelog" or whatever) in these configuration settings. Currently it's
> confusing whether we speak about replication segment files or
> replication.log file.
>
> > log_errors = true
> > verbose_logging = true
> > }
> >
> > I create a new database from script,(master.fdb) and then shutdown
> > firebird server, copy the database to the new file name (replica.fdb)
> > and mark the it as replica database via gfix like this:
> >
> > C:\Program Files\Firebird\Firebird_4_0>gfix -replica read_write
> > d:\fb4\replica.fdb -user sysdba -pass masterkey
> >
> > And after starting the firebird server again and connecting and writing
> > to the master database, nothing changed on the replica database, and
> > also the replication.log wasn't created in the log path ( d:\fb4\log\ ).
>
> replication.log is located in the same directory as firebird.log.
>
> > After that I tried to monitor the firebird server via Sysinternals
> > Process Monitor, and found that the firebird server accessed the master
> > database file and the replication,conf file, but never accessed or
> > connected to the replica database file or the replication.log.
>
> Did you run:
>
> ALTER DATABASE INCLUDE ALL TO PUBLICATION;
> ALTER DATABASE ENABLE PUBLICATION;
>
> ?
>
>
> 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
Re: [Firebird-devel] Firebird 4 replication
24.02.2021 11:13, Martin Wong wrote:
I am trying to test the new Firebird 4 synchronous replication on
windows 7 64bit machine with the following configurations:
#databases.conf
master = d:\fb4\master.fdb
replica = d:\fb4\replica.fdb
#replication.conf
database = master
{
sync_replica = sysdba:masterkey@localhost:replica
log_directory = d:\fb4\log\
This line is not needed to synchronous replication.
IIRC, we already discussed to replace "log" with "journal" (or
"changelog" or whatever) in these configuration settings. Currently it's
confusing whether we speak about replication segment files or
replication.log file.
log_errors = true
verbose_logging = true
}
I create a new database from script,(master.fdb) and then shutdown
firebird server, copy the database to the new file name (replica.fdb)
and mark the it as replica database via gfix like this:
C:\Program Files\Firebird\Firebird_4_0>gfix -replica read_write
d:\fb4\replica.fdb -user sysdba -pass masterkey
And after starting the firebird server again and connecting and writing
to the master database, nothing changed on the replica database, and
also the replication.log wasn't created in the log path ( d:\fb4\log\ ).
replication.log is located in the same directory as firebird.log.
After that I tried to monitor the firebird server via Sysinternals
Process Monitor, and found that the firebird server accessed the master
database file and the replication,conf file, but never accessed or
connected to the replica database file or the replication.log.
Did you run:
ALTER DATABASE INCLUDE ALL TO PUBLICATION;
ALTER DATABASE ENABLE PUBLICATION;
?
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4, replication of BLOBS
06.08.2020 18:12, Dimitry Sibiryakov wrote: Is it ok that replication merge all BLOB segments into one and cannot work with BLOBs larger than 4G? Not really. This is a limitation of the original implementation and apparently nobody stepped on it yet ;-) Worth improving for sure. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
