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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
