Hi Dimitry,
unfortunately, this is not that case.
It seems this happen when we read data from an another database and
insert/update into the master one.
This is an execute block running for execute statement on external and the
target table has the trigger which increases the generator
Both generators are used this way only at after insert/update triggers on
different tables.
Maybe tomorrow whe could figure out what is wrong and can make a simple test
case.
UUID is not playing for us, to much table and business logic code to refactor
it.
András
-----Original Message-----
From: Dimitry Sibiryakov [mailto:[email protected]]
Sent: Tuesday, May 18, 2021 4:00 PM
To: For discussion among Firebird Developers
<[email protected]>
Subject: Re: [Firebird-devel] Replication - generators' value are not replicated
18.05.2021 14:45, Omacht András wrote:
> We have very complex and long running tests.
> We ran the simpliest, which creates hundreds of domains, tables, stored
> procedures, views, triggers and inserting thousands data into tables.
> Almost everything is ok with replication, we only have two generators that
> end in different values in the replicas (they are different from the master,
> they remain in the original state in the replicas).
I can foresee only one case when it is possible: generators are increased in
one connection and received values used in another.
PS: I suggest to use UUIDs for primary keys instead of generators.
--
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
