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
|
| Список | pgsql-hackers |
2009/10/23 Dimitri Fontaine <dfontaine@hi-media.com>
I thought this would solve my problems but not yet ...João Eugenio Marynowski <joaoem@gmail.com> writes:It could be that the following will prove helpful:
> 2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
> block 462821 of relation "..."
http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php
http://pgsql.tapoueh.org/site/html/news/20080410.badblock.html
Regards,
--
dim
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 по дате отправления: