Re: ERROR: unexpected data beyond EOF

Hi,

On 2015-04-30 10:05:33 -0700, Joshua D. Drake wrote:
> postgres[21118]: [8-1] ERROR:  unexpected data beyond EOF
> in block 9 of relation base/430666195/430666206
> 
> FreeBSD 10
> ZFS
> iSCSI
> RAID 50 (don't start, I didn't spec it).
> fsync on, full_page_writes on
> 
> The restart of PostgreSQL makes the error go away and things progress
> normally. We don't experience further errors etc...

A couple questions:
1) Do you know what 430666206 refers to? Something like SELECT
oid::regclass, relkind FROM pg_class WHERE pg_relation_filenode(430666206) in the
correct database should answer.

2) Any chance you have zero_damaged_pages enabled?

3) Does the issue still occur? Is there any chance of manual
investigation before restaring the database?

Andres