Thanks Bharath for your response,
> You mentioned that
> the connection to primary was lost, so you need to dive deep as to why
> it got lost. If the connection was lost half-way through fetching the
> WAL record, the standby may emit such a LOG message.
The connection was lost due to bad network
On Wed, Mar 1, 2023 at 10:51 AM Harinath Kanchu wrote:
>
> Hello,
>
> We are seeing an interesting STANDBY behavior, that’s happening once in 3-4
> days.
>
> The standby suddenly disconnects from the primary, and it throws the error
> “LOG: invalid record length at : wanted 24, got0”.
Firstly,
Hello,
We are seeing an interesting STANDBY behavior, that’s happening once in 3-4
days.
The standby suddenly disconnects from the primary, and it throws the error
“LOG: invalid record length at : wanted 24, got0”.
And then it tries to restore the WAL file from the archive. Due to low write
a