Re: atomic pin/unpin causing errors

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: atomic pin/unpin causing errors
Дата
Msg-id CAPpHfdtZ4U3NeUBqR0zUHszn74pEbM9dK0LMLG4p2ENqXp22sA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: atomic pin/unpin causing errors  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
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 

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: pg_dump dump catalog ACLs