Streaming wal from primiry terminating

From: "Lahnov, Igor" <Igor(dot)Lahnov(at)nexign(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: "Timonin, Alexey" <Alexey(dot)Timonin(at)nexign(dot)com>, "Dmitriyev, Andrey" <Andrey(dot)Dmitriyev(at)nexign(dot)com>
Subject: Streaming wal from primiry terminating
Date: 2022-09-28 08:50:12
Message-ID: edfbeb1160a44922914ee016d94fea4c@nexign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
After failover all stand by nodes could not start streaming wal recovery.
Streaming recovery start from 1473/A5000000, but standby start at 1473/A5FFEE08, this seems to be the problem.
What can we do in this case to restore?
Is it possible to shift wal streaming recovery point on primary?
Can checkpoint on primary help in this situation?

2022-09-26 14:08:23.289 [3747796] LOG: consistent recovery state reached at 1473/A5FFEE08
2022-09-26 14:08:23.289 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:08:23.290 [3747793] LOG: database system is ready to accept read-only connections
2022-09-26 14:08:23.292 [3747867] LOG: starting bgworker pgsentinel
2022-09-26 14:08:23.672 [3747868] LOG: started streaming WAL from primary at 1473/A5000000 on timeline 18
2022-09-26 14:08:24.363 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:08:24.366 [3747868] FATAL: terminating walreceiver process due to administrator command
2022-09-26 14:08:24.366 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:08:24.366 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:08:24.366 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
...
...
...
2022-09-26 14:12:24.055 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:12:29.060 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:12:34.064 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:12:39.068 [3747796] LOG: invalid record length at 1473/A5FFEE08: wanted 24, got 0
2022-09-26 14:12:39.910 [3747793] LOG: received fast shutdown request
2022-09-26 14:12:39.911 [3747793] LOG: aborting any active transactions
2022-09-26 14:12:39.911 [3747867] LOG: bgworker pgsentinel signal: processed SIGTERM
2022-09-26 14:12:39.914 [3747797] LOG: shutting down
2022-09-26 14:12:39.922 [3747793] LOG: database system is shut down

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Kalcher 2022-09-28 10:40:31 Re: [PATCH] Introduce array_shuffle() and array_sample()
Previous Message Zwettler Markus (OIZ) 2022-09-28 08:29:18 is there still a memory leak with hash joins in PG 12.11 ?