From: | adsj(at)novozymes(dot)com (Adam =?utf-8?Q?Sj=C3=B8gren?=) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
Date: | 2018-04-05 15:32:27 |
Message-ID: | 87bmexekj8.fsf@tullinup.koldfront.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adam writes:
> Here's a statement which currently gives an unexpected chunk error:
>
> efamroot(at)kat efam=# SELECT * FROM efam.sendreference WHERE id = '189909908';
> ERROR: unexpected chunk number 0 (expected 1) for toast value 1698936148 in pg_toast_10919630
>
> And when I run the suggested query, I get:
>
> efamroot(at)kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630 where chunk_id = 1698936148 order by 1,2;
> chunk_id | chunk_seq | ctid | xmin | xmax | length
> ------------+-----------+--------------+------------+------+--------
> 1698936148 | 0 | (52888694,2) | 1511390221 | 0 | 1996
> 1698936148 | 1 | (52888694,4) | 1511390221 | 0 | 1148
> (2 rows)
More examples:
efamroot(at)kat efam=# SELECT * FROM efam.sendreference WHERE id = '237764759';
ERROR: unexpected chunk number 0 (expected 1) for toast value 1698958350 in pg_toast_10919630
efamroot(at)kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630 where chunk_id = 1698958350 order by 1,2;
chunk_id | chunk_seq | ctid | xmin | xmax | length
------------+-----------+--------------+------------+------+--------
1698958350 | 0 | (54859821,2) | 1511487270 | 0 | 1448
(1 row)
And:
efamroot(at)kat efam=# SELECT * FROM efam.sendreference WHERE id = '366275833';
ERROR: unexpected chunk number 0 (expected 1) for toast value 1698945095 in pg_toast_10919630
efamroot(at)kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630 where chunk_id = 1698945095 order by 1,2;
chunk_id | chunk_seq | ctid | xmin | xmax | length
------------+-----------+--------------+------------+------+--------
1698945095 | 0 | (53706565,3) | 1511426847 | 0 | 1996
1698945095 | 1 | (53706565,6) | 1511426847 | 0 | 108
(2 rows)
One more:
efamroot(at)kat efam=# SELECT * FROM efam.sendreference WHERE id = '189909908';
ERROR: unexpected chunk number 0 (expected 1) for toast value 1698936148 in pg_toast_10919630
efamroot(at)kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630 where chunk_id = 1698936148 order by 1,2;
chunk_id | chunk_seq | ctid | xmin | xmax | length
------------+-----------+--------------+------------+------+--------
1698936148 | 0 | (52888694,2) | 1511390221 | 0 | 1996
1698936148 | 1 | (52888694,4) | 1511390221 | 0 | 1148
(2 rows)
And here is one from another table:
efamroot(at)kat efam=# SELECT * FROM efam.sequence WHERE id = '235887163';
ERROR: unexpected chunk number 0 (expected 1) for toast value 1698750544 in pg_toast_10919630
efamroot(at)kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630 where chunk_id = 1698750544 order by 1,2;
chunk_id | chunk_seq | ctid | xmin | xmax | length
------------+-----------+--------------+------------+------+--------
1698750544 | 0 | (39575142,3) | 1510704835 | 0 | 1996
1698750544 | 1 | (39575142,4) | 1510704835 | 0 | 716
(2 rows)
Let me know what other relevant info I can provide.
Best regards,
Adam
--
"No more than that, but very powerful all the Adam Sjøgren
same; simple things are good." adsj(at)novozymes(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-04-05 15:37:01 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
Previous Message | Adam =?utf-8?Q?Sj=C3=B8gren?= | 2018-04-05 15:19:58 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |