Re: Bug (#3484) - Invalid page header again - Mailing list pgsql-bugs

From Zdenek Kotala
Subject Re: Bug (#3484) - Invalid page header again
Date
Msg-id 4768F648.2010009@sun.com
Whole thread Raw
In response to Re: Bug (#3484) - Invalid page header again  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-bugs
Gregory Stark wrote:
> "Zdenek Kotala" <Zdenek.Kotala@Sun.COM> writes:
>
>> I got dump of affected two blocks from Alex and it seems that both blocks were
>> overwritten together with some 128bytes length structure (there some pattern)
>> and complete damaged size is 9728bytes (first block is overwritten completely
>> and second one only at the beginning), but another buffer from another relation
>> could be overwritten too.
>
> I don't understand this 9728 bytes. Postgres blocks are 8192 bytes. Are you
> saying one whole block is trashed and then part, but not all, of the next
> block?
>
> What's the block size of the ZFS filesystem? And what exactly does the trash
> data look like?
>

ZFS has dynamic block size (max 128kB), but this system runs on Linux probably
ext3 FS. Please, ale can you confirm used filesystem?

        Zdenek

pgsql-bugs by date:

Previous
From: "Alexander Steffens"
Date:
Subject: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)
Next
From: NikhilS
Date:
Subject: Re: BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)