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