Re: quickdie doing memory allocations (was atomic pin/unpin causing errors)
Re: quickdie doing memory allocations (was atomic pin/unpin causing errors)
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Re: HeapTupleSatisfiesToast() busted? (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)
От:
Andres Freund <andres@anarazel.de>
Дата:
Re: quickdie doing memory allocations (was 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: 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)
От:
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)
От:
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)
От:
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)
От:
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)
От:
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)
От:
Andres Freund <andres@anarazel.de>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
David Fetter <david@fetter.org>
Дата:
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)
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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)
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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)
От:
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: quickdie doing memory allocations (was atomic pin/unpin causing errors)
От:
Robert Haas <robertmhaas@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Robert Haas <robertmhaas@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Jeff Janes <jeff.janes@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Jeff Janes <jeff.janes@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Jeff Janes <jeff.janes@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Jeff Janes <jeff.janes@gmail.com>
Дата:
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Simon Riggs <simon@2ndQuadrant.com>
Дата:
On 10 May 2016 at 17:20, Andres Freund <andres@anarazel.de> wrote:
--
On 2016-05-10 12:28:57 +0200, Simon Riggs wrote:
> On 10 May 2016 at 09:05, Andres Freund <andres@anarazel.de> wrote:
>
>
> > Is anybody ready with a good defense for SatisfiesToast not doing any
> > actual liveliness checks?
> >
>
> I provided a patch earlier that rechecks the OID fetched from a toast chunk
> matches the OID requested.
They match in this case, so that's not likely to help with the issue at
hand?
I can see, but I was answering your more general question above with what I had available.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Simon Riggs <simon@2ndQuadrant.com>
Дата:
On 10 May 2016 at 09:05, Andres Freund <andres@anarazel.de> wrote:
--
Is anybody ready with a good defense for SatisfiesToast not doing any
actual liveliness checks?
I provided a patch earlier that rechecks the OID fetched from a toast chunk matches the OID requested.
I didn't commit it, I just used it to check the patch which changed btree vacuum replay.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: atomic pin/unpin causing errors
От:
Alexander Korotkov <a.korotkov@postgrespro.ru>
Дата:
On Wed, May 4, 2016 at 2:05 AM, Andres Freund <andres@anarazel.de> wrote:
On 2016-04-29 10:38:55 -0700, Jeff Janes wrote:
> I've bisected the errors I was seeing, discussed in
> http://www.postgresql.org/message-id/CAMkU=1xQEhC0Ok4d+tkjFQ1nvUhO37PYRKhJP6Q8oxifMx7OwA@mail.gmail.com
>
> It look like they first appear in:
>
> commit 48354581a49c30f5757c203415aa8412d85b0f70
> Author: Andres Freund <andres@anarazel.de>
> Date: Sun Apr 10 20:12:32 2016 -0700
>
> Allow Pin/UnpinBuffer to operate in a lockfree manner.
>
>
> I get the errors:
>
> ERROR: attempted to delete invisible tuple
> STATEMENT: update foo set count=count+1,text_array=$1 where text_array @> $2
>
> And also:
>
> ERROR: unexpected chunk number 1 (expected 2) for toast value
> 85223889 in pg_toast_16424
> STATEMENT: update foo set count=count+1 where text_array @> $1
Hm. I appear to have trouble reproducing this issue (continuing to try)
on master as of 8826d8507. Is there any chance you could package up a
data directory after the issue hit?
FWIW, I'm also trying to reproduce it on big x86 machine on 9888b34f.
I'll write about results when get any.
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
От:
Jim Nasby <Jim.Nasby@BlueTreble.com>
Дата: