Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996

From: Andre Hackmann <ahackman(at)ebi(dot)ac(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996
Date: 2003-03-31 08:17:59
Message-ID: Pine.LNX.4.44.0303310908110.3710-100000@klimt.ebi.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Hi,

The server (IBM) is one year old (I think).
Anyway, I found something like a workaround:
If I vacuum before executing my index script (after my loading
script has terminated), or after other huge data movements, the server
doesn't crash. So, is this typical for hardware failures?

Thanks,
Andre.

On Sun, 30 Mar 2003, Tom Lane wrote:

>
> 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
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message muhammad umar 2003-03-31 10:50:02 Suggestion
Previous Message Neil Conway 2003-03-31 05:55:08 Re: Bug #928: server_min_messages (log_min_messages in CVS)