Обсуждение: Relation does not exist

<p><font size="2">Our customer reported a problem with Postgres v.7.3.2 server on Solaris 8</font><br /><font
size="2">Iasked them to run a quick query and it looks like the database is corrupted:</font><p><font size="2">select
count(1) from t_revisioncontrol</font><br /><font size="2">ERROR: Relation 17236 does not exist</font><br /><font
size="2"> </font><br/><font size="2">What can I do next?</font><br /><font size="2">Thanks,</font><br /><font
size="2">Mike</font>

"Brusser, Michael" <Michael.Brusser@matrixone.com> writes:
> Our customer reported a problem with Postgres v.7.3.2 server on Solaris 8
> I asked them to run a quick query and it looks like the database is
> corrupted:

> select count (1) from t_revisioncontrol
> ERROR: Relation 17236 does not exist

If you are lucky, the problem is just one of corrupted indexes on
the system catalogs (most likely pg_class_oid_index) and can be fixed
by REINDEXing.

What happened to lead up to this?  Usually this sort of thing doesn't
appear out of the blue.  Any system crashes or anything?
        regards, tom lane

<p><font size="2">> "Brusser, Michael" <Michael.Brusser@matrixone.com> writes:</font><br /><font size="2">>
>Our customer reported a problem with Postgres v.7.3.2 </font><br /><font size="2">> server on Solaris
8</font><br/><font size="2">> > I asked them to run a quick query and it looks like the database is</font><br
/><fontsize="2">> > corrupted:</font><br /><font size="2">> </font><br /><font size="2">> > select count
(1)from t_revisioncontrol</font><br /><font size="2">> > ERROR: Relation 17236 does not exist</font><br /><font
size="2">></font><br /><font size="2">> If you are lucky, the problem is just one of corrupted indexes
on</font><br/><font size="2">> the system catalogs (most likely pg_class_oid_index) and can be fixed</font><br
/><fontsize="2">> by REINDEXing.</font><br /><font size="2">> </font><br /><font size="2">> What happened to
leadup to this?  Usually this sort of thing doesn't</font><br /><font size="2">> appear out of the blue.  Any system
crashesor anything?</font><br /><font size="2">> </font><br /><font size="2">>                       regards, tom
lane</font><p><fontsize="2">All they said was that "they did not have power outage"</font><br /><font size="2">REINDEX
helped,many thanks!</font><p><font size="2">Mike.</font><br /><p><font size="2"> </font>