Re: LOG: invalid record length at : wanted 24, got 0

2023-03-01 Thread Harinath Kanchu
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

Re: LOG: invalid record length at : wanted 24, got 0

2023-02-28 Thread Bharath Rupireddy
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,

LOG: invalid record length at : wanted 24, got 0

2023-02-28 Thread Harinath Kanchu
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