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

Поиск
Список
Период
Сортировка
От Harry Ambrose
Тема Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Дата
Msg-id 66E7E557-CED6-466B-9B9C-B0307CD95F13@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

Thanks for the responses.

> "One lesson I learned from the BSD camp when dealing with random freezes and panics : when all else fails to give an
answerit is time to start blaming my hardware. Are those tablespaces on any cheap SSD's ?” 

The tablespaces are not sat on SSD’s. Something I had also considered.

Tom - I can provide a jar that I have been using to replicate the issue. Whats the best transport method to send it
over?

Best wishes,
Harry

> On 7 Jun 2017, at 16:27, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Harry Ambrose <harry.ambrose@gmail.com> writes:
>> I have been following the updates to the 9.4 branch hoping a fix will appear, but sadly no luck yet. I have manually
replicatedthe issue on 9.4.4, 9.4.10 and 9.4.12. My replication steps are: 
>
> This is a very interesting report, but you didn't actually provide a
> reproducer, just a handwavy outline.  If you submit a script that
> makes this happen, we will most definitely look into it.  But
> people aren't going to be excited about trying to reverse-engineer
> a test case out of a vague description.
>
>> I also found the following has been reported:
>> https://www.postgresql.org/message-id/20161201165505.4360.28203@wrigleys.postgresql.org
>
> That person never came back with a self-contained test case, either.
>
> https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
>             regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100