Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: adsj(at)novozymes(dot)com
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Date: 2017-08-09 19:27:47
Message-ID: CAOR=d=3mZRihFjjnPxXae2RXh8OoVPC3RA3=4kt=8gLe4_i76Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 9, 2017 at 6:27 AM, ADSJ (Adam Sjøgren) <adsj(at)novozymes(dot)com> wrote:
> On 2017-06-21 Adam Sjøgren <adsj(at)novozymes(dot)com> wrote:
>
>> Adam Sjøgren <adsj(at)novozymes(dot)com> wrote:
>
>>> Meanwhile, I can report that I have upgraded from 9.3.14 to 9.3.17 and
>>> the errors keep appearing the log.
>
> Just to close this, for the record: We haven't seen the errors since
> 2017-06-30. We upgraded to 9.3.17 (latest 9.3 point-release at the time
> of writing) on 2017-06-10.
>
> Whether this means that the affected rows gradually got overwritten
> after switching to .17 and thus got fixed, or if something subtle in our
> workflow changed, so we aren't hitting this anymore, or something else
> entirely is the answer, we're not sure.
>
> We didn't get to trying Alvaro Herrera's suggestion of removing
> 6c243f90ab6904f27fa990f1f3261e1d09a11853 before the errors stopped
> appearing "by themselves".

This sounds a lot like bad sectors getting remapped.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hunčár 2017-08-09 19:31:35 Re: Multixact members limit exceeded
Previous Message Melvin Davidson 2017-08-09 19:26:54 Re: How to ALTER EXTENSION name OWNER TO new_owner ?