Hi,

I've got this error after patching standby host from PG 17.6 TO PG 17.7

2026-02-22 09:05:36.709 CET [8434]: [3-1] user=,db=,client=,application=
LOG:  starting PostgreSQL 17.7 on x86_64-pc-linux-gnu, compiled by gcc
(GCC) 11.5.0 20240719 (Red Hat 11.5.0-11), 64-bit
2026-02-22 09:05:36.709 CET [8434]: [4-1] user=,db=,client=,application=
LOG:  listening on IPv4 address "0.0.0.0", port 5432
2026-02-22 09:05:36.709 CET [8434]: [5-1] user=,db=,client=,application=
LOG:  listening on IPv6 address "::", port 5432
2026-02-22 09:05:36.710 CET [8434]: [6-1] user=,db=,client=,application=
LOG:  listening on Unix socket "/run/postgresql/.s.PGSQL.5432"
2026-02-22 09:05:36.711 CET [8434]: [7-1] user=,db=,client=,application=
LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2026-02-22 09:05:36.774 CET [8822]: [1-1] user=,db=,client=,application=
LOG:  database system was shut down in recovery at 2026-02-22 08:58:19 CET
2026-02-22 09:05:36.964 CET [8980]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is starting up
2026-02-22 09:05:36.973 CET [8994]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is starting up
ERROR: The required file is not available: 00000007.history
2026-02-22 09:05:37.836 CET [8822]: [2-1] user=,db=,client=,application=
LOG:  restored log file "00000006.history" from archive
2026-02-22 09:05:37.937 CET [10128]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is starting up
2026-02-22 09:05:37.941 CET [10132]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is starting up
2026-02-22 09:05:38.001 CET [10198]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is starting up
2026-02-22 09:05:38.471 CET [8822]: [3-1] user=,db=,client=,application=
LOG:  restored log file "00000006000017B300000090" from archive
2026-02-22 09:05:38.472 CET [8822]: [4-1] user=,db=,client=,application=
LOG:  entering standby mode
2026-02-22 09:05:38.525 CET [8822]: [5-1] user=,db=,client=,application=
LOG:  recovered replication state of node 1 to 17B3/90DC1090
2026-02-22 09:05:38.525 CET [8822]: [6-1] user=,db=,client=,application=
LOG:  recovered replication state of node 2 to 17A9/5BA47610
2026-02-22 09:05:38.525 CET [8822]: [7-1] user=,db=,client=,application=
LOG:  recovered replication state of node 3 to 17A9/16C225F8
2026-02-22 09:05:39.060 CET [10797]: [1-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] FATAL:  the
database system is not yet accepting connections
2026-02-22 09:05:39.060 CET [10797]: [2-1]
user=patroni,db=postgres,client=127.0.0.1,application=[unknown] DETAIL:
 Consistent recovery state has not been yet reached.
2026-02-22 09:05:39.145 CET [8822]: [8-1] user=,db=,client=,application=
LOG:  restored log file "00000006000017B30000008F" from archive
2026-02-22 09:05:39.145 CET [8822]: [9-1] user=,db=,client=,application=
LOG:  redo starts at 17B3/8F4425C0
2026-02-22 09:05:39.743 CET [8822]: [10-1] user=,db=,client=,application=
LOG:  restored log file "00000006000017B300000090" from archive
2026-02-22 09:05:39.888 CET [8822]: [11-1] user=,db=,client=,application=
LOG:  consistent recovery state reached at 17B3/90DD1200
2026-02-22 09:05:39.888 CET [8434]: [8-1] user=,db=,client=,application=
LOG:  database system is ready to accept read-only connections
ERROR: The required file is not available: 00000006000017B300000091
2026-02-22 09:05:40.216 CET [8822]: [12-1] user=,db=,client=,application=
LOG:  unexpected pageaddr 17AF/1000000 in WAL segment
00000006000017B300000091, LSN 17B3/91000000, offset 0
2026-02-22 09:05:40.769 CET [8822]: [13-1] user=,db=,client=,application=
LOG:  restored log file "00000006000017B300000090" from archive
ERROR: The required file is not available: 00000006000017B300000091
2026-02-22 09:05:41.072 CET [8822]: [14-1] user=,db=,client=,application=
LOG:  unexpected pageaddr 17AF/1000000 in WAL segment
00000006000017B300000091, LSN 17B3/91000000, offset 0
2026-02-22 09:05:41.125 CET [11692]: [1-1] user=,db=,client=,application=
LOG:  started streaming WAL from primary at 17B3/91000000 on timeline 6
2026-02-22 09:06:46.164 CET [11692]: [2-1] user=,db=,client=,application=
FATAL:  could not receive data from WAL stream: server closed the
connection unexpectedly
                This probably means the server terminated abnormally
                before or while processing the request.
        server closed the connection unexpectedly
                This probably means the server terminated abnormally
                before or while processing the request.
ERROR: The required file is not available: 00000007.history
ERROR: The required file is not available: 00000006000017B300000091
2026-02-22 09:06:46.779 CET [8822]: [15-1] user=,db=,client=,application=
LOG:  record with incorrect prev-link 4352416E/6F697470 at 17B3/9159B0A8
2026-02-22 09:06:46.810 CET [12251]: [1-1] user=,db=,client=,application=
LOG:  started streaming WAL from primary at 17B3/91000000 on timeline 6

barman@sbarmanhost:/tmp [11:11:01]$ /usr/pgsql-17/bin/pg_waldump
00000006000017B300000091 | grep -E "9159B0A8"
rmgr: Heap        len (rec/tot):     54/    54, tx:  818991942, lsn:
17B3/9159B0A8, prev 17B3/9159B078, desc: LOCK xmax: 818991942, off: 110,
infobits: [LOCK_ONLY, EXCL_LOCK], flags: 0x00, blkref #0: rel
1663/17039/30465233 blk 4506
rmgr: Heap        len (rec/tot):    102/   102, tx:  818991942, lsn:
17B3/9159B0E0, prev 17B3/9159B0A8, desc: HOT_UPDATE old_xmax: 818991942,
old_off: 110, old_infobits: [], flags: 0x10, new_xmax: 818991942, new_off:
112, blkref #0: rel 1663/17039/30465233 blk 4506

the wal dump does not show any broken previous link.

Any clue about this will be very appreciated

Regards

Fabrice

Reply via email to