Re: ERROR: unexpected data beyond EOF

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.