Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От
Jeff Janes
Тема
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin
causing errors)
Дата
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 по дате отправления