Re: Hanging backends and possible index corruption

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Hanging backends and possible index corruption
Date: 2013-01-25 15:49:48
Message-ID: 81DA8269F57CF97043111ED1@apophis.credativ.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 25. Januar 2013 16:28:16 +0100 Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:

> Did you reindex after upgrading to 9.1.6? Did you ever have any crashes
> or failovers before upgrading to 9.1.6?
> I have seen pretty similar symptoms caused by "Fix persistence marking
> of shared buffers during WAL replay" in 9.1.6.

Hmm it happened only on a single heavily used table for now and this table
was REINDEXed twice after updating to 9.1.6 (every time the issue occured).

--
Thanks

Bernd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-01-25 15:51:39 Re: COPY FREEZE has no warning
Previous Message Peter Eisentraut 2013-01-25 15:49:25 Re: autovacuum not prioritising for-wraparound tables