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 10:07:32 |
Message-ID: | 5.1.1.6.0.20020923164822.03709ec0@mail.isolaweb.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 10.40 23/09/02 -0400, you wrote:
>Roberto Fichera <kernel(at)tekno-soft(dot)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(at)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 while processing the request.
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
[root(at)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(at)foradada pgsql]#
Roberto Fichera.
From | Date | Subject | |
---|---|---|---|
Next Message | CoL | 2002-09-24 12:23:21 | Re: Web site |
Previous Message | Manfred Koizar | 2002-09-24 09:44:42 | Re: [GENERAL] CURRENT_TIMESTAMP |