Skip site navigation (1) Skip section navigation (2)

Re: Bug (#3484) - Invalid page header again

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, alex <an(at)clickware(dot)de>
Subject: Re: Bug (#3484) - Invalid page header again
Date: 2007-12-19 10:45:28
Message-ID: 4768F648.2010009@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Gregory Stark wrote:
> "Zdenek Kotala" <Zdenek(dot)Kotala(at)Sun(dot)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



In response to

pgsql-bugs by date

Next:From: NikhilSDate: 2007-12-19 11:06:06
Subject: Re: BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)
Previous:From: Dave PageDate: 2007-12-19 10:03:41
Subject: Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group