Re: table corrupted

Поиск
Список
Период
Сортировка
От João Eugenio Marynowski
Тема Re: table corrupted
Дата
Msg-id 840f304c0910231836o4bb9c469v63da689fa68f936d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: table corrupted  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: table corrupted  (João Eugenio Marynowski <joaoem@gmail.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Statement Level Deferred Triggers
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Statement Level Deferred Triggers