Re: Cannot read block 348938 of pdbsynchtable

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Cannot read block 348938 of pdbsynchtable
Дата
Msg-id o2t407d949e1004080945we228fb07y28e37f1f724f6390@mail.gmail.com
обсуждение исходный текст
Ответ на Cannot read block 348938 of pdbsynchtable  ("Utsav Turray" <utsav.turray@newgen.co.in>)
Список pgsql-general
On Thu, Apr 8, 2010 at 7:12 AM, Utsav Turray <utsav.turray@newgen.co.in> wrote:
> Even if If i try to pad the file  25205.3  using DD command I am not able to
> calculate the bytes to be padded as the total count of the blocks is comming
> out to be 521228 and the error is coming cannot read the 348938 block.

Assuming 25205 is the right file for this table then block 348938
would be in 25205.2 and be bytes 694,352kB - 694,360kB.

try

 dd if=25205.2 of=/tmp/data  bs=8192 skip=$(( 348938 - 2 * 128 * 1024)) count=1

see if you get the same error. If you do and you're happy to zero out
the bad block, deleting any data on it you could do something like:

 dd if=/dev/zero of=25205.2   bs=8192 seek=$(( 348938 - 2 * 128 *
1024)) count=1

--
greg

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: C-language functions: SRF question
Следующее
От: Jorge Arevalo
Дата:
Сообщение: Re: C-language functions: SRF question