Re: ERROR: XX001 (Critical and Urgent)

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Siddharth Shah" <siddharth(dot)shah(at)elitecore(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: XX001 (Critical and Urgent)
Date: 2010-05-07 14:19:23
Message-ID: 4BE3DB1D020000250003138A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

[rearranged to put the most critical point first]

Siddharth Shah <siddharth(dot)shah(at)elitecore(dot)com> wrote:

> I don't have any backup available, Is there any way to fix this ?

I *strongly* recommend that you shut down the database and take a
file copy of the whole data tree (everything under what -D points to
on the server startup) which you should keep until long after you
think everything is working OK again. Before you do anything else.
You are at risk of losing everything in the database, and one
misstep could put you over the edge. If this is a production
database, tell the users that it is down until further notice.

> What can be the method to verify that it's a database corruption ?

> ERROR: index "pg_class_relname_nsp_index" contains unexpected
> zero page at block 33

Getting an error like that indicates database corruption.

> HINT: Please REINDEX it.
> xdb=# reindex index pg_class_relname_nsp_index;
>
> Now INDEXing taking High CPU and postgres baffled.

That is an index on the table which describes all your tables and
indexes. It normally doesn't take a long time to reindex. You
should consider doing your recovery in single-user mode (*AFTER* you
make that copy):

http://www.postgresql.org/docs/8.4/interactive/app-postgres.html

After trying reindex in that context, please post again.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Silvio Brandani 2010-05-07 14:26:51 postgres invoked oom-killer
Previous Message Siddharth Shah 2010-05-07 13:51:29 Re: ERROR: XX001 (Critical and Urgent)

Browse pgsql-novice by date

  From Date Subject
Next Message Siddharth Shah 2010-05-07 15:00:38 Re: ERROR: XX001 (Critical and Urgent)
Previous Message Siddharth Shah 2010-05-07 13:51:29 Re: ERROR: XX001 (Critical and Urgent)