Postgresql 9.3.4 Streaming Replication Standby invalid Page block

From: "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com>
To: PostgreSQL Bugs ‎[pgsql-bugs(at)postgresql(dot)org]‎ <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgresql 9.3.4 Streaming Replication Standby invalid Page block
Date: 2014-07-01 23:03:54
Message-ID: 3BBE635F64E28D4C899377A61DAA9FE02E66257B@NBSVR-MAIL01.radiantblue.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2014-07-02 06:58:08 Re: BUG #10822: "ALTER SYSTEM cannot run inside a transaction block" when having autocommit disabled.
Previous Message Bruce Momjian 2014-07-01 19:30:47 Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts