Adam writes:
> Here's a statement which currently gives an unexpected chunk error:
>
> efamroot@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@kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from
pg_toast.pg_toast_10919630where 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@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@kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630
wherechunk_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@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@kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630
wherechunk_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@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@kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630
wherechunk_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@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@kat efam=# select chunk_id, chunk_seq, ctid, xmin, xmax, length(chunk_data) from pg_toast.pg_toast_10919630
wherechunk_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@novozymes.com
