public inbox for [email protected]  

help / color / mirror / Atom feed

Failing streaming replication on PostgreSQL 14
2+ messages / 2 participants
[nested] [flat]

* Failing streaming replication on PostgreSQL 14
@ 2024-04-15 06:52  Nicolas Seinlet <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nicolas Seinlet @ 2024-04-15 06:52 UTC (permalink / raw)
  To: [email protected] <[email protected]>

Hello everyone,

Since I moved some clusters from PostgreSQL 12 to 14, I noticed random failures in streaming replication. I say "random" mostly because I haven't got the source of the issue.

I'm using the Ubuntu/cyphered ZFS/PostgreSQL combination. I'm using Ubuntu LTS (20.04 22.04) and provided ZFS/PostgreSQL with LTS (PostgreSQL 12 on Ubuntu 20.04 and 14 on 22.04).

The streaming replication of PostgreSQL is configured with `primary_conninfo 'host=main_server port=5432 user=replicant password=a_very_secure_password sslmode=require application_name=replication_postgresql_app' ` , no replication slot nor restore command, and the wal is configured with `full_page_writes = off wal_init_zero = off wal_recycle = off`

If this works like a charm on PostgreSQL 12, it's sometimes failing with PostgreSQL 14. As we also changed the OS, maybe the issue relies somewhere else.

When the issue is detected, the WAL on the primary is correct. A piece of the WAL is wrong on the secondary. Only some bytes. Some bytes later, the wal is again correct. Stopping PostgreSQL on the secondary, removing the wrong WAL file, and restarting PostgreSQL solves the issue.

We've added another secondary and noticed the issue can appear on one of the secondaries, not both at the same time.

What can I do to detect the origin of this issue?

Have a nice week,

Nicolas.


Attachments:

  [application/pgp-signature] signature.asc (249B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Failing streaming replication on PostgreSQL 14
@ 2024-04-15 16:49  Alvaro Herrera <[email protected]>
  parent: Nicolas Seinlet <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2024-04-15 16:49 UTC (permalink / raw)
  To: Nicolas Seinlet <[email protected]>; +Cc: [email protected] <[email protected]>

On 2024-Apr-15, Nicolas Seinlet wrote:

> I'm using the Ubuntu/cyphered ZFS/PostgreSQL combination. I'm using
> Ubuntu LTS (20.04 22.04) and provided ZFS/PostgreSQL with LTS
> (PostgreSQL 12 on Ubuntu 20.04 and 14 on 22.04).

What exactly is "cyphered ZFS"?  Can you reproduce the problem with some
other filesystem?  If it's something very unusual, it might well be a
bug in the filesystem.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-04-15 16:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-15 06:52 Failing streaming replication on PostgreSQL 14 Nicolas Seinlet <[email protected]>
2024-04-15 16:49 ` Alvaro Herrera <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox