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: 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

От:
Andres Freund <andres@anarazel.de>
Дата:

Re: 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: atomic pin/unpin causing errors

От:
Andres Freund <andres@anarazel.de>
Дата:

Re: 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: 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)

От:
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: atomic pin/unpin causing errors

От:
Teodor Sigaev <teodor@sigaev.ru>
Дата:

Re: atomic pin/unpin causing errors

От:
Teodor Sigaev <teodor@sigaev.ru>
Дата:

Re: atomic pin/unpin causing errors

От:
Teodor Sigaev <teodor@sigaev.ru>
Дата:

Re: atomic pin/unpin causing errors

От:
Teodor Sigaev <teodor@sigaev.ru>
Дата:

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: atomic pin/unpin causing errors

От:
Jeff Janes <jeff.janes@gmail.com>
Дата:

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: atomic pin/unpin causing errors

От:
Jeff Janes <jeff.janes@gmail.com>
Дата:

Re: 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

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

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>
Дата:
FAQ