Re: ERROR: unexpected data beyond EOF - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: ERROR: unexpected data beyond EOF
Date
Msg-id 55426EDD.8090002@commandprompt.com
Whole thread Raw
In response to Re: ERROR: unexpected data beyond EOF  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 04/30/2015 10:28 AM, Alvaro Herrera wrote:
>
> Joshua D. Drake wrote:
>>
>> Alright folks,
>>
>> So I have this error:
>>
>> postgres[21118]: [8-1] ERROR:  unexpected data beyond EOF
>> in block 9 of relation base/430666195/430666206
>>
>> Which produces this lovely hint:
>>
>> postgres[21118]: [8-2] HINT:  This has been seen to occur with buggy
>> kernels; consider updating your system.
>>
>> However, the problem is, all relevant information we can find is Linux/NFS
>> based.
>
> I have vague recollections of seeing this relatively recently on tables
> that were truncated often.  Is that the case here?

Just dug into the table a bit and yes, it appears to be a transform 
table. Further questions/thoughts?

JD


-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.



pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: Relation extension scalability
Next
From: Andrew Dunstan
Date:
Subject: transforms vs. CLOBBER_CACHE_ALWAYS