Corrupt records in WAL archive

From: Craig James <cjames(at)emolecules(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Corrupt records in WAL archive
Date: 2014-08-26 13:58:18
Message-ID: CAFwQ8rfSwNboCr3UA8h4fb9W+z2vu_YObSCTRWuaU4bJe9Stcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Dhruv Shukla 2014-08-26 15:27:27 Re: Problems with PG 9.3
Previous Message Dhruv Shukla 2014-08-25 18:48:37 Re: Problems with PG 9.3