Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Date
Msg-id CAOR=d=3mZRihFjjnPxXae2RXh8OoVPC3RA3=4kt=8gLe4_i76Q@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100  (ADSJ (Adam Sjøgren) <adsj@novozymes.com>)
Responses Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100  (Harry Ambrose <harry.ambrose@gmail.com>)
List pgsql-general
On Wed, Aug 9, 2017 at 6:27 AM, ADSJ (Adam Sjøgren) <adsj@novozymes.com> wrote:
> On 2017-06-21 Adam Sjøgren <adsj@novozymes.com> wrote:
>
>> Adam Sjøgren <adsj@novozymes.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.


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?
Next
From: Peter Hunčár
Date:
Subject: Re: [GENERAL] Multixact members limit exceeded