Re: FW: getting error while running sql on mm_activealrm table

Hi,

We performed the following actions to recover

1. Restart the DB
2. Rebuild the index
3. Vacume the index

mgrdb=# select count(*) from mm_activealarm;
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
mgrdb=# REINDEX table pg_toast.pg_toast_2619;
REINDEX
mgrdb=# VACUUM ANALYZE mm_activealarm;
VACUUM
mgrdb=# commit;
WARNING: there is no transaction in progress
COMMIT
mgrdb=# select count(*) from mm_activealarm;
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
mgrdb=#

4. Finally we drop the MM_ActiveAlarm table.and recreated it
5. Still after that we were not able to see the column
even after recreating the table with columns there are no columns present in table itself

Can you please suggest more on this ?

Regards
Tarkeshwar
-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: 03 December 2014 20:22
To: M Tarkeshwar Rao; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] FW: getting error while running sql on mm_activealrm table

On 12/03/2014 03:07 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are getting following error message on doing any action on the
> table like(Select or open from pgadmin).
>
> Please suggest.
>

http://dba.stackexchange.com/questions/31008/pg-dump-and-error-missing-chunk-number-0-for-toast-value

Though the question still remains, what got it into that state?

Any recent hardware/software issues?

>
> Regards
>
> Tarkeshwar
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com