ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881

Sorry I think I posted this to the wrong group, sent to performance vs
General. My apologies to everyone in perf!

Greetings and salutations.
>
> I've got some weirdness.
>
> Current:
> Postgres 9.3.4
> Slony 2.2.3
> CentOS 6.5
>
> Prior running Postgres 9.1.2 w/slony 2.1.3 CentOS 6.2
>
> I found that if I tried to run a vacuum full on 1 table that I recently
> reindexed (out of possibly 8 tables) that I get this error:
>
> # vacuum full table.ads;
>
> ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
>
> If I run a vacuum analyze it completes fine, but I can't run a vacuum full
> without it throwing an error. I seem to be able to query the table and I
> seem to be able to add data to the table and slony seems fine as does
> postgres.
>
> I'm unclear why the vacuum full is failing with this error. I've done some
> searching and there are hints to prior bugs, but I didn't catch anything in
> 9.3.3 to 9.3.7 that talks about this.
>
> My next steps without your fine assistance, will be to drop the table from
> slon and re-add it (meaning it will drop the table completely from this db
> and recreate it from the master (there we can do a vacuum full without
> failure)..
>
> I have already tried to remove the indexes and just create those, but no
> luck.
>
> Ideas?
>
> Thanks
>
> Tory
>
>
>
>