Re: ERROR: unexpected data beyond EOF in block of relation "RelationName" - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: unexpected data beyond EOF in block of relation "RelationName"
Date
Msg-id 16356.1248360537@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: unexpected data beyond EOF in block of relation "RelationName"  (Marcin Gon <marcin77@ymail.com>)
List pgsql-general
Marcin Gon <marcin77@ymail.com> writes:

> I'm getting the following error from my Postgres database while inserting:

> ERROR: unexpected data beyond EOF in block of relation "RelationName".

You omitted the HINT that says this has only been known to occur in
connection with buggy kernels.  I see you're running a fairly new
kernel, but it might still pay to inquire whether it's subject to the
wrong-lseek-result race condition that was around ahile back.

As far as getting out of the immediate problem is concerned, I think
restarting the postmaster ought to fix it.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: synchronous_commit=off doesn't always return immediately
Next
From: Matthew Seaborn
Date:
Subject: Search Path vs Synonyms