Skip site navigation (1) Skip section navigation (2)

FATAL 2: open of /usr/local/pgsql/data/pg_clog/0943 failed

From: Martins Zarins <Martins(dot)Zarins(at)vestnesis(dot)lv>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL 2: open of /usr/local/pgsql/data/pg_clog/0943 failed
Date: 2003-02-17 18:53:40
Message-ID: 200302172053.40181.Martins.Zarins@vestnesis.lv (view raw or flat)
Thread:
Lists: pgsql-admin
I have this error in postgres log
FATAL 2:  open of /usr/local/pgsql/data/pg_clog/0943 failed: No such file or 
directory
When it happend i did indexing on big table (~32M rows)
On small selects, inserts, updates all seems to work fine, but when I try to 
do select count(*) from big table or intex it, then server crashes and 
automaticaly restarts (file name in error message changes from time to time)
Theare is about 3.5GB free disk space.
Postgres version 7.2.1
Theare is no more unusual messages in log.

What happend?
How to fix this problem?
Google didn't help so much :(

Mark

pgsql-admin by date

Next:From: David WendyDate: 2003-02-17 18:54:30
Subject: log file maintenance
Previous:From: Mel JameroDate: 2003-02-17 16:58:08
Subject: best way to make incremental back-ups?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group