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,
-
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
On 12/04/2014 03:08 AM, M Tarkeshwar Rao wrote:
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 p
On 12/03/2014 09:30 PM, M Tarkeshwar Rao wrote:
Hi Adrian,
Thanks Adrian for you quick reply. I am looking in this that why db came into
this stage.
--I have found overheating servers to be particularly prone to index corruption
and if indexes can get corrupt one has to worry about data becom
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 li
: 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
On 12/3/2014 9:30 PM, M Tarkeshwar Rao wrote:
I have found corrupted indexes are usually a sign that something is not well
with the server. It is good to check and make sure memory, CPU's and hard
drives are all happy and not reporting problems. I have found overheating
servers to be particula
laver [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 er
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
Hi all,
We are getting following error message on doing any action on the table
like(Select or open from pgadmin).
Please suggest.
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
** Error **
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2
10 matches
Mail list logo
