Re: table corrupted - Mailing list pgsql-hackers

From João Eugenio Marynowski
Subject Re: table corrupted
Date
Msg-id 840f304c0910231836o4bb9c469v63da689fa68f936d@mail.gmail.com
Whole thread Raw
In response to Re: table corrupted  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: table corrupted
List pgsql-hackers
2009/10/23 Dimitri Fontaine <dfontaine@hi-media.com>
João Eugenio Marynowski <joaoem@gmail.com> writes:
> 2009-10-16 16:11:47 BRT 192.168.0.29 ERROR:  invalid page header in
> block 462821 of relation "..."

It could be that the following will prove helpful:
 http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php
 http://pgsql.tapoueh.org/site/html/news/20080410.badblock.html

Regards,
--
dim
I thought this would solve my problems but not yet ...
the block that I found is not presenting error...
 find_bad_block
----------------
 (514708,16)
(1 registro)
blockId / blocks_per_chunk = 514708 / 131072 = 3,9269104
base/21058/21271.3
chunk_block_id = block_id % blocks_per_chunk = 514708 % 131072 = 121492
is attached the result of pg_filedump -if -R 121492 /var/lib/postgresql/8.2/main/base/21058/21271.3
Even then I filled the block with zero
But when I run again the find_bad_block it show one block before, ctid 514707, and then, 514706 and I stop...
Any suggestion and explication?

--
João Eugenio
Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Statement Level Deferred Triggers
Next
From: Robert Haas
Date:
Subject: Re: Statement Level Deferred Triggers