Re: Please help - corrupt database - Mailing list pgsql-novice

From Tom Lane
Subject Re: Please help - corrupt database
Date
Msg-id 29532.1229441021@sss.pgh.pa.us
Whole thread Raw
In response to Please help - corrupt database  ("Ertel, Steve" <Steve.Ertel@infimatic.com>)
Responses Re: Please help - corrupt database  ("Ertel, Steve" <Steve.Ertel@infimatic.com>)
List pgsql-novice
"Ertel, Steve" <Steve.Ertel@infimatic.com> writes:
> From the log files you can see that the backup does a REINDEX DATABASE db_name
> While this reindex is running, several other queries are running against the database wrapped in a BEGIN/COMMIT
transaction.
> After the transaction query was issued, the log file provides the message NOTICE:  table "pg_class" was reindexed
> A few more queries run and then the log file provides the error message: ERROR:  could not find pg_class tuple for
index2663 

> Is there anything that we can do to recover from this issue?

REINDEX DATABASE during active database operations is just asking for
trouble in 8.1 :-(.  There are race conditions that can be triggered
if another backend opens a reindexed index at the wrong time.

My advice is to stop doing the REINDEX DATABASE; I don't think that's
necessary or appropriate as a routine maintenance operation.  If you
insist on doing it, update to a recent 8.2.x or 8.3.x release, where
it should be reasonably safe.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Ertel, Steve"
Date:
Subject: Please help - corrupt database
Next
From: "Ertel, Steve"
Date:
Subject: Re: Please help - corrupt database