Re: Problem on PG7.2.2 - Mailing list pgsql-hackers

From Roberto Fichera
Subject Re: Problem on PG7.2.2
Date
Msg-id 5.1.1.6.0.20020923170715.02782250@mail.isolaweb.it
Whole thread Raw
In response to Re: Problem on PG7.2.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
At 10.40 23/09/02 -0400, Tom Lane wrote:

>Roberto Fichera <kernel@tekno-soft.it> writes:
> > database=# select count(*) from detail;
> >   count
> > --------
> >   181661
> > (1 row)
>
> > database=# select count(*) from detail;
> >   count
> > --------
> >   181660
> > (1 row)
>
> > database=# select count(*) from detail;
> > FATAL 2:  open of /var/lib/pgsql/data/pg_clog/0303 failed: No such file or
> > directory
>
>[ blinks... ]  That's with no one else modifying the table meanwhile?

This table is used to hold all the logs from our Radius servers,
so we have only INSERT from the radiusd server.


>I think you've got *serious* hardware problems.  Hard to tell if it's
>disk or memory, but get out those diagnostic programs now ...

What diagnostic programs do you suggest ?


Roberto Fichera.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem on PG7.2.2
Next
From: Tom Lane
Date:
Subject: Default privileges for 7.3