| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Cott Lang <cott(at)internetstaff(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: CRITICAL HELP NEEDED! DEAD DB! |
| Date: | 2004-09-24 20:59:28 |
| Message-ID: | 41548AB0.8070402@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-09-24 21:05:54 | PG Build Farm Status |
| Previous Message | Jim C. Nasby | 2004-09-24 20:26:09 | Re: SQL-Invoked Procedures for 8.1 |