Re: Problem on PG7.2.2

From: Roberto Fichera <kernel(at)tekno-soft(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem on PG7.2.2
Date: 2002-09-24 16:43:36
Message-ID: 5.1.1.6.0.20020924183944.02c2cec0@mail.isolaweb.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 09.31 24/09/02 -0400, Tom Lane wrote:
>Roberto Fichera <kernel(at)tekno-soft(dot)it> writes:
> > At 10.40 23/09/02 -0400, you wrote:
> >> I think you've got *serious* hardware problems. Hard to tell if it's
> >> disk or memory, but get out those diagnostic programs now ...
>
> > database=# DROP TABLE TS;
> > ERROR: cannot find attribute 1 of relation ts_pkey
> > database=# DROP INDEX TS_PKEY;
> > ERROR: cannot find attribute 1 of relation ts_pkey
>
>Now you've got corrupted system indexes (IIRC this is a symptom of
>problems in one of the indexes for pg_attribute).
>
>You might be able to recover from this using a REINDEX DATABASE
>operation (read the man page carefully, it's a bit tricky), but
>I am convinced that you've got hardware problems. I would suggest
>that you first shut down the database and then find and fix your
>hardware problem --- otherwise, things will just get worse and worse.
>After you have a stable platform again, you can try to restore
>consistency to the database.

Below there is the first try session and as you can see there is the same
problem :-(!

bash-2.05a$ postgres -D /var/lib/pgsql/data -O -P database
DEBUG: database system was shut down at 2002-09-24 18:39:24 CEST
DEBUG: checkpoint record is at 0/2AE97110
DEBUG: redo record is at 0/2AE97110; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 366635; next oid: 1723171
DEBUG: database system is ready

POSTGRES backend interactive interface
$Revision: 1.245.2.2 $ $Date: 2002/02/27 23:17:01 $

backend> reindex table detail;
FATAL 2: open of /var/lib/pgsql/data/pg_clog/0504 failed: No such file or
directory
DEBUG: shutting down
DEBUG: database system is shut down
bash-2.05a$

Roberto Fichera.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-09-24 16:48:02 Re: subselect bug (was Re: [GENERAL] DBLink: interesting
Previous Message Roberto Fichera 2002-09-24 16:27:19 Re: Problem on PG7.2.2