Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)

Поиск
Список
Период
Сортировка
Искать
От
Jeff Janes
Тема
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
Дата
в 16:44:12
Msg-id
CAMkU=1zK+yBOChgk3HSRtQX6LxOeNXpP7onSo4GkOd4a01jk-g@mail.gmail.com
Ответ на
Список
Дерево обсуждения
atomic pin/unpin causing errors Jeff Janes <jeff.janes@gmail.com>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Teodor Sigaev <teodor@sigaev.ru>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Teodor Sigaev <teodor@sigaev.ru>
Re: atomic pin/unpin causing errors Teodor Sigaev <teodor@sigaev.ru>
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors) Robert Haas <robertmhaas@gmail.com>
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Teodor Sigaev <teodor@sigaev.ru>
Re: atomic pin/unpin causing errors Jeff Janes <jeff.janes@gmail.com>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: Missing error handling for FATALs in checkpointer/bgwriter Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Jeff Janes <jeff.janes@gmail.com>
Re: atomic pin/unpin causing errors Andres Freund <andres@anarazel.de>
Re: atomic pin/unpin causing errors Jeff Janes <jeff.janes@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Teodor Sigaev <teodor@sigaev.ru>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Robert Haas <robertmhaas@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Jeff Janes <jeff.janes@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Jeff Janes <jeff.janes@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Jeff Janes <jeff.janes@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Robert Haas <robertmhaas@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Tom Lane <tgl@sss.pgh.pa.us>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) David Fetter <david@fetter.org>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Jeff Janes <jeff.janes@gmail.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Simon Riggs <simon@2ndQuadrant.com>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Andres Freund <andres@anarazel.de>
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors) Simon Riggs <simon@2ndQuadrant.com>
On Mon, May 16, 2016 at 8:28 AM, Andres Freund  wrote:
> On 2016-05-10 17:58:33 -0700, Andres Freund wrote:
>> FWIW, I've commented out the relevant sections from xlog_redo and since
>> then I've not been able to reproduce the issue.
>
> A couple days of running later, and it hasn't yet re-triggered. So I
> assume that's indeed the fix.

Yes, I've also run it to wrap-around a few times with that commented
out, so I agree that that is a fix. But I don't think we should apply
until we get the larger issue with hit-bits is fixed first, as then we
are masking one problem by fixing another.

Although it doesn't really matter to me, because I'm not using HEAD to
run the tests anyway, as I can't get the error to trigger on HEAD.  As
a side note, using 48354581a49c30f5 and without commenting out the
part of the replay code we are talking about, I also need
track_io_timing to be on in order to get the error.  I don't think
there is any direct causation there, just another fiddly timing issue.

I've tried fixing the hit-bit issue as well, but I'm afraid it is over
my head.  I'll be happy to test proposed patches, though.

Cheers,

Jeff


В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Jeff Janes
Дата:
Сообщение: Re: 10.0
FAQ