Обсуждение: ERROR: Cache lookup failed for relation 5741599

hi,
  i was running postgres in foreground while doing a vaccum.. the vaccum didnt
finish its job because of a power failure...

 i tried to reconnect to the db and i got this error when i issue a \d
 (hoping  to see the tables..)

ERROR:  Cache lookup failed for relation 5741599

is there a way to retrieve my data..??


TIA

jerome <jerome@gmanmi.tv> writes:
>   i was running postgres in foreground while doing a vaccum.. the vaccum didnt
> finish its job because of a power failure...
>  i tried to reconnect to the db and i got this error when i issue a \d
>  (hoping  to see the tables..)
> ERROR:  Cache lookup failed for relation 5741599
> is there a way to retrieve my data..??

You might find that reindexing the system indexes will get you out of
trouble.  See the REINDEX man page for the detailed procedure to follow;
it's a bit messy...

            regards, tom lane

i tried running postgres and did a reindex..

and i got this..

...................
NOTICE:  relation 16596 was reindexed
NOTICE:  relation 16598 was reindexed
NOTICE:  relation 16384 was reindexed
NOTICE:  relation 16386 was reindexed
NOTICE:  relation 1262 was reindexed
ERROR:  Cannot create unique index. Table contains non-unique values
backend>

is there other ways of doing fixing this?

TIA

On Thursday 17 July 2003 04:58, you wrote:
> jerome <jerome@gmanmi.tv> writes:
> >   i was running postgres in foreground while doing a vaccum.. the vaccum
> > didnt finish its job because of a power failure...
> >  i tried to reconnect to the db and i got this error when i issue a \d
> >  (hoping  to see the tables..)
> > ERROR:  Cache lookup failed for relation 5741599
> > is there a way to retrieve my data..??
>
> You might find that reindexing the system indexes will get you out of
> trouble.  See the REINDEX man page for the detailed procedure to follow;
> it's a bit messy...
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html