pg_dump error on hot standy db (msg or pg_toast missing a chunk number).

From: lazyPGDBA <anson(dot)abraham(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dump error on hot standy db (msg or pg_toast missing a chunk number).
Date: 2012-09-05 15:02:42
Message-ID: ef625792-0ea9-4088-be42-eb197b6a45ac@googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
relatively new to Postgres. I'm on 9.0 database instance on CentOS. I was doing a pg_dump of my replicated (hot standby) database (b/c doing it on the master was killing other processes running against it).

My pg_dump failed. I was getting this error:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 2950316 in pg_toast_1733250
pg_dump: The command was: COPY schema.tablename (col1,col2,...col10) TO stdout;

doing a select * also gives me an error of:
ERROR: missing chunk number 0 for toast value 2950316 in pg_toast_1733250

Doing a search i see that a possible reindex of the table:
REINDEX index pg_toast.pg_toast_1733250;
or REINDEX table pg_toast.pg_toast_1733250;
would help ... but being this is a hot standby database, i'm getting the message:
ERROR: cannot execute REINDEX during recovery

Now on the master database the table is ok. I did an analyze and it was ok. I'm not sure how I can fix this issue, unless i kill the replication or redo the replication. But by doing that, it'll take a very long time.
Any help here would be greatly appreciated as to what my next steps would be.
Thanks.

Browse pgsql-novice by date

  From Date Subject
Next Message Matt Musgrove 2012-09-05 15:15:28 Re: Get file size
Previous Message Josh Kupershmidt 2012-09-04 21:37:56 Re: Get file size