Re: CRITICAL HELP NEEDED! DEAD DB!

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