pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEmergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
3+ messages / 2 participants
[nested] [flat]
* Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
@ 2005-02-21 18:38 Christopher Smith <christopherl_smith@yahoo.com>
2005-02-21 20:25 ` Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher Smith @ 2005-02-21 18:38 UTC (permalink / raw)
To: pgsql-admin
Emergency: I have a 200+ million row zip code radius table that has recently gone haywire.
I cannot access it and get the following error code
ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
My environment.
Postgresql 7.3.2
OS: Redhat Linux 7.2
Any ideas to fix this...
Thanks.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
2005-02-21 18:38 Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Christopher Smith <christopherl_smith@yahoo.com>
@ 2005-02-21 20:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-21 22:30 ` Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Christopher Smith <christopherl_smith@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-02-21 20:25 UTC (permalink / raw)
To: Christopher Smith <christopherl_smith@yahoo.com>; +Cc: pgsql-admin
Christopher Smith <christopherl_smith@yahoo.com> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
2005-02-21 18:38 Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Christopher Smith <christopherl_smith@yahoo.com>
2005-02-21 20:25 ` Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-02-21 22:30 ` Christopher Smith <christopherl_smith@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Christopher Smith @ 2005-02-21 22:30 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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'
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-21 22:30 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-21 18:38 Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error Christopher Smith <christopherl_smith@yahoo.com>
2005-02-21 20:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-21 22:30 ` Christopher Smith <christopherl_smith@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox