Re: FATAL: could not open relation xxx: No such file or directory

Поиск
Список
Период
Сортировка
От Michael Monnerie
Тема Re: FATAL: could not open relation xxx: No such file or directory
Дата
Msg-id 200804221102.59695@zmi.at
обсуждение исходный текст
Ответ на Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
Ответы Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
Список pgsql-admin
On Donnerstag, 17. April 2008 Mikko Partio wrote:
> I run fsck on the filesystem (gfs) -- no problems found. The disks
> are from a san and the diagnostic programs say there's nothing wrong.
> I also have other db clusters running on different filesystems (also
> gfs) and I have never had any problems with them.

A bit OT, but maybe related: I have similar strangeness with a Linux box
with Areca controller. On this box, the reiserfs filesystem starts
getting seriously damaged after some time. Memtest showed no problems,
and everything looks fine. Today we will replace the mainboard, it
could have an internal problem (transport from memory to controller
broken?).

What I had twice (on different customers, once SCSI once SATA) is that a
broken hard disk reports no errors, but delivers different data than
what was written before. Very nasty, as the RAID controller doesn't see
any problem, and destroys even the good harddisks data after the next
write, because the read data is already broken.

HTH, good luck.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Mikko Partio"
Дата:
Сообщение: Re: FATAL: could not open relation xxx: No such file or directory
Следующее
От: "Mikko Partio"
Дата:
Сообщение: Re: FATAL: could not open relation xxx: No such file or directory