Re: CRITICAL HELP NEEDED! DEAD DB! - Mailing list pgsql-hackers

From Joe Conway
Subject Re: CRITICAL HELP NEEDED! DEAD DB!
Date
Msg-id 41548AB0.8070402@joeconway.com
Whole thread Raw
In response to Re: CRITICAL HELP NEEDED! DEAD DB!  (Cott Lang <cott@internetstaff.com>)
List pgsql-hackers
Cott Lang wrote:
> I wish I knew - this is what appeared to start it:
> 
> Sep 24 10:19:41 snafu postgres[18176]: [464-1] ERROR:  could not open
> segment 1 of relation "idx_ordl_id" (target block 1719234412): No such
> file or
> Sep 24 10:19:41 snafu postgres[18176]: [464-2]  directory
> 
> I can't figure out what the exact problem is; there were no I/O errors
> or any other relative messages at the time, the box was empty, and
> nothing remarkable was going on.  :(

I saw that exact error message, with no logged I/O system errors, when 
using SAN attached storage a month or so ago. It turned out to be the 
SAN silently corrupting files. We did eventually start to see scsi 
errors, but not at the beginning.

Joe


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: SQL-Invoked Procedures for 8.1
Next
From: Andrew Dunstan
Date:
Subject: PG Build Farm Status