Corrupt records in WAL archive - Mailing list pgsql-admin

From Craig James
Subject Corrupt records in WAL archive
Date
Msg-id CAFwQ8rfSwNboCr3UA8h4fb9W+z2vu_YObSCTRWuaU4bJe9Stcw@mail.gmail.com
Whole thread Raw
List pgsql-admin
2014-08-26 06:16:27 PDT  : LOG:  invalid contrecord length 2 in log file 545, segment 146, offset 0
2014-08-26 06:16:32 PDT  : LOG:  restored log file "000000010000022100000091" from archive
2014-08-26 06:16:32 PDT  : LOG:  restored log file "000000010000022100000092" from archive
2014-08-26 06:16:32 PDT  : LOG:  invalid contrecord length 2 in log file 545, segment 146, offset 0
2014-08-26 06:16:37 PDT  : LOG:  restored log file "000000010000022100000091" from archive
2014-08-26 06:16:37 PDT  : LOG:  restored log file "000000010000022100000092" from archive
2014-08-26 06:16:37 PDT  : LOG:  invalid contrecord length 2 in log file 545, segment 146, offset 0
2014-08-26 06:16:42 PDT  : LOG:  restored log file "000000010000022100000091" from archive
2014-08-26 06:16:42 PDT  : LOG:  restored log file "000000010000022100000092" from archive

What's this about? I found several other complaints about this, but no answers other than, "do another basebackup, or maybe your whole database is corrupt."

We're trying to set up a reliable warm standby. Each time this happens we're vulnerable until the next basebackup is complete -- the better part of a day. It's not reassuring.

This is 9.2.4 running on Linux. We're going to update to the latest 9.2 before we start the next basebackup. It would be very reassuring to know this is fixed.

Thanks,
Craig

pgsql-admin by date:

Previous
From: Dhruv Shukla
Date:
Subject: Re: Problems with PG 9.3
Next
From: Dhruv Shukla
Date:
Subject: Re: Problems with PG 9.3