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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Gon <marcin77(at)ymail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: unexpected data beyond EOF in block of relation "RelationName"
Date: 2009-07-23 14:48:57
Message-ID: 16356.1248360537@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcin Gon <marcin77(at)ymail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-07-23 15:10:15 Re: problem with pg_restore?
Previous Message Matthew Seaborn 2009-07-23 14:47:44 Search Path vs Synonyms