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

Hi,

Thanks for that. The question for me is how to find an appropriate OS patch for this? Is there a list of required patches for this Postgres release on SuSE?

Regards,
Marcin

--- On Thu, 23/7/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [GENERAL] ERROR: unexpected data beyond EOF in block of relation "RelationName"
> To: "Marcin Gon" <marcin77(at)ymail(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Thursday, 23 July, 2009, 2:48 PM
> 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
>