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
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 |