Re: [HACKERS] Streaming replication bug in 9.3.2, "WAL contains references to invalid pages"

2014-01-03 Thread Omar Kilani
We had the same issues running 9.2.4: [2013-10-15 00:23:01 GMT/0/15396] WARNING: page 8789807 of relation base/16429/2349631976 is uninitialized [2013-10-15 00:23:01 GMT/0/15396] CONTEXT: xlog redo vacuum: rel 1663/16429/2349631976; blk 8858544, lastBlockVacuumed 0 [2013-10-15 00:23:01 GMT/0/153

Re: [HACKERS] Streaming replication bug in 9.3.2, "WAL contains references to invalid pages"

2014-01-03 Thread Sergey Konoplev
On Thu, Jan 2, 2014 at 11:59 AM, Christophe Pettus wrote: > In both cases, the indicated relation was a primary key index. In one case, > rebuilding the primary key index caused the problem to go away permanently > (to date). In the second case, the problem returned even after a full dump / >

Re: [HACKERS] Streaming replication bug in 9.3.2, "WAL contains references to invalid pages"

2014-01-02 Thread MauMau
From: "Christophe Pettus" We've had two clients experience a crash on the secondary of a streaming replication pair, running PostgreSQL 9.3.2. In both cases, the messages were close to this example: 2013-12-30 18:08:00.464 PST,,,23869,,52ab4839.5d3d,16,,2013-12-13 09:47:37 PST,1/0,0,WARNING

[HACKERS] Streaming replication bug in 9.3.2, "WAL contains references to invalid pages"

2014-01-02 Thread Christophe Pettus
Greetings, We've had two clients experience a crash on the secondary of a streaming replication pair, running PostgreSQL 9.3.2. In both cases, the messages were close to this example: 2013-12-30 18:08:00.464 PST,,,23869,,52ab4839.5d3d,16,,2013-12-13 09:47:37 PST,1/0,0,WARNING,01000,"page 4578