Hi,
I have a 13.4 based setup (physical streaming replication) where the
replica does the attach log upon startup, and when the first message is
sent from the primary.
There is the FATAL from when the WAL receiver shuts down, but I think it
would be a benefit to have report_invalid_record() log at ERROR level
instead to highlight to the admin that there is a serious problem.
Feel free to contact me off-list for the setup (20Mb).
Thoughts ?
Best regards,
Jesper
[1412350] [2021-09-07 08:51:27.172 EDT] [] [0] LOG: starting PostgreSQL 13.4
on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.2.1 20210728 (Red Hat
11.2.1-1), 64-bit
[1412350] [2021-09-07 08:51:27.173 EDT] [] [0] LOG: listening on IPv4 address
"0.0.0.0", port 5433
[1412350] [2021-09-07 08:51:27.173 EDT] [] [0] LOG: listening on IPv6 address
"::", port 5433
[1412350] [2021-09-07 08:51:27.176 EDT] [] [0] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5433"
[1412352] [2021-09-07 08:51:27.186 EDT] [] [0] LOG: database system was shut
down at 2020-10-01 07:48:52 EDT
[1412352] [2021-09-07 08:51:27.186 EDT] [] [0] LOG: entering standby mode
[1412352] [2021-09-07 08:51:27.191 EDT] [] [0] LOG: consistent recovery state
reached at 0/5000118
[1412352] [2021-09-07 08:51:27.191 EDT] [] [0] LOG: invalid record length at
0/5000118: wanted 24, got 0
[1412350] [2021-09-07 08:51:27.192 EDT] [] [0] LOG: database system is ready
to accept read only connections
[1412356] [2021-09-07 08:51:27.224 EDT] [] [0] LOG: started streaming WAL from
primary at 0/5000000 on timeline 1
[1412352] [2021-09-07 08:52:54.091 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412356] [2021-09-07 08:52:54.091 EDT] [] [0] FATAL: terminating walreceiver
process due to administrator command
[1412352] [2021-09-07 08:52:54.092 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:52:54.092 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:52:59.096 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:53:04.101 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:53:09.105 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:53:14.109 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412352] [2021-09-07 08:53:19.113 EDT] [] [0] LOG: record with incorrect
prev-link 8DE46ADF/30 at 0/5000118
[1412350] [2021-09-07 08:53:22.187 EDT] [] [0] LOG: received fast shutdown
request
[1412350] [2021-09-07 08:53:22.194 EDT] [] [0] LOG: aborting any active
transactions
[1412353] [2021-09-07 08:53:22.195 EDT] [] [0] LOG: shutting down
[1412350] [2021-09-07 08:53:22.209 EDT] [] [0] LOG: database system is shut
down
