[Bucardo-general] 5.6 changes
Jeff Ross
rossj at cargotel.com
Fri May 22 22:08:54 UTC 2020
Hi all,
We're getting a lot of errors in syncs after upgrading to 5.6 in a
master <--> master setup. The left master is the dominant side,
supposedly the right side is not yet trying to insert/update back to the
left side.
From the logs it almost appears that we are getting both of these:
a) inserts/updates from left are applied to right, then right
tries to re-apply them back to left. This results in a pkey_conflict on
the left side.
b) sequences now appear to be replicated? This is a long shot but
before upgrading to 5.6 I had set left side sequences to increment by 2,
starting with odd and right side sequences to increment by 2 stating
with even. Now. left side gives even numbers for nextval(seq) and it
should not. I've tried to reset this multiple times with no
success--but it *had* been working prior to upgrade to 5.6.
Any ideas are most welcome!
Jeff
--
Jeff Ross
rossj at cargotel.com
--
The contents of this e-mail and any attachments are intended solely for the
use of the named addressee(s) and may contain confidential and/or
privileged information. Any unauthorized use, copying, disclosure, or
distribution of the contents of this e-mail is strictly prohibited by the
sender and may be unlawful. If you are not the intended recipient, please
notify the sender immediately and delete this e-mail.
More information about the Bucardo-general
mailing list