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

Поиск
Список
Период
Сортировка
От ADSJ (Adam Sjøgren)
Тема Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Дата
Msg-id 7pvalxvsco.fsf@novozymes.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100  (ADSJ (Adam Sjøgren) <adsj@novozymes.com>)
Ответы Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
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".


  Best regards,

    Adam

--
 "My Dear Babbage. I am in much dismay at having              Adam Sjøgren
  got into so amazing a quagmire & botheration with     adsj@novozymes.com
  these Numbers, that I cannot possibly get the
  thing done today."


В списке pgsql-general по дате отправления:

Предыдущее
От: basti
Дата:
Сообщение: [GENERAL] invalid byte sequence for encoding
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100