From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
Cc: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com>, "PostgreSQL Bugs [pgsql-bugs(at)postgresql(dot)org]" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Postgresql 9.3.4 Streaming Replication Standby invalid Page block |
Date: | 2014-07-02 11:09:44 |
Message-ID: | 20140702110944.GL21169@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2014-07-02 14:02:27 +0300, Heikki Linnakangas wrote:
> On 07/02/2014 02:03 AM, Burgess, Freddie wrote:
> > PostgreSQL version: 9.3.4
> > Operating system: rhel 6.4 linux
> > Action: stream replication Master/Slave
> > Description:
> >
> >Last entries in the PostgreSQL log file before the standby crashed, the primary seems unaffected
> >
> >LOG: restored log file "0000000100001127000000cc" from archive
> >FATAL: invalid page in block 464698 of relation pg_tblspc/16435/PG_9.3_201306121/16444/125127698
> >CONTEXT: xlog redo vacuum: rel 16435/16444/125127698; blk 512019, lastBlockVacuumed 0
> >LOG: startup process (PID 27797) exited with exit code 1
> >LOG: terminating any other active server processes
> >
> >We did re-started the database and the process of restoring the log file has continued beyond this point, but is are standby server corrupted?
Do you run with data checksums enabled?
> Sounds exactly like this bug:
>
> http://www.postgresql.org/message-id/flat/CAL_0b1s4QCkFy_55kk_8XWcJPs7wsgVWf8vn4=jXe6V4R7Hxmg(at)mail(dot)gmail(dot)com
>
> but that was fixed in 9.3.3 already. Are you sure you're running 9.3.4 in
> the standby too?
Hm - that bug was about uninitialized pages, not invalid ones. I don't
immediately see why it'd be legal to have a invalid page (as in
!PageIsVerified()) somewhere? At least not after reaching consistency.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Pavan Deolasee | 2014-07-02 11:58:25 | Re: BUG #10675: alter database set tablespace and unlogged table |
Previous Message | Heikki Linnakangas | 2014-07-02 11:02:27 | Re: Postgresql 9.3.4 Streaming Replication Standby invalid Page block |