Re: ERROR: unexpected data beyond EOF in block XXXXX of relation "file"

Поиск
Список
Период
Сортировка
От austijc
Тема Re: ERROR: unexpected data beyond EOF in block XXXXX of relation "file"
Дата
Msg-id 19713228.post@talk.nabble.com
обсуждение исходный текст
Ответ на Re: ERROR: unexpected data beyond EOF in block XXXXX of relation "file"  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: unexpected data beyond EOF in block XXXXX of relation "file"  (David Fetter <david@fetter.org>)
Список pgsql-bugs
That's going to be a problem for the continued viability of Postgres.
Clustered systems using a NAS for data is a pretty common configuration
these days.  Oracle specifically supports it and even complains if your NFS
mount options are not correct.   Our Oracle DBs run great in this same
configuration and are a good 10-20 times faster than the local disk
performance along with the quick take-over capability if a system goes belly
up.

I'll try to isolate this problem with a simple C program to tell me what
software layer to look at.  Hopefully it's just a configuration issue.


Tom Lane-2 wrote:
>
> austijc <jaustin@jasononthe.net> writes:
>> The question is can anyone more familiar with this tell me what's going
>> on
>> here?  I don't know if this is a Postgres, Sun, or NetApp issue.  Could
>> it
>> be a work around for an old Linux bug causing an issue with acceptable
>> behavior of the NetApp device?
>
> People who try to run databases over NFS usually regret it eventually ;-)
>
> All I can say is that this error message has never before been reported
> by anyone who wasn't exposed to that lseek-inconsistency kernel bug.
> I am not finding it too hard to believe that NFS might be vulnerable to
> similar misbehavior.
>
>             regards, tom lane
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
>

--
View this message in context:
http://www.nabble.com/ERROR%3A--unexpected-data-beyond-EOF-in-block-XXXXX-of-relation-%22file%22-tp19680438p19713228.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #4438: regexpression gives the error by working with [
Следующее
От: "Steve Jones"
Дата:
Сообщение: BUG #4440: positioned_load in pos_newload failed