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

At 10.40 23/09/02 -0400, you 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?
>
>I think you've got *serious* hardware problems.  Hard to tell if it's
>disk or memory, but get out those diagnostic programs now ...

This table is used to hold all the logs for our Radius authentication & 
statistics,
so we have only INSERT from the radiusd server.
I had no problem at all. No crash no panic, nothing.

database=# \d ts             Table "ts" Column |     Type      | Modifiers
--------+---------------+----------- name   | character(15) | ip_int | cidr          | not null
Primary key: ts_pkey

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
database=#

and again

[root@foradada pgsql]# pg_dump -d -f detail.sql -t detail database
pg_dump: dumpClasses(): SQL command failed
pg_dump: Error message from server: FATAL 2:  open of 
/var/lib/pgsql/data/pg_clog/0202 failed: No such file or directory
server closed the connection unexpectedly        This probably means the server terminated abnormally        before or
whileprocessing the request.
 
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
[root@foradada pgsql]# ls -al
totale 10464
drwx------    4 postgres postgres     4096 set 23 17:44 .
drwxr-xr-x   14 root     root         4096 set 23 13:06 ..
drwx------    2 postgres postgres     4096 ago 26 20:13 backups
-rw-------    1 postgres postgres     5519 set  5 00:53 .bash_history
-rw-r--r--    1 postgres postgres      107 ago 26 20:13 .bash_profile
drwx------    6 postgres postgres     4096 set 23 18:18 data
-rw-r--r--    1 root     root      6221242 set 24 12:04 detail.sql
-rw-r--r--    1 root     root          157 giu 25 14:43 initdb.i18n
-rw-------    1 postgres postgres    10088 set  5 00:14 .psql_history
[root@foradada pgsql]#


Roberto Fichera.