| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: atomic pin/unpin causing errors |
| Date: | 2016-05-04 15:12:45 |
| Message-ID: | 572A116D.8050700@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>> 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?
I've got
ERROR: unexpected chunk number 0 (expected 1) for toast value 10192986 in
pg_toast_16424
The test required 10 hours to run on my notebook. postgresql was compiled with
-O0 --enable-debug --enable-cassert.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2016-05-04 15:20:25 | Re: pg_dump broken for non-super user |
| Previous Message | Tom Lane | 2016-05-04 15:01:09 | Re: Segmentation fault when max_parallel degree is very High |