public inbox for [email protected]
help / color / mirror / Atom feedFrom: Philip Warner <[email protected]>
To: Pg Hackers <[email protected]>
Subject: Logical replication failure modes
Date: Fri, 29 Mar 2024 22:43:26 +1100
Message-ID: <[email protected]> (raw)
I am trying to discover the causes of occasional data loss in logical
replication; it is VERY rare and happens every few week/months.
Our setup is a source DB running in docker on AWS cloud server. The
source database is stored in on local disks on the cloud server.
The replication target is a K8 POD running in an AWS instance with an
attached persistent AWS disk. The disk mounting is managed by K8.
Periodically this POD is deleted and restarted in an orderly way, and
the persistent disk stores the database.
What we are seeing is *very* occasional records not being replicated in
the more active tables.
Sometimes we have a backlog of several GB of data due to missing fields
in the target or network outages etc.
I am also seeing signs that some triggers are not being applied (at the
same time frame): ie. data *is* inserted but triggers that summarize
that data is not summarizing some rows and the dates on those
non-summarized rows corresponds to dates on unrelated missing rows in
other tables.
This all leads me to conclude that there might be missing transactions?
Or non-applied transactions etc. But it is further complicated by the
fact that there is a second target database that *does* have all the
missing records.
Any insights or avenues of exploration would be very welcome!
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Logical replication failure modes
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox