Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory
Date
Msg-id 5333.1049054836@sss.pgh.pa.us
Whole thread Raw
In response to Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory  (pgsql-bugs@postgresql.org)
Responses Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996  (Andre Hackmann <ahackman@ebi.ac.uk>)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> PANIC:  open of /scratch/production_2/pg_clog/0996 failed: No such file or directory

I'd wonder about hardware problems, especially if this is a new server.
Messages of the above type are one of the most common consequences when
a data page has been trashed by hardware misfeasance.

(While I wouldn't sit here and swear that it couldn't be a software
problem, all of the cases I've been able to examine seemed to be
hardware failures...)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relation n does not exist when trying to ad a foregin key
Next
From: Tom Lane
Date:
Subject: Re: Server process crashes when using count(field).