Just one more info.
After this if I do
insert into TMP_TABLE (VC) values ('C');
commit;
the generator value is ok again. Both in master and replica has 3.
It looks like when I do update and commit then the generator's value is not
syncronized.
András
-----Original Message-----
From: Omacht András [mailto:omacht.and...@libra.hu]
Sent: Tuesday, May 18, 2021 1:36 PM
To: For discussion among Firebird Developers
<firebird-devel@lists.sourceforge.net>
Subject: Re: [Firebird-devel] Replication - generators' value are not replicated
Ok, let's see the following example:
Master:
CREATE SEQUENCE TMP_GEN_2;
commit;
CREATE TABLE TMP_TABLE (
VC VARCHAR(10)
);
commit;
CREATE OR ALTER TRIGGER TMP_TABLE_BIU0 FOR TMP_TABLE ACTIVE BEFORE INSERT OR
UPDATE POSITION 0 as declare variable dummy integer; begin
dummy = gen_id(tmp_gen_2, 1);
end
commit;
insert into TMP_TABLE (VC) values ('A'); commit;
-- At this point in master and replica's generator has the same value: 1
update tmp_table set vc = 'B';
commit;
-- At this point master's generator value is 2, but the replica's generator
value is 1.
The last update is a commited DML...
CÉGÜNK A LIBRA CSOPORT TAGJA
OMACHT ANDRÁS
fejlesztési igazgató
LIBRA Szoftver Zrt.
1113 Budapest, Karolina út 65.
+36 (1) 255-3939
i...@libra.hu | www.libra.hu
-----Original Message-----
From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com]
Sent: Tuesday, May 18, 2021 1:23 PM
To: For discussion among Firebird Developers
<firebird-devel@lists.sourceforge.net>
Subject: Re: [Firebird-devel] Replication - generators' value are not replicated
18.05.2021 13:20, Omacht András wrote:
> I commited, as shown in my example.
Transaction also must contain some DML. Without it replication of generator
is pointless.
--
WBR, SD.
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
