X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1F4A78B9BF8 for ; Mon, 21 Feb 2005 22:30:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26055-10 for ; Mon, 21 Feb 2005 22:30:18 +0000 (GMT) Received: from web14124.mail.yahoo.com (web14124.mail.yahoo.com [66.163.171.115]) by svr1.postgresql.org (Postfix) with SMTP id A33BC8B9B9A for ; Mon, 21 Feb 2005 22:30:19 +0000 (GMT) Received: (qmail 31245 invoked by uid 60001); 21 Feb 2005 22:30:19 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=nA4BKDcjPfI/y+4q25yMfeyej/P+/TDPnBmiYPPPndHyhXYpnPtTJ6ZJ87BC0TREw/pU5xfvSA4HdEqiY0HgOi+y/6rMLFClixduwxiFr8lCXEA+ly/qgiXQESj6tio1hZ3DnCDDVkUyyw7fgaVBcxsF3ef6G0t3n+biolHt/JE= ; Message-ID: <20050221223019.31243.qmail@web14124.mail.yahoo.com> Received: from [65.4.200.58] by web14124.mail.yahoo.com via HTTP; Mon, 21 Feb 2005 14:30:19 PST Date: Mon, 21 Feb 2005 14:30:19 -0800 (PST) From: Christopher Smith Subject: Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <2123.1109017522@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-117865754-1109025019=:28199" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.367 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/204 X-Sequence-Number: 16372 --0-117865754-1109025019=:28199 Content-Type: text/plain; charset=us-ascii Tom, you are exactly CORRECT. One scsi down... crap! Thanks for the support and quick response! Tom Lane wrote: Christopher Smith writes: > ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error This is a hardware failure: your disk drive has dropped some sectors. I don't think you can do anything about it except go back to your last backup :-( Oh, and buy a new disk ASAP, before you lose any more data ... regards, tom lane --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' --0-117865754-1109025019=:28199 Content-Type: text/html; charset=us-ascii
Tom,

you are exactly CORRECT.  One scsi down... crap!
 
Thanks for the support and quick response!

Tom Lane <tgl@sss.pgh.pa.us> wrote:
Christopher Smith writes:
> ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error

This is a hardware failure: your disk drive has dropped some sectors.
I don't think you can do anything about it except go back to your last
backup :-(

Oh, and buy a new disk ASAP, before you lose any more data ...

regards, tom lane


Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term' --0-117865754-1109025019=:28199--