Skip site navigation (1) Skip section navigation (2)

Re: CRITICAL HELP NEEDED! DEAD DB!

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 (view raw or flat)
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

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2004-09-24 21:05:54
Subject: PG Build Farm Status
Previous:From: Jim C. NasbyDate: 2004-09-24 20:26:09
Subject: Re: SQL-Invoked Procedures for 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group