Is column size less than 8 kb will help us? -----Original Message----- From: M Tarkeshwar Rao Sent: 10 December 2014 11:51 To: 'Adrian Klaver'; 'pgsql-general@postgresql.org' Subject: RE: [GENERAL] FW: getting error while running sql on mm_activealrm table
Hi all, We have done all the suggested things from reindex and vaccume to hardware heat issue. But do not get the clue why this happened? Can you please suggest what are the checkpoints we follow so that we can avoid this kind of issue in future? Regards Tarkeshwar -----Original Message----- From: M Tarkeshwar Rao Sent: 04 December 2014 17:32 To: M Tarkeshwar Rao; Adrian Klaver; pgsql-general@postgresql.org Subject: RE: [GENERAL] FW: getting error while running sql on mm_activealrm table Hi all, Finally DB was restored from the backup and the issue was solved. Is the data corrupted? I feel that data is corrupted as well as its some of the data dictionary also corrupted. That is the reason it is not displaying any columns for the table even the table is present. Regards Tarkeshwar -----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of M Tarkeshwar Rao Sent: 04 December 2014 16:38 To: Adrian Klaver; pgsql-general@postgresql.org Subject: Re: [GENERAL] 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.kla...@aklaver.com] Sent: 03 December 2014 20:22 To: M Tarkeshwar Rao; pgsql-general@postgresql.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.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
