unexpected data beyond EOF and character encoding

Поиск
Список
Период
Сортировка
От Jaime Silvela
Тема unexpected data beyond EOF and character encoding
Дата
Msg-id 460A672C.5060202@bear.com
обсуждение исходный текст
Ответ на Re: Strange behaviour under heavy load  ("Dmitry Koterov" <dmitry@koterov.ru>)
Ответы Re: unexpected data beyond EOF and character encoding  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm doing dry runs to migrate my database from 8.1.3 to 8.2.3, with
pg_dumpall | gg_restore, using the executables from 8.2.3.
I'm seeing these messages

ERROR:  unexpected data beyond EOF in block 4506 of relation
"coverage_test_val"
HINT:  This has been seen to occur with buggy kernels; consider updating
your system.
CONTEXT:  COPY coverage_test_val, line 378036: "533359  61566
2007-02-01      DELINQUENCY6    16      0.356509255634  0.5     7"
ERROR:  unexpected data beyond EOF in block 414 of relation "rating"
HINT:  This has been seen to occur with buggy kernels; consider updating
your system.
CONTEXT:  COPY rating, line 56387: "840942      19548   2005-10-25
1       25      \N      1       \N"


The migration otherwise finishes successfully, but those two tables with
the EOF problem have count(*) = 0.

Can this really be a buggy kernel? Is there a list of known Linux
releases that are buggy? Of course, upgrading the kernel on a production
machine is the last thing I want to try...
And here's a theory: a while ago, someone installed pl/R on the database
to do statistics. Executing some pl/R functions would produce a crash of
all the connected clients, and I'd see "unexpected EOF" messages. I
immediately said we needed pl/R uninstalled, and the crashes stopped.
The encoding of my database is SQL_ASCII, which from what I've been
reading, is a non-encoding and will not perform any validation. Would it
be possible that some invalid characters crept  into tables related to
those pl/R crashes? Would porting to UTF8 fix this?

Is there a way I can fix those two cases of unexpected EOF so I can at
least perform the upgrade?

Thank you,
Jaime


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.

Bear Stearns does not provide tax, legal or accounting advice.  You
should consult your own tax, legal and accounting advisors before
engaging in any transaction. In order for Bear Stearns to comply with
Internal Revenue Service Circular 230 (if applicable), you are notified
that any discussion of U.S. federal tax issues contained or referred to
herein is not intended or written to be used, and cannot be used, for
the purpose of:  (A) avoiding penalties that may be imposed under the
Internal Revenue Code; nor (B) promoting, marketing or recommending to
another party any transaction or matter addressed herein.
***********************************************************************

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

Предыдущее
От: Thomas Burdairon
Дата:
Сообщение: Re: Paranthesis and Driver JDBC
Следующее
От: "Dmitry Koterov"
Дата:
Сообщение: How to speedup CHECKPOINTs?