Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

Adam writes:

> efamroot(at)kat efam=# explain 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;
> QUERY PLAN
> -------------------------------------------------------------------------------------
> Sort (cost=96465280.57..96470619.75 rows=2135674 width=54)
> Sort Key: chunk_seq
> -> Seq Scan on pg_toast_10919630 (cost=0.00..96240754.39 rows=2135674 width=54)
> Filter: (chunk_id = 1698936148::oid)
> (4 rows)
>
> 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;
> [... still waiting for the result, I will return with what it said
> when the server does ...]

It did eventually finish, with the same result:

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)

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