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.
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 ? |