unexpected data beyond EOF and character encoding - Mailing list pgsql-general

From Jaime Silvela
Subject unexpected data beyond EOF and character encoding
Date
Msg-id 460A672C.5060202@bear.com
Whole thread Raw
In response to Re: Strange behaviour under heavy load  ("Dmitry Koterov" <dmitry@koterov.ru>)
Responses Re: unexpected data beyond EOF and character encoding  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Thomas Burdairon
Date:
Subject: Re: Paranthesis and Driver JDBC
Next
From: "Dmitry Koterov"
Date:
Subject: How to speedup CHECKPOINTs?